From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Alban Hertroys <haramrae(at)gmail(dot)com>, itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: File System backup |
Date: | 2013-06-22 14:35:36 |
Message-ID: | 1371911736.84980.YahooMailNeo@web162906.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alban Hertroys <haramrae(at)gmail(dot)com> wrote:
> itishree sukla <itishree(dot)sukla(at)gmail(dot)com> wrote:
>> Can any one give me more suggestion, about this problem. Every
>> time my os got restart, postmaster.pid is missing.
The pid file should only be present when postgres is running. A
clean OS shutdown should stop postgres, which should result in the
pid file being deleted.
> Did you perhaps use reboot instead of shutdown -r? The former
> doesn't do a clean shutdown. That's how it is on *BSD at least, I
> don't know about Linux but I assume it behaves the same.
No, `reboot` actually calls `shutdown -r now` in the distros I've
used, including Ubuntu; unless you run it with the --force option.
> Check the logs to see if there are any errors when postgres tries
> to start up. It could be something as simple as a library version
> mismatch, or it could be data corruption in the database files.
Right, checking the log files is the thing to do. Adding or
deleting a pid file is just about never the right thing to do.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Angeletti | 2013-06-22 16:43:47 | WAL archiving not starting at the beginning |
Previous Message | Xiaobo Gu | 2013-06-22 12:06:44 | File size consideration of file_fdw in PostgreSQL |