Postgres Pro
Downloads
Home   >   mailing lists

Re: How to manually force a transaction wraparound - Mailing list pgsql-general

From Thomas Munro
Subject Re: How to manually force a transaction wraparound
Date
Msg-id CAEepm=1hhJ0DB9+FSA=Zdh6Yp_tPfNWzD6fZXrphPm0mFioL4g@mail.gmail.com
Whole thread Raw
In response to How to manually force a transaction wraparound  (Eric Ridge <eebbrr@gmail.com>)
Responses Re: How to manually force a transaction wraparound
Re: How to manually force a transaction wraparound
List pgsql-general
Tree view 
On Sat, Apr 30, 2016 at 10:48 AM, Eric Ridge <eebbrr@gmail.com> wrote:
> I want to force my database to wraparound, just to see what happens.  How
> can I do this without consuming a few billion transactions?

Take a look at the script repro-bogus-subtrans-error-wraparound.sh
from this email:

http://www.postgresql.org/message-id/CAEepm=3z0EoLpo5wTUwseM38kbq+Gjp8xXiuLJkUqpM-SW7kAw@mail.gmail.com

That used pg_resetxlog -x $XID $PGDATA, but needed to do several hops
stop/pg_resetxlog/start hops to get all the way around the xid clock.

--
Thomas Munro
http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Allow disabling folding of unquoted identifiers to lowercase
Next
From: "Charles Clavadetscher"
Date:
Subject: Why are data files stored in /var/lib