Incomplete.
ADMIN:
Create a postgres user account. Prompt for a password.
net user postgres * /add
Download the PostreSQL 9.1.4 Windows 32-bit binaries from
http://get.enterprisedb.com/postgresql/postgresql-9.1.4-1-windows-binaries.zip.
Unzip to %PROGRAMFILES%PostgreSQL9.1.4
.
Add bin directory (%PROGRAMFILES%PostgreSQL9.1.4bin
) to the system path.
Create directory %PROGRAMFILES%PostgreSQL9.1.4data
.
Grant read, execute, and write for data to postgres.
icacls data /grant postgres:(OI)(CI)RXW
POSTGRES:
Initialize a new PostgreSQL database cluster at %PROGRAMFILES%PostgreSQL9.1.4data
. Call the superuser postgres
. Prompt for a superuser password on initialization.
initdb --username postgres --pwprompt --pgdata "%PROGRAMFILES%PostgreSQL9.1.4data"
ADMIN:
Grant read, execute, and write for all files in data to postgres.
TODO
POSTGRES:
C:Program FilesPostgreSQL9.1.4>pg_ctl register -N postgres-9.1 -U postgres -D
“%PROGRAMFILES%Postgres9.1data”
Fails:
pg_ctl: could not open service manager