[clug] Alarming SuSE/Postgres problem

Antti.Roppola at brs.gov.au Antti.Roppola at brs.gov.au
Fri Jun 17 01:07:55 GMT 2005

Hi all,

Recently I set up an "out of the box" SuSE 9.1 server with Postgres.

Everything has run swimmingly, except after a couple of weeks, I had
difficulties in restarting Postmaster when making config changes; the
.pid file had gone away. In the end, I created a pid file and shut down
Postmaster. When I restarted Postmaster, *all* the databases created
since the last restart had disapppeared. (eek!)

When Postmaster restarted, it didn't do a log recovery, as far as it
was concerned, that's how the database *ought* to look.

A bit of reading suggests that disk caching settings in Posgres and/or
the filsystem (ext3 on LVM on IDE) may be why (i.e defaults for fsync).
That or how WAL is set up. I'd really like to know what's going on before
trying to induce a repeat of the event. Ideas?



IMPORTANT - This message has been issued by The Department of Agriculture, Fisheries and Forestry (DAFF).  The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material.  It is your responsibility to check any attachments for viruses and defects before opening or sending them on.  
Any reproduction, publication, communication, re-transmission, disclosure, dissemination or other use of the information contained in this e-mail by persons or entities other than the intended recipient is prohibited.  The taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.  If you have received this e-mail in error please notify the sender and delete all copies of this transmission together with any attachments.  If you have received this e-mail as part of a valid mailing list and no longer want to receive a message such as this one advise the sender by return e-mail accordingly.  Only e-mail correspondence which includes this footer, has been authorised by DAFF 

More information about the linux mailing list