Fwd: Getting error while upgrading

2024-03-09 Thread hector vass
On Sat, Mar 9, 2024 at 12:18 PM omkar narkar wrote: > Hello Team, > > I am trying to upgrade my edb 10.5 community version to postgres 15.6 > version and while doing this i am getting error regarding OIDS are not > stable across Postgresql version (sys.callback_queue_table.user_data). > Kindly

Getting error while upgrading

2024-03-09 Thread omkar narkar
Hello Team, I am trying to upgrade my edb 10.5 community version to postgres 15.6 version and while doing this i am getting error regarding OIDS are not stable across Postgresql version (sys.callback_queue_table.user_data). Kindly help me to get the solution of this issue. Thanks and regards,

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

2023-03-21 Thread Geoff Winkless
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

2023-03-21 Thread Geoff Winkless
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

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

2023-03-21 Thread Adrian Klaver
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

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

2023-03-21 Thread shashidhar Reddy
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

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

2023-03-21 Thread Adrian Klaver
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

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

2023-03-21 Thread shashidhar Reddy
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

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

2023-03-19 Thread abdulsayeed24
Hello, As per error it seems you have initiated source data with PG13 binaries.  Could you please connect to both source and target psql and share out of select versions(); Also share pg_upgrade complete command which you are using.  Regards, Abdul Sayeed Sent from myMail for iOS

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

2023-03-18 Thread David G. Johnston
On Sat, Mar 18, 2023 at 7:27 PM shashidhar Reddy < shashidharreddy...@gmail.com> wrote: > Can someone please help me with this? > >> >> You haven't given others enough information to help you. Present to the fullest extent possible your current environment and the commands you are running.

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

2023-03-18 Thread Adrian Klaver
On 3/18/23 19:26, shashidhar Reddy wrote: Can someone please help me with this? You have already been helped: https://www.postgresql.org/message-id/ba59dd9b-6a87-ebff-c041-2dbcffe74a89%40sourcepole.ch "You have configured the postgres v12 server to use a directory where there are data from a

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

2023-03-18 Thread shashidhar Reddy
Can someone please help me with this? On Sun, 19 Mar, 2023, 2:54 am shashidhar Reddy, < shashidharreddy...@gmail.com> wrote: > and adding to this the following is also showing in the error, we tried > changing the file permissions but still no luck > FATAL: could not load private key file >

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

2023-03-18 Thread Tomas Pospisek
On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy mailto:shashidharreddy...@gmail.com>> wrote: Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating  FATAL:  database files are incompatible with server  

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

2023-03-18 Thread Tomas Pospisek
On 18.03.23 22:24, shashidhar Reddy wrote: and adding to this the following is also showing in the error, we tried changing the file permissions but still no luck FATAL:  could not load private key file "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch This sounds like the private

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

2023-03-18 Thread shashidhar Reddy
and adding to this the following is also showing in the error, we tried changing the file permissions but still no luck FATAL: could not load private key file "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy <

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

2023-03-18 Thread Ron
On 3/18/23 15:39, shashidhar Reddy wrote: Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating  FATAL:  database files are incompatible with server  DETAIL:  The data directory was initialized by PostgreSQL version 13 ,

Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread shashidhar Reddy
Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 13 , which is not compatible with this version 12.14