Re: How to manually force a transaction wraparound

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Eric Ridge <eebbrr(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to manually force a transaction wraparound
Date: 2016-04-30 02:16:48
Message-ID: CAEepm=1hhJ0DB9+FSA=Zdh6Yp_tPfNWzD6fZXrphPm0mFioL4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Apr 30, 2016 at 10:48 AM, Eric Ridge <eebbrr(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2016-04-30 03:30:09 Why are data files stored in /var/lib
Previous Message Tom Lane 2016-04-29 23:31:11 Re: Allow disabling folding of unquoted identifiers to lowercase