Lamar Owen <lamar.owen@wgcr.org> writes:
> Daniel Iordan wrote:
>> If you do not shut down the database correctly, with
>> /etc/init.d/postgresql stop (let's say you have a powercut),
>> when you try
>> /etc/init.d/postgresql start it doesn't work.
>> After deleting the file
>> /var/lib/pgsql/data/postmaster.pid everything is okay.
> Automatically deleting the pid file would be a bad thing.
Something is fishy here. The postmaster itself will probe to see if the
old postmaster is still there, and will delete the old postmaster.pid
file if not. If this is not working then either we have a
platform-specific bug in that processing, or the startup script is
getting in the way --- does the startup script itself look for a
postmaster.pid file?
regards, tom lane