Postrgres data restoration problem

From: Jim Cochrane <jtc(at)dim(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postrgres data restoration problem
Date: 2003-12-05 07:14:33
Message-ID: 200312050714.hB57EXF29373@jupiter.milkyway.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm looking for help restoring old postgres databases on a linux system
after a reinstall of Redhat (including posgresql). It's the same version
of redhat and of postgres I was using before the resinstall, but I've not
been able to get the database server to see the old databases.

The old data is stored in the standard postgres format. (No,
unfortunately, I did not have a backup.) The postgres data is located
on my system under /var/lib/pgsql. So I tried both creating a
symbolic link - setting up /var/lib/pgsql/data as a symbolic link to
/oldpgsqlpath/data, and, when that didn't work, I just copied the old data
directory to /var/lib/pgsql (that is, it ended up residing in
/var/lib/pgsql/data), which didn't work either:

I was able to connect to an old database (e.g., with psql dbname), but
when I listed the tables with \d, it responds with: No relations found.
I suspect that the data may be unrecoverable. Is my pessimism justified or
might there be a way (without spending days, that is) to recover the old
data?

Thanks very much!
Jim Cochrane

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrei Bintintan 2003-12-05 08:11:11 Re: [ADMIN] Index not used. WHY?
Previous Message Tom Lane 2003-12-05 04:59:46 Re: 7.3.4 Question