pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Drew Whittle <drew@albatross.co.nz>
To: pgsql-admin@postgresql.org
Subject: corrupt DB recovery
Date: 12 Aug 2004 15:10:16 +1200
Message-ID: <1092280216.25843.28.camel@mcp> (raw)

Hi Folks,

One of our production db's went down the other day, I have restored it
from backup to another server and now I am attempting to recover as much
of the data that was entered since the last backup.

Anyway, if I attempt to connect to the DB using psql I get the old
missing pg_clog entry error, in an attempt to fix that I created a 256k
0 filled file of the correct name.

The next attempt to connect via psql gets me a "no pg_class entry for
pg_proc" error.

If I start the db up in standalone mode the above error comes up and the
db immediately shuts down again.

I have attempted to scan across the data files for this db with
pg_filedump and it is not reporting any corrupted blocks. (but I'm not
sure I was doing it correctly)

I have two other db's that are 100% identical in everything but name and
data. (ie same structure etc), is it possible to use one of that data
files in them to over write the buggered file and fix the pg_proc error?
(and if so, is there an easy way to figure out which one, ie is pg_class
always in the 1249 data file?)

Any other suggestions that might get the data back or should I just
forget it and tell them to key it again?

Thx,

Drew




view thread (3+ messages)  latest in thread

Message-ID: <1092280216.25843.28.camel@mcp>
Permalink:  ../1092280216.25843.28.camel@mcp/
Also on:    postgresql.org/message-id/1092280216.25843.28.camel@mcp

 · 

reply

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: drew@albatross.co.nz
  Subject: Re: corrupt DB recovery
  In-Reply-To: <1092280216.25843.28.camel@mcp>
  References: <1092280216.25843.28.camel@mcp>

* 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