Re: PostgreSQL doesn't accept connections when Windows

From: George Weaver <gweaver(at)shaw(dot)ca>
To: "Thomas H(dot)" <me(at)alternize(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL doesn't accept connections when Windows
Date: 2006-12-01 14:51:32
Message-ID: 004c01c71558$3216aa40$6400a8c0@Dell4500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Thomas

> netstat -a -n

Cool!

And -o gives me the pid of the process which I can match with processes
through the Task Manager...

> when another program is occupying the port, it would probabyl not make
> much difference, except if the pgsql service is started before the other
> tool.
>
> maybe pgsql is already running? ;-)

The problem I'm having is that if the server (Windows 2000) is rebooted, the
PostgreSQL service starts as expected, but won't accept connections. Bur if
the PostgreSQL service is then restarted manually (via Administrative Tools
> Component Services > Restart), the service runs as expected and everything
is normal.

If I understand what you're suggesting, perhaps upon reboot PostgreSQL is
starting before another app that listens on the same port, which could cause
the problem, but if I then restart the PostgreSQL service this solves the
problem?

Regards,
George

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2006-12-01 14:55:15 Re: FK locking still too strong
Previous Message Csaba Nagy 2006-12-01 14:37:54 FK locking still too strong