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

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 (Ubuntu
12.14-1.pgdg18.04+1)

Please help me on this issue.
--
Shashidhar

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 is not compatible with this version 12.14 (Ubuntu 12.14-1.pgdg18.04+1)
>
> Please help me on this issue.

Show us the complete command you ran, pus all output.

--
Born in Arizona, moved to Babylonia.

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 <
shashidharreddy001(at)gmail(dot)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
> DETAIL: The data directory was initialized by PostgreSQL version 13
> , which is not compatible with this version 12.14 (Ubuntu
> 12.14-1.pgdg18.04+1)
>
> Please help me on this issue.
> --
> Shashidhar
>

--
Shashidhar

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 SSL key you have configured is not the
private key for the public key you have configured - they do not match.
*t

> On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy
> <shashidharreddy001(at)gmail(dot)com <mailto:shashidharreddy001(at)gmail(dot)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
>  DETAIL:  The data directory was initialized by PostgreSQL version 13
> , which is not compatible with this version 12.14 (Ubuntu
> 12.14-1.pgdg18.04+1)
>
> Please help me on this issue.

You have configured the postgres v12 server to use a directory where
there are data from a postgres v13 server. Evidently that can not work...
*t

Can someone please help me with this?

On Sun, 19 Mar, 2023, 2:54 am shashidhar Reddy, <
shashidharreddy001(at)gmail(dot)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
> "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch
>
> On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy <
> shashidharreddy001(at)gmail(dot)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
>> DETAIL: The data directory was initialized by PostgreSQL version 13
>> , which is not compatible with this version 12.14 (Ubuntu
>> 12.14-1.pgdg18.04+1)
>>
>> Please help me on this issue.
>> --
>> Shashidhar
>>
>
>
> --
> Shashidhar
>

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 postgres v13 server. Evidently that can not work..."

>
> On Sun, 19 Mar, 2023, 2:54 am shashidhar Reddy,
> <shashidharreddy001(at)gmail(dot)com <mailto:shashidharreddy001(at)gmail(dot)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
> "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch
>
> On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy
> <shashidharreddy001(at)gmail(dot)com <mailto:shashidharreddy001(at)gmail(dot)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
>  DETAIL:  The data directory was initialized by PostgreSQL
> version 13
> , which is not compatible with this version 12.14 (Ubuntu
> 12.14-1.pgdg18.04+1)
>
> Please help me on this issue.
> --
> Shashidhar
>
>
>
> --
> Shashidhar
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

On Sat, Mar 18, 2023 at 7:27 PM shashidhar Reddy <
shashidharreddy001(at)gmail(dot)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. Showing that psql itself works on both running clusters would be
a good start. Show inputs, not just outputs those inputs creates.

David J.

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

Sunday, 19 March 2023 at 11:29 AM +0530 from david(dot)g(dot)johnston(at)gmail(dot)com <david(dot)g(dot)johnston(at)gmail(dot)com>:
>On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy < shashidharreddy001(at)gmail(dot)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.  Showing that psql itself works on both running clusters would be a good start.  Show inputs, not just outputs those inputs creates.
>
>David J.

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_data --new-datadir /usr/pgdata/pg_data2 --link
--check

I have used a different directory for postgres13 from postgres 12.

On Mon, Mar 20, 2023 at 11:07 AM <abdulsayeed24(at)gmail(dot)com> wrote:

> 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
>
>
> Sunday, 19 March 2023 at 11:29 AM +0530 from david(dot)g(dot)johnston(at)gmail(dot)com <
> david(dot)g(dot)johnston(at)gmail(dot)com>:
>
> On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy <
> shashidharreddy001(at)gmail(dot)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. Showing that psql itself works on both running clusters would be
> a good start. Show inputs, not just outputs those inputs creates.
>
> David J.
>
>

--
Shashidhar

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/postgresql/13/bin
> --old-datadir /usr/pgdata/pg_data --new-datadir /usr/pgdata/pg_data2
> --link --check
>
> I have used a different directory for postgres13 from postgres 12.

The issue is not that they are the same directory it is:

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 (Ubuntu
12.14-1.pgdg18.04+1)

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.

