Home > Archive > PostgreSQL Discussion > May 2005 > urgent: another postmaster









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author urgent: another postmaster
Scott Frankel

2005-05-23, 8:24 pm


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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Scott Marlowe

2005-05-23, 8:24 pm

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

Scott Frankel

2005-05-23, 8:24 pm


Bingo -
Thanks!


On May 23, 2005, at 1:14 PM, Scott Marlowe wrote:

> On Mon, 2005-05-23 at 14:58, Scott Frankel wrote:
>
> 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
>



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com