[postgis-users] general postgreSQL
Eric.Hillmuth at anr.state.vt.us
Eric.Hillmuth at anr.state.vt.us
Tue Jun 1 06:23:45 PDT 2004
Thanks Darren;
That postmaster.pid file cleans up at shutdown and port 5432 closes too. How should
I go about looking for a connection pool deadlock?
On 27 May 2004 at 18:28, Darren Houston wrote:
> Hello Eric,
>
> One thought; If PostgreSQL crashed and postmaster.pid is residing in your
> PostgreSQL data directory, this might give the same error (just speculation).
> With postmaster off there should be no postmaster.pid. If this is the case and
> postmaster is off, delete postmaster.pid and try starting PostgreSQL again.
> Also, I have had connection pools deadlock that seem to keep a perpetual
> strangle hold on PostgreSQL, disabling a clean shutdown/restart.
>
> HTH somewhat,
>
> Darren H.
>
>
> Eric.Hillmuth at anr.state.vt.us wrote:
> >
> > Its more related to PostgreSQL than PostGIS but I haven't gotten there yet... Has
> > anyone run into an error like this from the postmaster on startup:
> >
> > LOG: could not bind IPv4 socket: Address already in use
> > HINT: is another postmaster already running on port 5432. If not, wait a few
seconds
> > and retry.
> >
> > I can confirm that port 5432 is opened by the postmaster at startup and closed at
> > shutdown with netstat etc. but I don't know why it prints this error. I'm running
> > PostgreSQL 7.4 on SUSE 8.4.
> >
> > Any thoughts are appreciated.
> >
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Eric Hillmuth
GIS Systems Developer
Vermont Agency of Natural Resources
eric.hillmuth at anr.state.vt.us
802-241-3616
More information about the postgis-users
mailing list