pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feed Re[2]: Getting error while upgrading postgres from version 12 to 13
4+ messages / 3 participants
[nested] [flat]
* Re[2]: Getting error while upgrading postgres from version 12 to 13
@ 2023-03-20 05:37 abdulsayeed24@gmail.com
0 siblings, 1 reply; 4+ messages in thread
From: abdulsayeed24@gmail.com @ 2023-03-20 05:37 UTC (permalink / raw)
To: shashidhar Reddy <shashidharreddy001@gmail.com>; +Cc: pgsql-general; David G. Johnston <david.g.johnston@gmail.com>
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.g.johnston@gmail.com <david.g.johnston@gmail.com>:
>On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy < shashidharreddy001@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. Showing that psql itself works on both running clusters would be a good start. Show inputs, not just outputs those inputs creates.
>
>David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
@ 2023-03-21 10:29 shashidhar Reddy <shashidharreddy001@gmail.com>
parent: abdulsayeed24@gmail.com
0 siblings, 1 reply; 4+ messages in thread
From: shashidhar Reddy @ 2023-03-21 10:29 UTC (permalink / raw)
To: abdulsayeed24@gmail.com; +Cc: pgsql-general; David G. Johnston <david.g.johnston@gmail.com>
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@gmail.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.g.johnston@gmail.com <
> david.g.johnston@gmail.com>:
>
> On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy <
> shashidharreddy001@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. 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
@ 2023-03-21 16:06 Geoff Winkless <pgsqladmin@geoff.dj>
parent: shashidhar Reddy <shashidharreddy001@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Geoff Winkless @ 2023-03-21 16:06 UTC (permalink / raw)
To: shashidhar Reddy <shashidharreddy001@gmail.com>; +Cc: pgsql-general; David G. Johnston <david.g.johnston@gmail.com>
On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy <shashidharreddy001@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
> 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
@ 2023-03-21 16:11 Geoff Winkless <pgsqladmin@geoff.dj>
parent: Geoff Winkless <pgsqladmin@geoff.dj>
0 siblings, 0 replies; 4+ messages in thread
From: Geoff Winkless @ 2023-03-21 16:11 UTC (permalink / raw)
To: Geoff Winkless <pgsqladmin@geoff.dj>; +Cc: shashidhar Reddy <shashidharreddy001@gmail.com>; pgsql-general; David G. Johnston <david.g.johnston@gmail.com>
On Tue, 21 Mar 2023 at 16:06, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
> On Tue, 21 Mar 2023 at 10:29, shashidhar Reddy <
> shashidharreddy001@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
>> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-03-21 16:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-20 05:37 Re[2]: Getting error while upgrading postgres from version 12 to 13 abdulsayeed24@gmail.com
2023-03-21 10:29 ` shashidhar Reddy <shashidharreddy001@gmail.com>
2023-03-21 16:06 ` Geoff Winkless <pgsqladmin@geoff.dj>
2023-03-21 16:11 ` Geoff Winkless <pgsqladmin@geoff.dj>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox