[postgis-users] general postgreSQL

[Markus Schaber]

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