Re: recover deleted data - Mailing list pgsql-general

From Kevin Grittner
Subject Re: recover deleted data
Date
Msg-id 1379688544.78119.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to recover deleted data  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
AI Rumman <rummandba@gmail.com> wrote:

> Is there any way to recover deleted record in Postgresql 9.2 if
> we don't have any backup.

I would recommend following the advice here *immediately*:

http://wiki.postgresql.org/wiki/Corruption

Any recoverable data may be disappearing through normal maintenance
operations as long as the server is running.

Then follow the advice in the "What next?" section of that page.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: recover deleted data
Next
From: Marc Mamin
Date:
Subject: PostgreSQL SQL Tricks: faster urldecode