Re: Postmaster failing to start on reboot

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postmaster failing to start on reboot
Date: 2005-11-09 15:53:40
Message-ID: 15882.1131551620@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-09 16:07:56 Re: psql scripts
Previous Message Evandro's mailing lists (Please, don't send personal messages to this address) 2005-11-09 15:51:45 Re: Beyond the 1600 columns limit on windows