Re: client/server versions - Mailing list pgsql-general

From Ron Johnson
Subject Re: client/server versions
Date
Msg-id CANzqJaCrHDu642bZdikb5Pu_BVaQ92YHmL7LeEbTE_LxLp=9gw@mail.gmail.com
Whole thread Raw
In response to Re: client/server versions  (Dick Visser <dnmvisser@gmail.com>)
List pgsql-general
On Tue, Nov 21, 2023 at 8:31 AM Dick Visser <dnmvisser@gmail.com> wrote:
On Tue, 21 Nov 2023 at 14:07, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Tue, Nov 21, 2023 at 6:29 AM Dick Visser <dnmvisser@gmail.com> wrote:
Hi

I'm working with AWS RDS PG instances that have been created over time, and that by now are a mix of several major/minor versions ranging from 12 to 15.
The initial configuration and management is done from an EC2 instance running Debian 11, which has Postrgres 13.13.
I already found out that there are compatibility issues if I use the client programs from the Debian VM when they're older than the server version.

Like what?

For starters:

pg_restore: error: unsupported version (1.15) in file header


Upgrade Postgresql on the Debian 11 EC2 instance from 13.11 to 15.latest.

Or install Postgresql 12, 14 and 15 alongside Pg 13.  They all go in separate directories.
 

pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: client/server versions
Next
From: Dick Visser
Date:
Subject: Re: client/server versions