In my ethernet connection I've got only one IP address, and i've
tried with Static IP and with DHCP, and the error Stills.
Ii've got two aditional network adapters active (created by vmware
for virtualizations). May this be the cause of the error? I will try to
set postgres to listen only at one IP, and test if error stills.
Regards
Benedikt Schackenberg escribió:
how many IP addresses your computer? you will get your ip address via dhcp?
it sounds to me in such a way as if the postgreSQL service is no longer an
ip address can bind
-----Ursprüngliche Nachricht-----
Von: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Tk421
Gesendet: Mittwoch, 25. März 2009 12:25
Cc: pgsql-general@xxxxxxxxxxxxxx
Betreff: Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5
Power saving mode is disabled, and i get the error even until i'm
working.
Best regards
Benedikt Schackenberg escribió:
you have a power saving mode enabled? of inactivity when your pc shuts
down
etc?
King Regards
-----Ursprüngliche Nachricht-----
Von: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Tk421
Gesendet: Mittwoch, 25. März 2009 11:32
An: pgsql-general@xxxxxxxxxxxxxx
Betreff: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5
Hello everybody. In the last week i'm having a trouble with my
PostgreSQL working on Windows XP Professional.
When i boot, Postgresql works correctcly, but after about an hour it
stops working, an i get timeouts when i try to connect to it.
In the postgresql log, i get this message: 2009-03-25 10:52:57 CET
FATAL: could not duplicate socket 1276 for use in backend: error code
10022
After this, if i go to Event Viewer, i get this warning: PostgreSQL
Database Server 8.3 Service stopped.
In task manager, i get two postgres.exe process running, the first
one of 104 Kb, and the second about 5000 kb.
If i try to start postgresql service again, I got these messages:
Waiting for server startup...
LOG loaded library "$libdir/plugins/plugin_debugger.dll"
LOG could not bind IPv4 socket: No error
HINT is another postmaster already running on port 5432? If
not, wait a few seconds and retry.
WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP sockets
The service appears as starting, but it does not start.
If i kill the two postgresql porcessess the one of 5000kb stops
correctly, but i get access denied for killing the one of 104 Kb.
If i try to start postgresql service again, i can't, because it
stills starting, and i can't do anithing to it.
The only way is reboot the machine, but after about an hour, the
same history.
Before i detected this trouble last week, i had never got any problem
any idea?
King Regards
|
