On Thu, Mar 19, 2015 at 07:02:28PM +0900, Prajilal KP wrote:
>
> When i see check the this file, the file itself exists but the size is "0"
> byte.
That suggests you have data corruption, and that you need to restore from
backup.
> The server is writing the whole log in to the mounted network storage, NFS.
There are reasons that people get nervous about databases on NFS. Are
you ensuring that Postgres fsync() calls (like when COMMIT happens)
are not being handled asynchronously?
Also, a trivial scan of the release notes in the 9.0.x series shows a
number of data corruption fixes since 9.0.4. You should always try to
stay on the latest minor release of your version of Postgres.
Best regards,
A
--
Andrew Sullivan
ajs@crankycanuck.ca