public inbox for [email protected]
help / color / mirror / Atom feedRollback table data.
6+ messages / 6 participants
[nested] [flat]
* Rollback table data.
@ 2017-06-07 11:33 Dinesh Chandra 12108 <[email protected]>
0 siblings, 4 replies; 6+ messages in thread
From: Dinesh Chandra 12108 @ 2017-06-07 11:33 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: pgsql-performance
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 |[email protected]<mailto:%[email protected]>
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 [email protected] and delete the original message.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Rollback table data.
@ 2017-06-07 12:42 Moreno Andreo <[email protected]>
parent: Dinesh Chandra 12108 <[email protected]>
3 siblings, 0 replies; 6+ messages in thread
From: Moreno Andreo @ 2017-06-07 12:42 UTC (permalink / raw)
To: pgsql-performance
<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:[email protected]">
<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...;
<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>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Rollback table data.
@ 2017-06-07 12:48 Andreas Kretschmer <[email protected]>
parent: Dinesh Chandra 12108 <[email protected]>
3 siblings, 1 reply; 6+ messages in thread
From: Andreas Kretschmer @ 2017-06-07 12:48 UTC (permalink / raw)
To: pgsql-performance
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
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Rollback table data.
@ 2017-06-07 13:23 Anthony Sotolongo <[email protected]>
parent: Dinesh Chandra 12108 <[email protected]>
3 siblings, 0 replies; 6+ messages in thread
From: Anthony Sotolongo @ 2017-06-07 13:23 UTC (permalink / raw)
To: Dinesh Chandra 12108 <[email protected]>; [email protected] <[email protected]>; +Cc: pgsql-performance
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 |[email protected]
> <mailto:%[email protected]>
>
> 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 [email protected] and delete the
> original message.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Rollback table data.
@ 2017-06-08 00:15 Scott Marlowe <[email protected]>
parent: Dinesh Chandra 12108 <[email protected]>
3 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2017-06-08 00:15 UTC (permalink / raw)
To: Dinesh Chandra 12108 <[email protected]>; +Cc: [email protected] <[email protected]>; pgsql-performance
On Wed, Jun 7, 2017 at 5:33 AM, Dinesh Chandra 12108
<[email protected]> 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?
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Rollback table data.
@ 2017-06-10 07:04 phb07 <[email protected]>
parent: Andreas Kretschmer <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: phb07 @ 2017-06-10 07:04 UTC (permalink / raw)
To: Andreas Kretschmer <[email protected]>; pgsql-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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2017-06-10 07:04 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-06-07 11:33 Rollback table data. Dinesh Chandra 12108 <[email protected]>
2017-06-07 12:42 ` Moreno Andreo <[email protected]>
2017-06-07 12:48 ` Andreas Kretschmer <[email protected]>
2017-06-10 07:04 ` phb07 <[email protected]>
2017-06-07 13:23 ` Anthony Sotolongo <[email protected]>
2017-06-08 00:15 ` Scott Marlowe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox