Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5 - Mailing list pgsql-general

On Wednesday 25 March 2009 5:58:33 am Tk421 wrote:
>     I've configured postgreSQL server to listen only in one IP address
> and the error stills.
>
>     Anyone has more ideas to solve it?

In the past week have you installed any other software or changed the behavior
of software? In particular I am thinking of Anti-Virus software.

The reason I ask is that as far as I can tell the error comes from the section
of postmaster.c that has the following comment:

/*
 * Duplicate a socket for usage in a child process, and write the resulting
 * structure to the parameter file.
 * This is required because a number of LSPs (Layered Service Providers) very
 * common on Windows (antivirus, firewalls, download managers etc) break
 * straight socket inheritance.
 */

This would seem to point another process interfering with the Postgres.


>
>     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@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von Tk421
> > Gesendet: Mittwoch, 25. März 2009 11:32
> > An: pgsql-general@postgresql.org
> > Betreff: [GENERAL] 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



--
Adrian Klaver
aklaver@comcast.net