postgres on corporate windows

postgres on corporate windows

## set postgres data folder:
1. set env PGDATA = "C:/Development/psql_data"

2. RUN
   go inside bin folder of postgres and RUN
   initdb -D %PGDATA%


## create user
> createuser.exe -U <ROLE> --superuser --pwprompt <USERNAME>
> createuser.exe -U postgres --superuser --pwprompt deepanshu

{IF above is giving error, run psql in single user mode and crate user}

## RUN Postgres in single user mode
> "C:\Development\postgresql-17.6-2-x64-bin\pgsql\bin\postgres.exe" --single -D %PGDATA% postgres
> CREATE ROLE deepanshu WITH SUPERUSER LOGIN PASSWORD 'deepanshu';


## Run PostgreSQL:

1. WITH ADMIN privilege:
	> pg_ctl register -N "postgresql-17" -U postgres -D "C:\Development\psql_data"
	> pg_ctl register -N "postgresql-17" -U postgres -D %PGDATA%


2. without admin
	> pg_ctl -D %PGDATA% start

## make connection, once server is running connect with username and password
> psql -U deepanshu -d postgres -h localhost


## make db
> create database mydb;