"J S B" <[EMAIL PROTECTED]> 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
Well, I've been very particular with the user id. There's just one single user ID am working on my postgres with.when i start the postgres, it creates the follwoing processes for postgres:1 S jsbali 4034 4033 0 76 0 - 2489 - 15:41 pts/2 00:00:00 postgres: logger process
1 S jsbali
"J S B" <[EMAIL PROTECTED]> writes:
> There was some problem with postmaster.pid file, so i just removed it.
Without bothering to stop the old postmaster first, I take it.
At this point your best bet is to find out the PID of the old postmaster
with "ps" and then kill it with "kill -INT ". I sus
Actually i've been trying to setup my postgres database in a new machine.the machine that i'm using right now is goin to die very soon. So i was trying to restore it in another machine but before that I have to install postgres in this new machine.
I installed postgres successfully, created a DB cl
Tom Lane wrote:
"J S B" <[EMAIL PROTECTED]> writes:
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
denied
Can you please tell me what is this all about?
It looks to me like you have, or had, another postmaster running under a
different userid. Perhaps you should bac
"J S B" <[EMAIL PROTECTED]> writes:
> FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
> denied
> Can you please tell me what is this all about?
It looks to me like you have, or had, another postmaster running under a
different userid. Perhaps you should back up to the begi
I deleted postmaster.pid file and got rid of the previous error.Now its a new error which say something as follows after i try starting my postgres server usring pg_ctl start -D /usr/local/pgsql/jsbali :-postmaster starting
LOG: could not bind IPv4 socket: Address already in useHINT: Is anothe
i never touched it. when i opened it to check the stuff inside, found it empty.What should i do now?On 10/11/06, Martijn van Oosterhout <
kleptog@svana.org> wrote:On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote:
> I'm trying to start my postgres server using>> #> pg_ctl start -D /usr/local/p
On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote:
> I'm trying to start my postgres server using
>
> #> pg_ctl start -D /usr/local/pgsql/abc
>
> and get an error like:
>
> invalid data in PID file "/usr/local/pgsql/abc/postmaster.pid"
>
> can anyone comment whats wrong.
>
> My postmaster.
