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

From: shashidhar Reddy <shashidharreddy001(at)gmail(dot)com>
To: abdulsayeed24(at)gmail(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
Date: 2023-03-21 10:29:48
Message-ID: CAH=zU4tw-NNfVeFfGLPxxXsDE8Uwu_s-r2wNi6V-pYmFkSKX_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Umair Shahid 2023-03-21 10:48:08 Re: Oracle to PostgreSQL Migration
Previous Message Laurenz Albe 2023-03-21 07:55:36 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?