Re: recover deleted data

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: recover deleted data
Date: 2013-09-20 14:49:04
Message-ID: 1379688544.78119.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AI Rumman <rummandba(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2013-09-20 15:26:20 PostgreSQL SQL Tricks: faster urldecode
Previous Message AI Rumman 2013-09-20 14:40:47 recover deleted data