How to start and stop PostgreSQL server?



On Windows

First, you need to find the PostgreSQL database directory, it can be something like C:\Program Files\PostgreSQL\10.4\data. Then open Command Prompt and execute this command:
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" start

 To stop the server
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" stop

 To restart the server:
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" restart

Another way:

 Open Run Window by Winkey + R
Type services.msc
Search Postgres service based on version installed.
Click stop, start or restart the service option.

Comments

Post a Comment

Popular posts from this blog

Postgresql Book References

Image
PostgreSQL -- Up and Running -- 1st Edition Url: https://drive.google.com/open?id=1cfZtwvN6MZDYxgSWR0cXxdgwd4TtghtG PostgreSQL -- Up and Running -- 2nd Edition Url: https://drive.google.com/open?id=1p6jNG6wyro-svzXfIKRGSsNoZddA4akh Beginning Databases with PostgreSQL -- From Novice to Professional (Beginning From Novice to Professional)  -- 2nd Edition Url: https://drive.google.com/open?id=1uQElel4BoIXGxqdqmYVbWToyYoRpoljA
Read more

Postgresql Tools

pgAgent   pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From pgAdmin v1.9 onwards, pgAgent is shipped as a separate application. Please note that this is not at all working with PG Admin4. No help in internet. Hence, ignore this option. 
Read more