[postgis-users] general postgreSQL

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

Thanks for the feedback Markus;

I did what you suggested and there is just the one postmaster running 
where I installed it so nothing unexpected. 

Interestingly I found a discussion 
(http://www.dbforums.com/archive/index.php/t-968701.html ) that seems 
to indicate the message is related to IPv6 conflict and can be ignored.   


On 8 Jun 2004 at 10:53, Markus Schaber wrote:

> Hi, Eric,
> 
> On Mon, 07 Jun 2004 17:38:18 -0400
> Eric.Hillmuth at anr.state.vt.us wrote:
> 
> > For lack of a better option I upgraded to postgresql 7.4.2 and postGIS
> > 0.8.2. but this didn't seem to help. I still get:
> > 
> > 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.
> > 
> > 5432 opens when the postmaster starts up and closes when the
> > postmaster shuts down. I'm using "postmaster -D data -i" for startup
> > and "pg_ctl stop -D data -m fast" for shutdown. Things should be as
> > clean as can be so I'm not sure what its complaining about. I'd be
> > interested to know if anybody on the list is running SUSE 8.4?  
> 
> Issue the following command as root:
> 
> netstat --listening -n --tcp --program | grep 5432
> 
> You should get a line like 
> 
> tcp 0  0  0.0.0.0:5432  0.0.0.0:*  LISTEN  923/postmaster
> 
> This tells you which program and pid has the socket open (here it is
> postmaster with pid 923).
> 
> Then try:
> 
> ps auxf | grep 923
> 
> which should print something like:
> 
> postgres   923  0.0  1.0 35888 10876 ?       Ss   09:05   0:00 
/usr/lib/postgresql/bin/postmaster -i -p 5432 -D /crypt/postgres
> 
> So you know where your postmaster process came from, where its 
binary is.
> 
> Is this the location you installed your postmaster?
> 
> HTH,
> Markus
> 
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> 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