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
