Thread: Installing PostgreSQL on Windows XP

Installing PostgreSQL on Windows XP

From
"Christian Henning"
Date:
Hi there, first post. I would like to share a solution for Windows
users having problems installing PostgreSQL 8.2.2. I couldn't find
anything in the docs and FAQ.

My installation routine went fine until it tried to start the postgres
service. This failed and there was no hint of why. So went to the
Service panel myself and tried to start the service. Now at least I
got the following error message:

Error 1068: The dependency service or group failed to start.

Surfing the net was no success but having a look at the event viewer
offered the following:

The PostgreSQL Database Server 8.2 service depends on the Net Logon
service which failed to start because of the following error:
%%0

Another important hint was this Net Logon error message

This computer is configured as a member of a work group, not as a
member of a domain. The Netlogon service does not need to run in this
configuration.


So putting all these information finally let to the MS kb269375 which
solved my problem. See http://support.microsoft.com/kb/269375

Let's see what's next. ;-)
Christian

Re: Installing PostgreSQL on Windows XP

From
Jim Nasby
Date:
BTW, 8.2.2 has a rather nasty bug; you'll want to go grab 8.2.3 or
8.2.1.

On Feb 7, 2007, at 10:30 AM, Christian Henning wrote:

> Hi there, first post. I would like to share a solution for Windows
> users having problems installing PostgreSQL 8.2.2. I couldn't find
> anything in the docs and FAQ.
>
> My installation routine went fine until it tried to start the postgres
> service. This failed and there was no hint of why. So went to the
> Service panel myself and tried to start the service. Now at least I
> got the following error message:
>
> Error 1068: The dependency service or group failed to start.
>
> Surfing the net was no success but having a look at the event viewer
> offered the following:
>
> The PostgreSQL Database Server 8.2 service depends on the Net Logon
> service which failed to start because of the following error:
> %%0
>
> Another important hint was this Net Logon error message
>
> This computer is configured as a member of a work group, not as a
> member of a domain. The Netlogon service does not need to run in this
> configuration.
>
>
> So putting all these information finally let to the MS kb269375 which
> solved my problem. See http://support.microsoft.com/kb/269375
>
> Let's see what's next. ;-)
> Christian
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



Re: Installing PostgreSQL on Windows XP

From
Alvaro Herrera
Date:
Jim Nasby wrote:
> BTW, 8.2.2 has a rather nasty bug; you'll want to go grab 8.2.3 or
> 8.2.1.

You don't want 8.2.1 either because it has a nasty security bug.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support