Re: Problem with txid_snapshot_in/out() functionality - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Problem with txid_snapshot_in/out() functionality
Date
Msg-id 20140412151837.GY14419@alap3.anarazel.de
Whole thread Raw
In response to Re: Problem with txid_snapshot_in/out() functionality  (Jan Wieck <jan@wi3ck.info>)
Responses Re: Problem with txid_snapshot_in/out() functionality  (Jan Wieck <jan@wi3ck.info>)
List pgsql-hackers
On 2014-04-12 11:15:09 -0400, Jan Wieck wrote:
> On 04/12/14 10:09, Greg Stark wrote:
> 
> >A pg_restore would start a new xid space from FirstNormalXid which would
> >obviously not work with any stored txids.
> >
> 
> http://www.postgresql.org/docs/9.3/static/app-pgresetxlog.html

Using that as part of any sort of routine task IMNSHO is a seriously bad
idea.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Problem with txid_snapshot_in/out() functionality
Next
From: Jan Wieck
Date:
Subject: Re: Problem with txid_snapshot_in/out() functionality