public inbox for [email protected]  

help / color / mirror / Atom feed

From: phb07 <[email protected]>
To: Andreas Kretschmer <[email protected]>
To: [email protected]
Subject: Re: Rollback table data.
Date: Sat, 10 Jun 2017 09:04:51 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

Hi Dinesh,

Le 07/06/2017 à 14:48, Andreas Kretschmer a écrit :
>
>
> Am 07.06.2017 um 13:33 schrieb Dinesh Chandra 12108:
>>
>> Dear Expert,
>>
>> Is there any way to rollback table data in PostgreSQL?
>>
>>
> if you are looking for somewhat similar to flashback in oracle the 
> answer is no.
>
Well, if this is what you are looking for, the E-Maj extension may help 
you. In few words, it allows 1) to log updates on tables sets (using 
triggers), 2) to set marks on these tables sets when they are in a 
stable state and 3) to travel back and forth to these marks.
Some pointers:
- pgxn to download a stable version : https://pgxn.org/dist/e-maj/ (the 
downloadable zip file also contains a presentation that may help to 
quickly get a good view of the extension - doc/emaj.2.0.1_doc_en.pdf)
- on-line documentation : http://emaj.readthedocs.io/
- github projects : https://github.com/beaud76/emaj and 
https://github.com/beaud76/emaj_ppa_plugin

Best regards. Philippe.
> Regards, Andreas
>



-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Rollback table data.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox