PostgreSQL Windows 7 Installation Instructions

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s