From: mallah@trade-india.com
To: p_appu@yahoo.com
Cc: pgsql-sql@postgresql.org
Cc: pgsq-admin@postgresql.org
Subject: Re: How to recover Data
Date: Tue, 26 Nov 2002 21:29:29 +0530 (IST)
Message-ID: <53554.203.145.129.4.1038326369.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <250323b6.0211252214.32c2bbbd@posting.google.com>
References: <250323b6.0211252214.32c2bbbd@posting.google.com>
Sridhar
such questions shud be posted to pgsql-admin list.
generally in case of power failure pgsql is unable to remove its
pid file., if u are using RPM based installation the file shud be in
/var/lib/pgsql/ in the name of postmaster.pid
If such a file exists postmaster will refuse to start. in such case
first remove that file. then start postmaster using
# /etc/rc.d/init.d/postgresql start
or better
# su - postgres
$ pg_ctl -l logfile -D /var/lib/pgsql/data
observe the recovery messages in logfile using
$tail -f logfile
in general such recoveries mostly succeeds and in no case
shud be inturrupted to avoid further (grave) complications.
Good Luck with your data,
regds
mallah.
PS: its not easy to loose data with pgsql ;-)
> 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
Only data directory is not sufficeint u need the pg_xlog directory as
well.
In any case such backups in prociple are not ok unless postmaster
is shut down during the cp.
>
> 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
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
> http://archives.postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
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: mallah@trade-india.com, p_appu@yahoo.com, pgsq-admin@postgresql.org
Subject: Re: How to recover Data
In-Reply-To: <53554.203.145.129.4.1038326369.squirrel@mail.trade-india.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