Обсуждение: 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: > 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. > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >