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 w

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 no

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 /usr/lib/pos

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

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 > "/et

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  DET

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 < shashidharreddy...@gmail.

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 , which