On Sat, 8 May 2021 at 1:47 pm, Laurenz Albe <laurenz.a...@cybertec.at>
wrote:

> 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.


Yes, we will have a lot of time to deal with the OID problem later, good
thing is we will be out of 9.5 with less trouble. Hopefully we will be on a
better replication architecture soon which will make it much easier for us.


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

Regards,

Venkata B N
Database Consultant

Reply via email to