Re: pg_temp schema created while using DB Link

2020-05-08 Thread Jill Jade
). And these schemas keep on increasing each time the query using the db_link is run. Why the db_link is causing these schemas? Is there any issue with db_link? Thanks Regards, Jill On Fri, 8 May 2020 at 10:36, Laurenz Albe wrote: > On Fri, 2020-05-08 at 10:11 +0400, Jill Jade wrote: >

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