Re: invalid data in PID file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "J S B" <jsbali(at)gmail(dot)com>
Cc: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: invalid data in PID file
Date: 2006-10-11 20:29:26
Message-ID: 27392.1160598566@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"J S B" <jsbali(at)gmail(dot)com> writes:
> Then i try to start postgres again and it gives me the same error:

> 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.

Um, have you tried waiting a bit as the hint suggests?

If the port is still claimed after a minute or two, then there must be
some process holding onto it. netstat and/or lsof might help you find
out what.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-10-11 20:29:58 Re: Newbie question about importing text files...
Previous Message Merlin Moncure 2006-10-11 20:06:42 Re: Is it possible to return custom type as proper ROW?