Re: Can we simulate Oracle Flashback with pg_export_snapshot()?

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'William Dunn *EXTERN*'" <dunnwjr(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can we simulate Oracle Flashback with pg_export_snapshot()?
Date: 2015-05-27 08:51:09
Message-ID: A737B7A37273E048B164557ADEF4A58B36616972@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

William Dunn wrote:
> In terms of benefit over a lagging replica Flashback has the benefit of being transparent to the user
> (the user can query over the same database connection, etc), it does not incur the full cost of having
> a replica...

Yes, Flashback (in all ist forms) is something that PostgreSQL doesn't offer.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-05-27 08:57:14 Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Previous Message Mitu Verma 2015-05-27 08:19:14 duplicate key value violates unique constraint "pg_class_relname_nsp_index"