Re: Postmaster failing to start on reboot - Mailing list pgsql-general

From Tom Lane
Subject Re: Postmaster failing to start on reboot
Date
Msg-id 15882.1131551620@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postmaster failing to start on reboot  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> surabhi.ahuja wrote:
>> So,  I try starting postmaster. and it displays the following error
>> message: HINT:  If you're sure there are no old server processes
>> still running, remove the shared memory block with the command "ipcr
>> m", or just delete the file
>> "/export/home1/sdc_image_pool/dbx/postmaster.pid".
>>
>> does it means that i will have to delete the postmaster.pid file ..in
>> such a scenarion always?

> No, only when it doesn't close down properly. Check your system logs to
> see what happened.

Also, what PG version is this exactly?  More recent versions have better
defenses against being fooled by stale postmaster.pid files.  It matters
what postmaster startup script you're using, too.

            regards, tom lane

pgsql-general by date:

Previous
From: "Evandro's mailing lists (Please, don't send personal messages to this address)"
Date:
Subject: Re: Beyond the 1600 columns limit on windows
Next
From: "codeWarrior"
Date:
Subject: Re: insert on duplicate update?