pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStarting PostgreSQL on WinXP is not working
3+ messages / 3 participants
[nested] [flat]
* Starting PostgreSQL on WinXP is not working
@ 2005-06-09 15:06 Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
0 siblings, 1 reply; 3+ messages in thread
From: Rodrigo Katsumoto Sakai @ 2005-06-09 15:06 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-admin
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!!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Starting PostgreSQL on WinXP is not working
@ 2005-06-09 16:24 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 3+ messages in thread
From: Magnus Hagander @ 2005-06-09 16:24 UTC (permalink / raw)
To: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>; pgsql-general@postgresql.org; +Cc: pgsql-admin
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Starting PostgreSQL on WinXP is not working
@ 2005-06-09 16:45 Bruno G. Albuquerque <balbuquerque@dba.com.br>
parent: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
0 siblings, 0 replies; 3+ messages in thread
From: Bruno G. Albuquerque @ 2005-06-09 16:45 UTC (permalink / raw)
To: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>; +Cc: pgsql-admin
Your Winsock stack is corrupted. You can try to sort it out by using a
program called "winsockxpfix".
http://www.snapfiles.com/get/winsockxpfix.html
-Bruno
Rodrigo Katsumoto Sakai wrote:
> 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!!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
**********************************************************************
Informação transmitida destina-se apenas à pessoa a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto de qualquer computador.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by person or entity other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
**********************************************************************
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-06-09 16:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-09 15:06 Starting PostgreSQL on WinXP is not working Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
2005-06-09 16:45 ` Bruno G. Albuquerque <balbuquerque@dba.com.br>
2005-06-09 16:24 Re: [GENERAL] Starting PostgreSQL on WinXP is not working Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox