Unable to Start PostgreSQL 8.1.4 on Windows XP - Mailing list pgsql-general

Hi:

   I installed PostgreSQL 8.1.0 on my computer running on
Windows XP Service Pack 2 last April. It works fine (I
don't use the database everyday though). Today, after being
unable to connect to the server,  I realized there must be
something wrong. Looking at the logs I found out that there
were no more entries after August 8. I surmise that after
August 8, the PostgreSQL service is not starting anymore. I
tried to start the service manually and through the command
prompt, but still it didn't work.

   After reading the FAQ, I did the following:
a) Uninstall a anti-spyware software (which was installed
around August 8).
b) Upgrade the server to PostgreSQL 8.1.4
c) Reboot the server
c) Temporarily disable the antivirus (Rising Antirus), I
did not uninstall the Antivirus because prior to August the
antivirus and the database server were running together
(ie. the antivirus didn't affect PostgreSQL).

   After taking these measures, the service is still unable
to start on its own . I tried to start the service through
the command line by typing the following command:

C:\Program Files\PostgreSQL\8.1\bin>"C:\Program
Files\PostgreSQL\8.1\bin\pg_ctl.
exe" runservice -N "pgsql-8.1" -D "C:\Program
Files\PostgreSQL\8.1\data\"

It gives me the following error message:
pg_ctl: could not start service "pgsql-8.1": error code
1063

Searching the web using google gives me the following
information about error 1063:
Error code 1063: ERROR_FAILED_SERVICE_CONTROLLER_CONNECT -
The service process could not connect to the service
controller. (from
http://user.tninet.se/~tdf275m/wincode2.htm)

   Here are I believe the last entries in the logfile:
2006-08-08 08:14:02 LOG:  database system was shut down at
2006-08-07 22:50:56
2006-08-08 08:14:02 LOG:  checkpoint record is at 0/4AEF40
2006-08-08 08:14:02 LOG:  redo record is at 0/4AEF40; undo
record is at 0/0; shu
tdown TRUE
2006-08-08 08:14:02 LOG:  next transaction ID: 40061; next
OID: 16447
2006-08-08 08:14:02 LOG:  next MultiXactId: 1; next
MultiXactOffset: 0
2006-08-08 08:14:03 LOG:  database system is ready
2006-08-08 08:14:05 LOG:  transaction ID wrap limit is
2147484148, limited by da
tabase "postgres"
2006-08-08 09:43:03 LOG:  received fast shutdown request
2006-08-08 09:43:07 LOG:  shutting down
2006-08-08 09:43:07 LOG:  database system is shut down
2006-08-08 09:43:09 LOG:  logger shutting down

Hope this helps.

Thanks in advance,
ludwig lim

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com