Re: Getting error while upgrading postgres from version 12 to 13 - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: Getting error while upgrading postgres from version 12 to 13 |
Date | |
Msg-id | c9883755-df74-8911-0d74-545a8a62de18@aklaver.com Whole thread Raw |
In response to | Re: Getting error while upgrading postgres from version 12 to 13 (shashidhar Reddy <shashidharreddy001@gmail.com>) |
List | pgsql-general |
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.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.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@gmail.com > <mailto:abdulsayeed24@gmail.com> > > <mailto:abdulsayeed24@gmail.com > <mailto: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 <mailto:david.g.johnston@gmail.com> > <mailto:david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> > > <david.g.johnston@gmail.com > <mailto:david.g.johnston@gmail.com> > <mailto:david.g.johnston@gmail.com > <mailto:david.g.johnston@gmail.com>>>: > > > > On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy > > <shashidharreddy001@gmail.com > <mailto:shashidharreddy001@gmail.com> > > <mailto:shashidharreddy001@gmail.com > <mailto: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 > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: