On 7/29/2014 12:50 PM, gajendra s v wrote:
Is there any way to get history value in postgres database because in one table unfortunately we have updated value but we need old data check ,Is there any way to find old (Same table has updated multiple times),We need oldest data, please inform me is there any way to recover data?

got backups?

if you have a basebackup and a complete WAL archive, you can do a 'point-in-time recovery' up to some time prior to the updates that overwrote your data and retrieve the old values at that transactional point.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to