Starting and Stopping PostgrSQL

To start and stop the default PostgreSQL please use the below steps

Switch to postgres user and execute the below commands:
# su - postgres
$ /var/local/postgresql-9.3.0/bin/pg_ctl -D /var/local/postgresql-9.3.0/data stop -mf
waiting for server to shut down.... done
server stopped
$ /var/local/postgresql-9.3.0/bin/pg_ctl -D /var/local/postgresql-9.3.0/data start
server starting
2017-09-06 18:20:28 IST [24742]: [1-1] user=,db=,app=,client= LOG:  could not bind IPv6 socket: Cannot assign requested address
2017-09-06 18:20:28 IST [24742]: [2-1] user=,db=,app=,client= HINT:  Is another postmaster already running on port 7432? If not, wait a few seconds and retry.
2017-09-06 18:20:28 IST [24742]: [3-1] user=,db=,app=,client= LOG:  redirecting log output to logging collector process
2017-09-06 18:20:28 IST [24742]: [4-1] user=,db=,app=,client= HINT:  Future log output will appear in directory "pg_log"

0 Comments

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *