Re: Test cluster with high OIDs above the signed-int limit (2B+) - Mailing list pgsql-general

From Tom Lane
Subject Re: Test cluster with high OIDs above the signed-int limit (2B+)
Date
Msg-id 195464.1776691778@sss.pgh.pa.us
Whole thread
In response to Test cluster with high OIDs above the signed-int limit (2B+)  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Test cluster with high OIDs above the signed-int limit (2B+)
List pgsql-general
Dominique Devienne <ddevienne@gmail.com> writes:
> Hi. A few weeks ago, one of our clusters, with high DDL churn from
> UTs, crossed the 2B mark for OIDs, which exposed a bug in our code.
> I'm moving into creating clusters on-the-fly for testing, and would
> like to force that situation to avoid a future silent regression,
> since it takes a long time to cross that threshold, and we do move up
> in major versions, so the over-the-threshold cluster will be
> abandoned. How can I achieve that?

See pg_resetwal --next-oid.  Don't recall what else you need to say
to avoid breaking the cluster in other ways.

            regards, tom lane



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Test cluster with high OIDs above the signed-int limit (2B+)
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Test cluster with high OIDs above the signed-int limit (2B+)