Re: Postgres upgrade 12 - issues with OIDs

Thanks all for the ideas, we have chosen to resolve this using Logical Replication as we cannot use any other methods due to various constraints. Regards, Venkata B N Database Consultant On Mon, Nov 28, 2022 at 11:16 AM David Rowley wrote: > On Mon, 28 Nov 2022 at 12:46, Venkata B Nago

Question on Logical Replication

I have got a question on Logical Replication - we are using PostgreSQL version 11. We are operating in a high transaction environment - so, would like to know if disabling and enabling subscription is gonna miss any transactions ? Meaning - if a subscription is disabled and enabled after a few

Re: Postgres upgrade 12 - issues with OIDs

.. is there any other way to achieve this ? I think logical replication does not allow replicating from one table to another ? Regards, Ven On Sun, 16 May 2021 at 11:00 am, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Saturday, May 15, 2021, Venkata B Nagothi wrote: > >

Re: Postgres upgrade 12 - issues with OIDs

On Mon, May 10, 2021 at 9:26 AM Venkata B Nagothi wrote: > > > On Sat, 8 May 2021 at 1:47 pm, Laurenz Albe > 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 >

Re: Postgres upgrade 12 - issues with OIDs

On Sat, 8 May 2021 at 1:47 pm, Laurenz Albe 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 the

Re: Postgres upgrade 12 - issues with OIDs

Missed including pgsql-general group. On Sat, 8 May 2021 at 11:06 am, Venkata B Nagothi wrote: > > > On Wed, 5 May 2021 at 9:22 am, Bruce Momjian wrote: > >> On Wed, May 5, 2021 at 07:49:29AM +1000, Venkata B Nagothi wrote: >> > Hi There, >> > >> &

Postgres upgrade 12 - issues with OIDs

Hi There, We are attempting to upgrade our Postgres databases from 9.5 to 12.5 using pg_upgrade link mode and are facing issues with OIDs. ALTER TABLE... SET WITHOUT OIDs on the larger tables is taking very long and is locking up the table as well. We do have tables of more than 1 TB of size. Is

Re: oracle to postgresql conversion tool

On Thu, Feb 22, 2018 at 3:59 PM, Marcin Giedz wrote: > Hi, there are at least 5 tools I found on the PG list but could you > recommend well tested, free one ? we need to migrate production 30GB oracle > 11 db to postgres 9 and are looking for best approach. Of course if

Re: oracle_fdw Question

On Tue, 13 Feb 2018 at 5:55 am, chiru r wrote: > Hi, > > I am trying to install and configure the oracle_fdw on PostgreSQL DB > servers. > What we are trying is, inorder to install (make, make install) oracle_fdw > on all DB servers,we want to compile on one server and want

Re: Can postgresql ignore DST ?

On Fri, Dec 15, 2017 at 6:21 PM, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > Venkata B Nagothi wrote: > > > > We have Timezone configured to Australia/Sydney, we can change that > to 11 and do we need to foresee any issues ? > > > > > > That conf

Re: Can postgresql ignore DST ?

On Thu, 14 Dec 2017 at 7:28 pm, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > Venkata B Nagothi wrote: > > On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <t...@sss.pgh.pa.us> wrote: > > > Venkata B Nagothi <nag1...@gmail.com> writes: > > > > To rule o

Re: Can postgresql ignore DST ?

. Do Regards, Ven On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <t...@sss.pgh.pa.us> wrote: > Venkata B Nagothi <nag1...@gmail.com> writes: > > To rule out any application issues, is it possible to get postgresql to > > ignore DST and render all the timestamps with timezo

Can postgresql ignore DST ?

Hi All, I have a question regarding PostgreSQL time zones and daylight savings - We have been migrating Oracle databases to PostgreSQL and the database we are migrating from does not seem to follow daylight savings and it is good that postgresql does. When i query the date columns i get the