>
> On Mon, Mar 20, 2023 at 11:07 AM <abdulsayeed24(at)gmail(dot)com
> <mailto:abdulsayeed24(at)gmail(dot)com>> wrote:
>
> 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
>
>
> Sunday, 19 March 2023 at 11:29 AM +0530 from
> david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>:
>
> On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy
> <shashidharreddy001(at)gmail(dot)com
> <mailto:shashidharreddy001(at)gmail(dot)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.  Showing that psql itself
> works on both running clusters would be a good start.  Show
> inputs, not just outputs those inputs creates.
>
> David J.
>
>
>
> --
> Shashidhar

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

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, <adrian(dot)klaver(at)aklaver(dot)com>
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 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_data --new-datadir /usr/pgdata/pg_data2
> > --link --check
> >
> > I have used a different directory for postgres13 from postgres 12.
>
> The issue is not that they are the same directory it is:
>
> 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 (Ubuntu
> 12.14-1.pgdg18.04+1)
>
> 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.
>
> >
> > On Mon, Mar 20, 2023 at 11:07 AM <abdulsayeed24(at)gmail(dot)com
> > <mailto:abdulsayeed24(at)gmail(dot)com>> wrote:
> >
> > 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
> >
> >
> > Sunday, 19 March 2023 at 11:29 AM +0530 from
> > david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> > <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>:
> >
> > On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy
> > <shashidharreddy001(at)gmail(dot)com
> > <mailto:shashidharreddy001(at)gmail(dot)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. Showing that psql itself
> > works on both running clusters would be a good start. Show
> > inputs, not just outputs those inputs creates.
> >
> > David J.
> >
> >
> >
> > --
> > Shashidhar
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>

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 which directory path has which PG_VERSION value.

While you are at it do:

/usr/lib/postgresql/13/bin/pg_upgrade -V

and post the version returned.

>
> On Tue, 21 Mar, 2023, 8:09 pm Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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 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_data --new-datadir /usr/pgdata/pg_data2
> > --link --check
> >
> > I have used a different directory for postgres13 from postgres 12.
>
> The issue is not that they are the same directory it is:
>
> 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 (Ubuntu
> 12.14-1.pgdg18.04+1)
>
> 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.
>
> >
> > On Mon, Mar 20, 2023 at 11:07 AM <abdulsayeed24(at)gmail(dot)com
> <mailto:abdulsayeed24(at)gmail(dot)com>
> > <mailto:abdulsayeed24(at)gmail(dot)com
> <mailto:abdulsayeed24(at)gmail(dot)com>>> wrote:
> >
> >     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
> >
> >
> >     Sunday, 19 March 2023 at 11:29 AM +0530 from
> > david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> <mailto:david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>
> >     <david(dot)g(dot)johnston(at)gmail(dot)com
> <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> <mailto:david(dot)g(dot)johnston(at)gmail(dot)com
> <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>>:
> >
> >         On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy
> >         <shashidharreddy001(at)gmail(dot)com
> <mailto:shashidharreddy001(at)gmail(dot)com>
> >         <mailto:shashidharreddy001(at)gmail(dot)com
> <mailto:shashidharreddy001(at)gmail(dot)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.  Showing that psql itself
> >         works on both running clusters would be a good start.  Show
> >         inputs, not just outputs those inputs creates.
> >
> >         David J.
> >
> >
> >
> > --
> > Shashidhar
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy <shashidharreddy001(at)gmail(dot)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
> 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_data --new-datadir /usr/pgdata/pg_data2 --link
> --check
>

Just in case I'm _not_ misreading this... are you saying you already ran
this command once with postgres v12.6?

If so, since you've used --link the original folder will no longer be
version12 data.

Geoff

>

On Tue, 21 Mar 2023 at 16:06, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:

> On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy <
> shashidharreddy001(at)gmail(dot)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
>> 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_data --new-datadir /usr/pgdata/pg_data2 --link
>> --check
>>
>
> Just in case I'm _not_ misreading this... are you saying you already ran
> this command once with postgres v12.6?
>
> If so, since you've used --link the original folder will no longer be
> version12 data.
>

No, I'm an idiot. Ignore me, I missed "--check".

Geoff