Re: Rollback table data.

From: Anthony Sotolongo <asotolongo(at)gmail(dot)com>
To: Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>, "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Rollback table data.
Date: 2017-06-07 13:23:03
Message-ID: 7f7b5a26-34ac-6d90-5f37-635f05f0574a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 |dinesh(dot)chandra(at)cyient(dot)com
> <mailto:%7Cdinesh(dot)chandra(at)cyient(dot)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(dot)Admin(at)cyient(dot)com and delete the
> original message.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2017-06-08 00:15:44 Re: Rollback table data.
Previous Message Andreas Kretschmer 2017-06-07 12:48:41 Re: Rollback table data.