Postgres Pro
Downloads
Home   >   mailing lists

Re: Re[2]: Getting error while upgrading postgres from version 12 to 13 - Mailing list pgsql-general

From shashidhar Reddy
Subject Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
Date
Msg-id CAH=zU4tw-NNfVeFfGLPxxXsDE8Uwu_s-r2wNi6V-pYmFkSKX_w@mail.gmail.com
Whole thread Raw
In response to Re[2]: Getting error while upgrading postgres from version 12 to 13  (abdulsayeed24@gmail.com)
Responses Re: Getting error while upgrading postgres from version 12 to 13  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Re[2]: Getting error while upgrading postgres from version 12 to 13  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?
Next
From: Umair Shahid
Date:
Subject: Re: Oracle to PostgreSQL Migration