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

2014-07-29 Thread John R Pierce
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 one

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

2014-07-29 Thread John R Pierce
On 7/29/2014 1:06 PM, gajendra s v wrote: Thanks for quick reply. Sorry I didnt get base backup means, but I have database dump of every day ,our database is in AWS EC2. so take a dump from before you overwrote the data you need, restore it to a scratch database, and copy out your data. -

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

2014-07-29 Thread John R Pierce
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 i

[GENERAL] Is there any way to recover updated values from the table(Need old value)

2014-07-29 Thread gajendra s v
Hi All, 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? Tha