Introduction to PostgreSQL server startup and Shutdown

1. Start the database server (posgres user): [postgres @ localhostbin] $ S-dopt? SQL =t; opt=sqllo

1. Start the database server (posgres user): [postgres @ localhost bin] $ postgres-D/opt/postgresql/data/gt;/opt/postgresql/lo

1. Start the database server (posgres user ):

[S @ localhost bin] $ postgres-D/opt/postgresql/data/>/opt/postgresql/log/pg_server.log 2> & 1 &

[1] 4508

Of course, if environment variables are set

PGDATA=/Opt/postgresql/data

Export PGDATA

You can use the pg_ctl tool to start:

Because it has already been started, print "another server might be running ". In this case, view the log with the following information:

Of course, the simplest startup method is:

If you want to start PG when the operating system starts, you can add the following statement in the/etc/rc. d/rc. local file:

/Opt/postgresql/bin/pg_ctl start-l/opt/postgresql/log/pg_server.log-D/opt/postgresql/data

2. Disable the server

The simplest method:

Similar to Oracle, different modes can also be used when it is disabled. The introduction is as follows:

Example:

The fastest way to disable the kill ipvs Process

Note: The processes after postgre is started are as follows: