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@xxxxxxxxx
<mailto:abdulsayeed24@xxxxxxxxx>> 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@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>
<david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>>:
On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy
<shashidharreddy001@xxxxxxxxx
<mailto:shashidharreddy001@xxxxxxxxx>> 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@xxxxxxxxxxx
