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