[clug] Alarming SuSE/Postgres problem

[Antti.Roppola at brs.gov.au]

You wrote:

> If the system was running for more than a few hours (heck, five seconds of
> idle time is usually enough), then it's not the WAL, filesystem or IDE caches
> that caused your problem.

A few weeks and about 20 Mb of data.

> I would start looking at things like an update moving the database directory from

<snip>

Thanks for that, bingo! There's a database in /usr/local/pgsql. It also
gives me a sneaking suspicion of what may have changed the default location.
I created an RPM installer for PostGIS and while it *shouldn't* have done
anything other than install some libraries, I'll have to confirm that it's
not fiddling any startup files. That or a difference of opinion between
pg_ctl and /etc/init.d/postgresql.

Cheers,

Antti

---------------------------------------------------------------------- 
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 
----------------------------------------------------------------------