[postgis-users] general postgreSQL

[Darren Houston]

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
>