Re: Install of Postgres 8.4 on Win Server 2k3 w SP2 Error

Hello Jonathan,

I had some challenges with the 8.4.1 windows one click installer,
especially as in some environments I am not "allowed" to use a local
postgres account. So to install 8.4.1 on various windows machines I
use the following process:

a) download the "binaries only" distribuion
b) create <program files>\PostgreSQL\ by hand
c) extract the "pgsql"-subdir from the binaries-zip and put it into
<program files>\PostgreSQL\
d) rename <program files>\PostgreSQL\pgsql to <program files>\PostgreSQL\8.4
e) add <program files>\PostgreSQL\8.4 to the system path
f) give the following commandos:

initdb --pgdata=d:\ghum\data84 --encoding=UTF-8
--locale=German_Germany.1252 --username=postgres
cacls data84 /G postgreswindowsuser:F /E /T
pg_ctl register -N pgsql-8.4 -D d:\ghum\data84 -U postgreswindowsuser
-P postgreswindowsuserpassword

that works for me on a variety of Windows Versions (Windows 7, XP, Server 2003),

maybe it can help you too in situations when the one-click-installer
is not suitable or leads to challenges.

(BTW: did you check in your situation that there are NO 8.3 binaries
within the System Path?)

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality