Home › Start/Stop/Restart PostgreSQL server

Start/Stop/Restart PostgreSQL server 

voodoo
Joined:
04/07/2009
Posts:
135

July 01, 2010 16:57:31    Last update: July 01, 2010 16:57:31
Use the pg_ctl command to start/stop/restart the PostgreSQL server: 

$ bin/pg_ctl -D /usr/local/pgsql/data -l logs/postgres.log start

$ bin/pg_ctl -D /usr/local/pgsql/data stop

$ bin/pg_ctl -D /usr/local/pgsql/data restart

$ bin/pg_ctl -D /usr/local/pgsql/data status


Environment variable PGDATA can be set in lieu of the -D switch.
Share |
| Comment  | Tags