lost system tables: any hope?

From: Scott Rose <srose(at)telus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: lost system tables: any hope?
Date: 2001-12-05 15:08:50
Message-ID: 3C0E3882.5080700@telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm one of those people who created the system database on one partition
and put all the application databases on another. The latter was backed
up, but the former was not. And that drive crashed.

What I'm faced with now is the situation where I know that all my data
is still on disk, but the data structures that would let me access it
are lost forever. Even for a single-table database, postgresql (7.1.3 in
my case) creates about six dozen files, all named with numeric values.
I'm not seeing any documentation that would help me figure out what's
what, much less suture the files into a new set of system tables. About
as far as I can get is to run strings on the files and see which contain
what.

Armed with enough time, I'm sure one could reverse-engineer this stuff.
Of course, I'm not armed with enough time- I need to get back on the air
as soon as possible with several of these databases.

Any help out there? I've already figured out that I need a better
disaster recovery strateby for the future; it's the immediate present
that I need help with.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kirk Strauser 2001-12-05 15:40:27 I wrote a program to migrate Interbase -> PostgreSQL
Previous Message Michael Gundlach 2001-12-05 14:41:08 Re: Large tables management question