Re: Sudden stop of postmaster - Looking for help

Dave <not_here(at)due_to_spam(dot)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