Re: Loss of data and info from system tables!!

On Thu, Mar 31, 2005 at 03:12:53AM +0000, Noel Faux wrote:
>
> On the 27th March I notice that one of my web sites was giving me some
> weird errors. When I looked at the SQL statements generating these
> error I found that there were no results from these queries. When I
> selected on the table 'protein_database' I discovered that the database
> the web site refers to did not exist!! This was all fine 3 days prior!
> After further selects on more tables it became apparent there was data
> loss across a large number of tables. Now I feel extremely ill! It
> seemed that data which was added to the database when it was initially
> created was lost. As data which I have recently added was still there.

Are you doing regular VACUUMs of the database? What's the result of
the following query?

SELECT oid, xmin, cmin, xmax, cmax, datname,
age(datvacuumxid) AS vxid,
age(datfrozenxid) AS fxid
FROM pg_database;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/