Thread: Unable to Start PostgreSQL 8.1.4 on Windows XP

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

Ludwig Isaac Lim wrote on 15.08.2006 18:05:
> 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)
>

I had a similar issue several weeks ago. In my case the UMTS connection software
killed my Postgres installation. Did you change anything with your network
installation?

In my case either de-installing the UMTS software or applying a tool called
LSPFix would fix the problem: http://www.cexx.org/lspfix.htm

Hope this helps
Thomas

Hi Thomas :

--- Thomas Kellerer <spam_eater@gmx.net> wrote:

> Ludwig Isaac Lim wrote on 15.08.2006 18:05:
> > Searching the web using google gives me the following
> > information about error 1063:
> > Error code 1063:
> ERROR_FAILED_SERVICE_CONTROLLER_CONNECT -

> I had a similar issue several weeks ago. In my case the
> UMTS connection software
> killed my Postgres installation. Did you change anything
> with your network
> installation?
>
> In my case either de-installing the UMTS software or
> applying a tool called
> LSPFix would fix the problem:
> http://www.cexx.org/lspfix.htm
>
> Hope this helps
> Thomas
>

   Thanks for the quick reply. Actually, after running the
newly installed anti-spyware program a week ago I was
unable to access my internet. I'm not sure if the
anti-spyware program caused it though. During that period,
my computer was infected with spware,adware,virus. It was
only until after running lspfix that I was able to access
the internet.

    After reading your email, I tried running lspfix again
but it seems that this time, lspfix didn't detect any
problem in my network protocol drivers.

    Thanks for the idea though, it was a good one. From
what you had said, I have a hunch that the problem lies
with the network protocol driver.

ludwig lim

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