| From: | Tk421 <vrobador(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <aklaver(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, schackenberg(at)termindoc(dot)de |
| Subject: | Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5 |
| Date: | 2009-03-25 16:18:56 |
| Message-ID: | 49CA5970.7050108@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
No, the last week i didn't installed any software. The only
possible installation may be a instalation of some windows update. I
will look for it, and if there is some thing about any
antivirus/firewall update.<br>
<br>
Best regards.<br>
<br>
Adrian Klaver escribió:
<blockquote cite="mid:200903250636(dot)14996(dot)aklaver(at)comcast(dot)net"
type="cite">
<pre wrap="">On Wednesday 25 March 2009 5:58:33 am Tk421 wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> I've configured postgreSQL server to listen only in one IP address
and the error stills.
Anyone has more ideas to solve it?
</pre>
</blockquote>
<pre wrap=""><!---->
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.
</pre>
<blockquote type="cite">
<pre wrap=""> Best regards
Benedikt Schackenberg escribió:
</pre>
<blockquote type="cite">
<pre wrap="">you have a power saving mode enabled? of inactivity when your pc shuts
down etc?
King Regards
-----Ursprüngliche Nachricht-----
Von: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-general-owner(at)postgresql(dot)org">pgsql-general-owner(at)postgresql(dot)org</a>
[<a class="moz-txt-link-freetext" href="mailto:pgsql-general-owner(at)postgresql(dot)org">mailto:pgsql-general-owner(at)postgresql(dot)org</a>] Im Auftrag von Tk421
Gesendet: Mittwoch, 25. März 2009 11:32
An: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>
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
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2009-03-25 16:42:38 | Deferrable constraints |
| Previous Message | Mike Charnoky | 2009-03-25 16:09:39 | Re: intermittant performance problem |