How can I start PostgreSQL on Windows?

Question

I have installed Postgresql on my Windows 10 PC. I have used the pgAdmin II tool to create a database called company, and now I want to start the database server running. I cannot figure out how to do this. I have run the start command on the postgres command line, and nothing seems to happen.

What I doing is:

postgres=# pg_ctl start postgres=# pg_ctl status postgres=# pg_ctl restart postgres=# pg_ctl start company postgres=# pg_ctl status 

.....-> I am seeing nothing returned.

Answer 1

Go inside bin folder in C drive where Postgres is installed. run following command in git bash or Command prompt:

pg_ctl.exe restart -D "<path upto data>" 

Ex:

pg_ctl.exe restart -D  "C:\Program Files\PostgreSQL\9.6\data" 

Another way: type "services.msc" in run popup(windows + R). This will show all services running Select Postgres service from list and click on start/stop/restart.

Thanks