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