[postgis-users] general postgreSQL

[Eric.Hillmuth at anr.state.vt.us]

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