Re: [GENERAL] Starting PostgreSQL on WinXP is not working

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Rodrigo Katsumoto Sakai" <rodrigo(dot)sakai(at)poli(dot)usp(dot)br>, <pgsql-general(at)postgresql(dot)org>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] Starting PostgreSQL on WinXP is not working
Date: 2005-06-09 16:24:36
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C763F@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

> Hi, i'm working with PostgreSQL for a long time (about
> three years), but always on Linux box. But recently, I had to
> intall PostgreSQL on a WinXP machine!
> The installation works fine, although the starting service
> did not works in the finalization of the installation! The
> installation was done in a WinXP SP1 as a service!
> My problem is that I installed with admin rights, but
> created the user postgres for the system and user postgres
> for the database. The user postgres for the system is
> supposed to be used to start the service, but i think it is
> not happening, the system tries to start the service with the
> user that login in the system (the admin). If I trie to start
> the service with a user without admin privileges it gives me
> this error:
>
> 2005-06-08 15:14:07 NOTICE: Unknown win32 socket error code: 10106
> 2005-06-08 15:14:07 LOG: could not create IPv4 socket:
> Invalid argument
> 2005-06-08 15:14:07 WARNING: could not create listen socket
> for "localhost"
> 2005-06-08 15:14:07 FATAL: no socket created for listening
>
> I googled a lot and dind't find anything with this kind of
> error. So, I really need some help!
> Thanks a lot!!

10106 is "The requested service provider could not be loaded or
initialized.".

it looks like your TCP stack is broken somehow. I'd look into firewall
and antivirus software. Either it has some blocking functions that
returns weird results, or it's just broken in general.

//Magnus

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno G. Albuquerque 2005-06-09 16:45:05 Re: Starting PostgreSQL on WinXP is not working
Previous Message Rodrigo Katsumoto Sakai 2005-06-09 15:06:08 Starting PostgreSQL on WinXP is not working

Browse pgsql-general by date

  From Date Subject
Next Message Bruno G. Albuquerque 2005-06-09 16:45:05 Re: Starting PostgreSQL on WinXP is not working
Previous Message Tom Lane 2005-06-09 16:24:19 Re: Propogating conditions into a query