From: p_appu@yahoo.com
To: pgsql-sql@postgresql.org
Subject: How to recover Data
Date: 25 Nov 2002 22:14:34 -0800
Message-ID: <250323b6.0211252214.32c2bbbd@posting.google.com> (raw)
I had a m/c with Postgres 7.2 and huge amount of data. on Power
failure and restart of the m/c pgsql refused connect to any of the
database. Being an invoice i took a tar of the data dir.
I tried reinstalling PGSQL and copied the data dir to the same dir
where the new data is being stored. ie
cp /backup/pgsql/data /var/lib/pgsql/data
When i connect to the old database i am able to connect but when i do
a \d to list the tables i get no relations found. Also when i do
select * from a table i am able to get the structure but it has no
records in it.
WHen i check the same info in pg_database to check if the old database
entry is present i dont find it.
Can someone help me as to how to recover my data???
Basically what i feel is update the pg_tables.
Thanks and rgds
Padmanab
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: p_appu@yahoo.com
Subject: Re: How to recover Data
In-Reply-To: <250323b6.0211252214.32c2bbbd@posting.google.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