Horton

Thread

  1. Rollback table data.

    Dinesh Chandra 12108 <dinesh.chandra@cyient.com> — 2017-06-07T11:33:26Z

    Dear Expert,

Is there any way to rollback table data in PostgreSQL?

Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com<mailto:%7Cdinesh.chandra@cyient.com>
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.


________________________________

DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@cyient.com and delete the original message.

  2. Re: Rollback table data.

    Moreno Andreo <moreno.andreo@evolu-s.it> — 2017-06-07T12:42:44Z

    <html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix"><br>
      Il 07/06/2017 13:33, Dinesh Chandra 12108 ha scritto:<br>
    </div>
    <blockquote type="cite"
      cite="mid:ff86727641ec47d18d11d41e7d89f0e4@cyient.com">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Effra;
	panose-1:2 11 6 3 2 2 3 2 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:#1F4E79;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="color:#1F4E79">Dear Expert,<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F4E79"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F4E79">Is there any
            way to rollback table data in PostgreSQL?</span></p>
      </div>
    </blockquote>
    Not knowing anything else about your what you want to do and what
    context you're in, I can only say that AFAIK, once you COMMITted a
    transaction, no rollback is possible.<br>
    <br>
    A very quick google search gave me this:<br>
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss">https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss</a><br>
    <br>
    There's a long, detailed post from Craig Ringer that gives you some
    advise on how to proceed (given that a committed transaction cannot
    be ROLLBACKed)<br>
    <br>
    Take a look, I hope it's applicable to your scenario.<br>
    <br>
    HTH<br>
    Moreno.-<br>
  </body>
</html>

  3. Re: Rollback table data.

    Andreas Kretschmer <andreas@a-kretschmer.de> — 2017-06-07T12:48:41Z

    
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.

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

  4. Re: Rollback table data.

    Anthony Sotolongo <asotolongo@gmail.com> — 2017-06-07T13:23:03Z

    HI, If you dont vaccum the table, You can read data modified with 
pg_dirtyread extension, but be carefull ;-)

https://github.com/omniti-labs/pgtreats/tree/master/contrib/pg_dirtyread

Regards
On 07/06/17 07:33, Dinesh Chandra 12108 wrote:
>
> Dear Expert,
>
> Is there any way to rollback table data in PostgreSQL?
>
> *Regards,*
>
> *Dinesh Chandra*
>
> *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.*
>
> *------------------------------------------------------------------*
>
> Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com 
> <mailto:%7Cdinesh.chandra@cyient.com>
>
> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
>
>
> ------------------------------------------------------------------------
>
> DISCLAIMER:
>
> This email may contain confidential information and is intended only 
> for the use of the specific individual(s) to which it is addressed. If 
> you are not the intended recipient of this email, you are hereby 
> notified that any unauthorized use, dissemination or copying of this 
> email or the information contained in it or attached to it is strictly 
> prohibited. If you received this message in error, please immediately 
> notify the sender at Infotech or Mail.Admin@cyient.com and delete the 
> original message.

  5. Re: Rollback table data.

    Scott Marlowe <scott.marlowe@gmail.com> — 2017-06-08T00:15:44Z

    On Wed, Jun 7, 2017 at 5:33 AM, Dinesh Chandra 12108
<Dinesh.Chandra@cyient.com> wrote:
> Dear Expert,
>
>
>
> Is there any way to rollback table data in PostgreSQL?

You really need to give us more details. PostgreSQL has the ability,
through continuous archiving, to roll back to a previous point in
time. This is for the whole database ccluster though and not just one
table. BUT you can do it on a whole other machine, get the table data
you want, and put it into the production database etc.

Got more details?

  6. Re: Rollback table data.

    Philippe BEAUDOIN <phb07@apra.asso.fr> — 2017-06-10T07:04:51Z

    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
>