Re: Postgres upgrade 12 - issues with OIDs

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Venkata B Nagothi <nag1010(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres upgrade 12 - issues with OIDs
Date: 2021-05-08 03:47:25
Message-ID: d48cbec2df2272f06763350941e9c217e48ab0d8.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2021-05-08 at 13:37 +1000, Venkata B Nagothi wrote:
> We are thinking to upgrade to PG 11 instead so that we can avoid doing ALTER TABLE.. SET WITHOUT OIDs.
> Does that makes sense ? Please advise if there are any gotchas !

It makes sense, but it means that you will have to face the same problem later.
However, for upgrading from v11 with little down time you may be able to use
logical replication.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sivapostgres@yahoo.com 2021-05-08 05:14:22 Re: Issue in PG start
Previous Message Venkata B Nagothi 2021-05-08 03:37:11 Re: Postgres upgrade 12 - issues with OIDs