Re: Extract transaction from WAL

2019-11-21 Thread Marc Millas
Hi, funny enough, this pb looks similar to mine. the point is: how to guess: what is the "data I need" ?? Looks like we are looking for a way to ask postgres: which transactions have occurred between this and that. Obviously, if we can have, online, both the db after the PITR and the db "corrupted

Re: Extract transaction from WAL

2019-11-21 Thread Laurenz Albe
On Thu, 2019-11-21 at 12:11 +0400, Jill Jade wrote: > I am new to Postgres and I have a query. > > I have updated a table which I should not have. > > Is there a way to extract the transactions from the WAL and get back the > previous data? > > Is there a tool that can help to get back the tr

Re: Extract transaction from WAL

2019-11-21 Thread Michael Loftis
On Thu, Nov 21, 2019 at 04:56 Jill Jade wrote: > Hello everyone, > > I am new to Postgres and I have a query. > > I have updated a table which I should not have. > > Is there a way to extract the transactions from the WAL and get back the > previous data? > > Is there a tool that can help to ge

Extract transaction from WAL

2019-11-21 Thread Jill Jade
Hello everyone, I am new to Postgres and I have a query. I have updated a table which I should not have. Is there a way to extract the transactions from the WAL and get back the previous data? Is there a tool that can help to get back the transactions? Thanks in advance. Regards, Jill