From: Steve Burrows <steve@jla.com>
To: pgsql-admin@postgresql.org
Subject: Lost tables in Postgres 7.1
Date: Mon, 13 Feb 2006 15:59:38 +0000
Message-ID: <43F0ACEA.4090503@jla.com> (raw)
OK, I know I should be running a later version, but we've been on this
since it came out and rebuilding the host is a big deal :( Last time we
did it was to move from 6.5 to 7.1 and we had to rebuild the whole
server (not the fault of PostgreSQL, just evolution).
Some of my tables have spontaneously disappeared. They are not visible
in pg_class. vacuuming pg_class (as suggested by Tom Lane for someone
with a similar problem) did not cause them to reappear. Doing a select
on the invisible tables returns a structure (column headings) but no
data. The log returned the following for the vacuum of pg_class,
suggesting that 44 tuples got shot.
DEBUG: --Relation pg_class--
DEBUG: Pages 31: Changed 0, reaped 17, Empty 0, New 0; Tup 1922: Vac
44, Keep/VTL 848/0, Crash 0, UnUsed 42, MinLen 115, MaxLen 160;
Re-using: Free/Avail. Space 11716/0; EndEmpty/Avail. Pages 1/0. CPU
0.00s/0.00u sec.
DEBUG: Index pg_class_oid_index: Pages 61965; Tuples 1922: Deleted 44.
CPU 4.71s/0.34u sec.
DEBUG: Index pg_class_relname_index: Pages 82270; Tuples 1922: Deleted
44. CPU 6.41s/0.39u sec.
DEBUG: Rel pg_class: Pages: 31 --> 30.
I have a copy of the pg_class table file from before it was vacuumed, so
in theory I still have the 'deleted' tuples. Is there any way of
recovering them? Any suggestions? We have backups and are rolling the
tape, but the reality is that we will of course lose the 2 days of data
entered since the last good backup which would be painful to reproduce.
Getting a bit desperate here, 7 years on PostgreSQL and never had a
problem like this before!
Thanks,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: steve@jla.com
Subject: Re: Lost tables in Postgres 7.1
In-Reply-To: <43F0ACEA.4090503@jla.com>
References: <43F0ACEA.4090503@jla.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox