Re: Removing oids with pg_repack

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Removing oids with pg_repack
Дата
Msg-id CANzqJaDvSjB=bfxk4EV=zH8LSQUgyc+GK9S==KwT6Rc+BDN5eA@mail.gmail.com
обсуждение исходный текст
Ответ на Removing oids with pg_repack  (CG <cgg007@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Connection fails on one system in a address range allowed to connect
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Removing oids with pg_repack