How can I start PostgreSQL on Windows?

by

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

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. psql: FATAL: Ident authentication failed for user “postgres”
  4. Use multiple conflict_target in ON CONFLICT clause
  5. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  6. How to find table creation time?
  7. Go and IN clause in Postgres
  8. Where does PostgreSQL store the database?
  9. How to add “on delete cascade” constraints?
  10. Is there a way to disable function overloading in Postgres
  11. Grant all on a specific schema in the db to a group role in PostgreSQL
  12. Can I make a plpgsql function return an integer without using a variable?
  13. Migrate database from Postgres to MySQL [closed]
  14. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  15. Can’t connect the postgreSQL with psycopg2
  16. How do you change the character encoding of a postgres database?
  17. Difference between GiST and GIN index
  18. Test for null in function with varying parameters
  19. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  20. Can I use return value of INSERT…RETURNING in another INSERT?
  21. Changing a postgres containers server port in Docker Compose
  22. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  23. PostgreSQL – disabling constraints
  24. PostgreSQL authentication method 10 not supported
  25. Heroku database restore issue
  26. user postgres launches process that takes all CPUs 100% usage
  27. PostgreSQL array_agg order
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment