|
Hi everyone,
I recently installed PostgreSQL (Version 8.1.5.1)
using the MSI installer on a Windows Server 2000 system.
I ran the installer logged in under
an Administrator account, and set the service account to
postgres.
During the installation process, when it came time
to run initdb, the installer would stop with the error
message:
"Failed to run initdb:
128. Please see the logfile in 'C:\Program
Files\PostgreSQL\8.1\tmp\initdb.log.
Note! You must
read/copy this logfile before you click OK, or it will be automatically
removed."
I surmized that the problem was that I was
attempting to run the install as an Administrator, so I addressed the problem by
running the install, but not having the installer run initdb step to intialize
the database cluster. When the install finished without error, I then
logged onto the server under the postgres account and manually ran initdb.
I was able to initialize the cluster.
I then updated the postgresql.conf file with
"listen_addresses = '*' and changed the port from 5432 (currently being used for
a 7.3 server) to 5435.
Everything runs as expected.
Until the Windows Server is rebooted. When
this occurs, the PostgreSQL service starts as expected, but won't accept
connections.
If the PostgreSQL service is then restarted
manually (via Administrative Tools > Component Services > Restart),
the service runs as expected and everything is normal.
How can I correct this?
Thanks in advance,
George |
