PostgreSQL Snippits

gistfile1.txt

#Issues installing on windows and running post install script
First, setup postgres user:

Run: net user postgres dbpasswordhere /add
Run: compmgmt.msc -> Click Local Users and Groups -> Users -> postgres ->Member of -> Add… -> Administrators -> OK
Run: runas /user:postgres cmd.exe -> cd \ -> postgresql-install.exe -> installed successfully without errors. Checked data folder and confirmed files created successfully.
Run: compmgmt.msc -> Local Users and Groups -> Users -> postgres -> Member of -> Administrators -> Remove
Run: compmgmt.msc -> Local Users and Groups -> Users -> postgres -> Member of -> Add… -> Power Users -> OK