Re: Undo Update
| От | Rajesh Kumar |
|---|---|
| Тема | Re: Undo Update |
| Дата | |
| Msg-id | CAJk5Ata1HFUcku3RsiFtYxwxM4XwMgxz3Zg=niYOqq27T93vkQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Undo Update (Holger Jakobs <holger@jakobs.com>) |
| Ответы |
Re: Undo Update
Re: Undo Update |
| Список | pgsql-admin |
In that case, how to take a backup specifically before that update and are there any prequisites such as stopping the server when it happens? And then backup like that?
On Thu, 10 Aug, 2023, 2:36 PM Holger Jakobs, <holger@jakobs.com> wrote:
I'm afraid you will have to execute the SQL statement undoing it. Of you don't know the previous values, you're out of luck.
Then a backup is your best friend.Am 10. August 2023 11:02:26 MESZ schrieb Rajesh Kumar <rajeshkumar.dba09@gmail.com>:Hi friendsI was given a query to update the record in table A with where clause. But I executed it in production mistakenly without where clause so it updated incorrectly for all rows.How do I resolve this?
В списке pgsql-admin по дате отправления: