Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5

From: Tk421 <vrobador(at)gmail(dot)com>
To: schackenberg(at)termindoc(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5
Date: 2009-03-25 11:44:35
Message-ID: 49CA1923.8050608@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">
&nbsp;&nbsp;&nbsp; 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.<br>
<br>
&nbsp;&nbsp;&nbsp; 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.<br>
<br>
&nbsp;&nbsp;&nbsp; Regards<br>
<br>
Benedikt Schackenberg escribi&oacute;:
<blockquote cite="mid:001d01c9ad3d$7d155490$773ffdb0$(at)de" type="cite">
<pre wrap="">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&uuml;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&auml;rz 2009 12:25
Cc: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>
Betreff: Re: [GENERAL] 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&oacute;:
</pre>
<blockquote type="cite">
<pre wrap="">you have a power saving mode enabled? of inactivity when your pc shuts
</pre>
</blockquote>
<pre wrap=""><!---->down
</pre>
<blockquote type="cite">
<pre wrap="">etc?

King Regards

-----Urspr&uuml;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&auml;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
</pre>
</blockquote>
<pre wrap=""><!---->10022
</pre>
<blockquote type="cite">
<pre wrap=""> 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>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 4.1 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dědek Ondřej 2009-03-25 11:51:43 MAX(ROW(...)) - feature request
Previous Message Raymond O'Donnell 2009-03-25 11:42:31 Re: Single missing WAL in long sequence..