Re: Oracle to PostgreSQL Migration

EDB has migration toolkit , which is very helpful in migration from Oracle to EDB. Thanks and Regards Paramjib Baruah On Tue, Mar 21, 2023 at 9:12 PM Marc Millas wrote: > EDB do have a replication server which can be used to transfer real time > data from oracle to postgres. > don't know if it

RE: Logical replication fails when adding multiple replicas

On Monday, March 20, 2023 8:46 PM Will Roper wrote: Hi, > We’re having some issues with Postgresql’s logical replication. Specifically > trying to add several replicas at once. Essentially we can add replicas one at > a time, but when we try and add two or more together some of the table > sub

Re: Is there psql cluster or replication

2023年3月22日(水) 8:47 Vince McMahon : > > Is there cluster on postgres? Or, there is replication, not cluster. > > If there is active/passive cluster or active/active , may I have the steps to > configure them? See here for details about PostgreSQL's built-in streaming replication. https://www

Is there psql cluster or replication

Is there cluster on postgres? Or, there is replication, not cluster. If there is active/passive cluster or active/active , may I have the steps to configure them?

Re: Re[2]: Getting error while upgrading postgres from version 12 to 13

On Tue, 21 Mar 2023 at 16:06, Geoff Winkless wrote: > On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy < > shashidharreddy...@gmail.com> wrote: > >> Actually I was using the below command to check the compatibility, it >> worked without any issue with 12.6 but it is not working with 1version 2.14 >

Re: Re[2]: Getting error while upgrading postgres from version 12 to 13

On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy wrote: > Actually I was using the below command to check the compatibility, it > worked without any issue with 12.6 but it is not working with 1version 2.14 > time /usr/lib/postgresql/13/bin/pg_upgrade --old-bindir > /usr/lib/postgresql/12/bin --new-

Re: Getting error while upgrading postgres from version 12 to 13

On 3/21/23 08:13, shashidhar Reddy wrote: Both shows different versions as 13 shows version 13.10 and 12 shows 12. The question asked was: "Check the value that is the PG_VERSION file in each data directory. It should be 12 in /usr/pgdata/pg_data and 13 in /usr/pgdata/pg_data2." So indicate w

Re: Oracle to PostgreSQL Migration

EDB do have a replication server which can be used to transfer real time data from oracle to postgres. don't know if it can be used to get to "no downtime" BTW what do you call "no downtime" as anyway a switch, as fast as it can be do take ""some"" time ? Marc MILLAS Senior Architect +33607850334

Re: Getting error while upgrading postgres from version 12 to 13

Both shows different versions as 13 shows version 13.10 and 12 shows 12.14 On Tue, 21 Mar, 2023, 8:09 pm Adrian Klaver, wrote: > On 3/21/23 03:29, shashidhar Reddy wrote: > > Actually I was using the below command to check the compatibility, it > > worked without any issue with 12.6 but it is no

Re: Getting error while upgrading postgres from version 12 to 13

On 3/21/23 03:29, shashidhar Reddy wrote: Actually I was using the below command to check the compatibility, it worked without any issue with 12.6 but it is not working with 1version 2.14 time /usr/lib/postgresql/13/bin/pg_upgrade --old-bindir /usr/lib/postgresql/12/bin --new-bindir /usr/lib/pos

Re: Oracle to PostgreSQL Migration

Could oracle_fdw help in your use case? You could consider setting up a job to pull data into PostgreSQL live and then cut over when you are ready. - Umair On Tue, Mar 21, 2023 at 10:36 AM Inzamam Shafiq wrote: > Hi Thomas, > > We have tried kafka, but in

Re: Re[2]: Getting error while upgrading postgres from version 12 to 13

Actually I was using the below command to check the compatibility, it worked without any issue with 12.6 but it is not working with 1version 2.14 time /usr/lib/postgresql/13/bin/pg_upgrade --old-bindir /usr/lib/postgresql/12/bin --new-bindir /usr/lib/postgresql/13/bin --old-datadir /usr/pgdata/pg_d

Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?

I may have been one of the respondents who showed some annoyance, and I am sorry for that. I understand that you ask questions to gain deeper understanding. On Mon, 2023-03-20 at 13:46 -0700, Bryn Llewellyn wrote: > Oracle Database doesn't expose scrollability for PL/SQL's equivalent of > "refcu

Missing RHEL8 RPMS

   Hello, some RPMS, like python3-ydiff, are available for rhel7 and rhel9 but are missing in the rhel8 repo: https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-8-x86_64/ The rpms an are a prerequisite of patroni that thus fails to install on rhel8. Which is the proper way to