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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match