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
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? |