Search Postgresql Archives

Re: File System backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Alban Hertroys <haramrae@xxxxxxxxx> wrote:
> itishree sukla <itishree.sukla@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux