Re: Is there any way to recover updated values from the table(Need old value)

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there any way to recover updated values from the table(Need old value)
Date: 2014-07-29 22:22:22
Message-ID: 53D81E9E.8070506@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/29/2014 1:29 PM, gajendra s v wrote:
> Sorry to disturb you again, I have imported old backup, is there any
> way to find how many times transaction has happened for 24 hrs
> duration to perticular table with update query because by mistakenly
> our java application has update different values ones.

the backup dump just stores the current values. and, postgres stores no
history of transactions or anything, unless you've implemented some sort
of auditing mechanism such as triggers that log update/insert events
into special audit tables you've created.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jon Rosebaugh 2014-07-29 23:22:40 Joining on CTE is unusually slow?
Previous Message David G Johnston 2014-07-29 21:00:08 Re: tab_to_sting