Re: Sudden stop of postmaster - Looking for help - Mailing list pgsql-admin

From Tom Lane
Subject Re: Sudden stop of postmaster - Looking for help
Date
Msg-id 8347.1048100603@sss.pgh.pa.us
Whole thread Raw
In response to Sudden stop of postmaster - Looking for help  (Dave <not_here@due_to_spam.com>)
List pgsql-admin
Dave <not_here@due_to_spam.com> writes:
> bash-2.05a$ pg_ctl start -D /var/lib/pgsql/data -s
> pg_ctl: Another postmaster may be running.  Trying to start postmaster
> anyway.
> Found a pre-existing shared memory block (ID 196608) still in use.
> If you're sure there are no old backends still running,
> remove the shared memory block with ipcrm(1), or just
> delete "/var/lib/pgsql/data/postmaster.pid".

> bash-2.05a$ rm /var/lib/pgsql/data/postmaster.pid

Are you certain there wasn't a postmaster still running?  I think you
may have just shot yourself in the foot.  I'd recommend shutting down
postgres and making sure (with ps) that there are no remaining
postgres-owned processes.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Miguel Angel Martin"
Date:
Subject: ¿What's wrong?
Next
From: "Sidar Lopez Cruz"
Date:
Subject: admin tool