Docker Quick Start-common docker commands 1. Introduction to docker commands 1. Introduction to docker commands
You can run the sudo docker or sudo docker HELP command to view the docker
:14.04)
Remove Image: Docker rmi-f (mandatory) Docker.io/ubuntu
Delete Container: Docker rm python_test
Port mapping: Docker run-t-p–expose 22–name Server ubuntu:14.04 (-p need to specify the –expose option when using, specify ports that need to be serviced externally)
Bind port to specified interface: sudo docker run-
SIGTERM
New connections are no longer allowed, but all active sessions are allowed to complete their work properly, and are closed only after all sessions have completed the task. This is smart off.
SIGINT
No new connections are allowed, send SIGTERM to all active servers (let them exit immediately), and wait for all child processes to exit and close the database. This is quick to close.
Sigquit
Causes Postgres to send sigquit t
Tags: res command src. SH name touch Shell strong imageThe first step: Connect to the Linux service via Xshell or other tools,Step Two: Create a script: Touch se.shStep three: Enter I to enter the following command on behalf of the start input:The script is as follows: (SQL statement can be any complex SQL, simple to write here)! /bin/shPsql-h 127.0.0.1-u postgres-w-D db_test >/root/zyy SELECT * from Test;EofScript parsing:-H represents the IP of the
"Peer Authentication" means that it ' s comparing your database username against your Linux username. It should work if your ' re logged in as postgres . You probably don ' t want md5 pg_hba to hits that rule in, as the postgres database user generally doesn ' t has a password.–The problem you has is, so if u dont define the Host, your system would decide.Explicit add "-H localhost", this would fix itPg_dum
PostgreSQL-based scalable, open-source Big Data cluster database: POSTGRES-XLhttp://www.postgres-xl.org/Postgres's-XL is a scale-out open source SQL database cluster based on the PostgreSQL database, with sufficient flexibility to handle different database workloads:
OLTP Write-Frequent business
Requires MPP parallel Business intelligence
Operational Data storage
Key-value Storage
Geographic space of GIS
Mixed Business Wor
One: Command line Backup and recovery Postgres database①: First switch to Postgres userSu Postgres
②: Backing up a database named host to a temporary file Host.dumpPg_dump-w Host >/tmp/host.dump
③: Import data from backup file infile to database named dbnamePsql dbname
Second: Update a data record in a datasheet①: Log in to the database as a
Summary of Postgres operations in Ubuntu
1.Basic operation commands
After the installation is complete, PostgreSQL creates a database user account named Postgres by default. It is a super Administrator account like the root account of MySQL and the SA account of sqlserver, but unlike MySQL, postgreSQL also created a Unix account named S.
Like the master database of sqlserver, the default database o
This is a creation in
Article, where the information may have evolved or changed.
Github.com/lib/pq
PG is a pure go write driver of the Postgres database. The author gave us a little joke, the PQ will always be habitually written PG there is no ... The installation method is as follows:
go get github.com/lib/pq
Register
As mentioned earlier, driver needs to call Sql.register to register the Driver.driver type interface driver implementation by name. T
Php page access to IPVs database problems the local machine is equipped with php, apache, postgres database nbsp; I want to insert the data in the page from the browser php page to the local database, the code I wrote must be correct, but it means that the data cannot be inserted into the database (during the runtime, he only runs the code before the database code is connected, and then does not leave, and no error is reported, but the code is absolu
in the CREATESTMT structure, and then control whether or not to create a table or make an error message.Get the current user name as followsDatumcurrent_user (Pg_function_args) {pg_return_datum (DirectFunctionCall1 (Namein, Cstringgetdatum ( Getusernamefromid (GetUserId ()))));}This function is the intrinsic function of the PG, using the effect:postgres=# Select Current_User; Current_User--------------Postgres (1 row)In this way, you can complete the
S skills, Postgres skills
If you need to add indexes when the business volume is large, you need to use CONCURRENTLY. Otherwise, your database will easily break down.
For example
create index CONCURRENTLY idx_order_records_bank_statist_uid on order_records(statist_uid)
See
Http://www.postgresql.org/docs/9.1/static/sql-createindex.html
In a large business volume, if you want to execute some time-consuming database tasks, sometimes you will fin
PHP page access to postgres database issues
This machine is equipped with Php,apache,postgres database
I want to insert the data from the page into the native database from the browser PHP page, I write the code is certainly correct, but just can't insert the data into the library (run, he only run the code before the library code, and then do not go, and no error, but the code is absolutely correct, the fo
Postgres-XL: PostgreSQL-based open-source scalable Database Cluster,Postgres-XL: PostgreSQL-based open-source scalable Database ClusterIn the past year, IOE has become more and more popular in the industry. Many traditional enterprises have also placed their "IOE" plans on their desktops. I have always wondered why these non-Internet companies (such as banks) are motivated to do this? The empty slogans such
in dockerfile, instead of directly installing the software using the shell of the docker container.
To be honest, I sometimes like to install software in shell. Maybe you also like to install all the software in shell. However, you still need to specify the Installation File in doockerfile. To install the software in shell, you must:
$dockerrun-i-tubuntubash# Log on to the docker container[emailpr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.