On Tue, Nov 21, 2023 at 1:43 PM CG <cgg007@xxxxxxxxx> 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.