Postrgres data restoration problem

Поиск
Список
Период
Сортировка
От Jim Cochrane
Тема Postrgres data restoration problem
Дата
Msg-id 200312050714.hB57EXF29373@jupiter.milkyway.org
обсуждение исходный текст
Ответы Re: Postrgres data restoration problem  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
Re: Postrgres data restoration problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.3.4 Question
Следующее
От: Alan Graham
Дата:
Сообщение: Re: Trigger to call an external program