Re: Removing oids with pg_repack - Mailing list pgsql-general

From Ron Johnson
Subject Re: Removing oids with pg_repack
Date
Msg-id CANzqJaDvSjB=bfxk4EV=zH8LSQUgyc+GK9S==KwT6Rc+BDN5eA@mail.gmail.com
Whole thread Raw
In response to Removing oids with pg_repack  (CG <cgg007@yahoo.com>)
List pgsql-general
On Tue, Nov 21, 2023 at 1:43 PM CG <cgg007@yahoo.com> wrote:
I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as little downtime as possible so I can prep the database for upgrade past PostgreSQL 11. I had a wild idea to mod pg_repack to write a new table without oids. I think it almost works. 

Too bad that pg_dump doesn't have an --exclude-oids option. 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Connection fails on one system in a address range allowed to connect
Next
From: Tom Lane
Date:
Subject: Re: Removing oids with pg_repack