urgent: another postmaster
After a server crash forced a reboot, `pg_ctl start` fails with a FATAL
error. Log output says that the lock file, postmaster.pid, already
exists.
Can I just su to root and delete the .pid file to relaunch? Or will
this have nasty side-effects?
Thanks in advance!
Scott
On Mon, 2005-05-23 at 14:58, Scott Frankel wrote:
After a server crash forced a reboot, `pg_ctl start` fails with a FATAL
error. Log output says that the lock file, postmaster.pid, already
exists.Can I just su to root and delete the .pid file to relaunch? Or will
this have nasty
Just check first to make sure there really are no postmasters running
and you should be safe
ps aex|grep post
and if there's no output, delete the pid file. If there really are
other postmasters or postgreses running, then kill them first.
Bingo -
Thanks!
On May 23, 2005, at 1:14 PM, Scott Marlowe wrote:
Show quoted text
On Mon, 2005-05-23 at 14:58, Scott Frankel wrote:
After a server crash forced a reboot, `pg_ctl start` fails with a
FATAL
error. Log output says that the lock file, postmaster.pid, already
exists.Can I just su to root and delete the .pid file to relaunch? Or will
this have nastyJust check first to make sure there really are no postmasters running
and you should be safeps aex|grep post
and if there's no output, delete the pid file. If there really are
other postmasters or postgreses running, then kill them first.---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings