CODEWITHSUNDEEP
postgresql
Azhar
Azhar

Reputation: 989

How to Start PostgreSQL in Windows

I would like to configure PosgreSQL in Windows machine.

Every time we have to recall the configuration process.

Please find the process below.

Upvotes: 0

Views: 1531

Answers (1)

Azhar
Azhar

Reputation: 989

Please follow below steps to configure PG in local

  1. Download PG latest version

  2. Create PD Data folder : and run below command d:\pg14\pgsql\bin\initdb -D "d:\pgdb\pgdata"

  3. Start DB with pgdata folder, place below in bat file and run
    d:\pg14\pgsql\bin\pg_ctl -D "d:\pgdb\pgdata" start -U postgres -P pgpwd -S auto

  4. Create user : d:\pg14\pgsql\bin\psql postgres

    postgres=#CREATE USER postgres SUPERUSER;

    you can create user if you want.

  5. You can connect from any GUI pgAdmin or any other tools

Upvotes: 2

Related Questions