M
M
m0ody2015-07-06 19:18:32
PostgreSQL
m0ody, 2015-07-06 19:18:32

Are there ways to rollback an UPDATE in PostgreSQL?

Due to a programming error, an incorrect UPDATE was performed (UPDATE ... SET group=1). There are no backups.
Tried this:
How to rollback an UPDATE in PostgreSQL via pg_xlog?
blog.nkuznetsov.me/2012/04/update-postgresql-pgxlo...
but this method did not work for me (there are no previous values ​​in the logs).
Are there any options to rollback a request?

Answer the question

In order to leave comments, you need to log in

4 answer(s)
P
protven, 2015-07-06
@protven

Congratulations on your valuable experience.

A
Andrey Burov, 2015-07-06
@BuriK666

Apparently not anymore.

M
Mr Freeman, 2015-07-06
@vladamir

Transactions give!

A
AlikDex, 2015-07-06
@AlikDex

without transactions is a tin. completely without bekabs, this is triple the tin.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question