Re: File System backup

On Jun 21, 2013, at 12:53, itishree sukla <itishree(dot)sukla(at)gmail(dot)com> wrote:

> Hi all,
>
> Can any one give me more suggestion, about this problem. Every time my os got restart, postmaster.pid is missing.

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.

> After that createing postmaster.pid is also not helping to start the server.

Ehrm no, the opposite in fact. If the postmaster PID exists, the postmaster won't start because having multiple postmasters running would get you data corruption.

> I am using postgresql 9.2 in ubuntu, with default installation. Is there any possibility i can take the Data directory backup, and install postgresql server, then restore Data directory. Will it work to get back my databases.

What do you hope to accomplish by reinstalling the software? That's most likely not where the problem is.

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.

What file-system is the database on? Is it possible a journal rollback caused inconsistency in the database?

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.