Setting up PostGRE SQL Database on Windows 10

Get PostgreSQL from here:
https://www.postgresql.org/download/windows/
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads




To start the DB:

C:\Program Files\PostgreSQL\11\bin>pg_ctl -D "C:\Program Files\PostgreSQL\11\data" start

• waiting for server to start... 2019-07-13 21:43:40.833 IST [22656] LOG:  listening on IPv6 address "::1", port 5432
• 2019-07-13 21:43:40.834 IST [22656] LOG:  listening on IPv4 address "127.0.0.1", port 5432
• 2019-07-13 21:43:41.712 IST [22728] LOG:  database system was shut down at 2019-07-13 17:28:37 IST
• 2019-07-13 21:43:42.824 IST [22656] LOG:  database system is ready to accept connections
• Done

Add this directory location to the PATH variable and you can access ’pg_ctl’ from anywhere.
“C:\Program Files\PostgreSQL\11\bin”

Setting up PostGRE DB 

Launch “pgAdmin3.exe” from here:
C:\Program Files (x86)\PostgreSQL\9.3\bin

OR

For PostGRE 11, launch “pgAdmin4” from here:
C:\Program Files\PostgreSQL\11\pgAdmin 4\bin

Password for “postgres” user: postgres

C:\Users\ashish>psql -U postgres
Password for user postgres:
psql (11.4)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

postgres=#