client/server versions - Mailing list pgsql-general

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.

To avoid this I tried to run the client programs from a dedicated PG container image with the same version as the server.

So instead of running:

PGSERVICE=foobar psql

I would now run:

podman run -e PGSERVICE=foobar -v $(pwd)/.pg_service.conf:/root/.pg_service.conf --rm -it docker.io/library/postgres:15.3 psql

This is reasonably straightforward and seems to just work.

Now that I have a way to pick whatever client version I need, I wonder what the best strategy is wrt versions...

Keeping them exactly the same, or is it better to always use the latest client version?

I know that the latter is a bit easier as one can just pick an untagged container image, because that corresponds to the latest version.

Also I'm thinking that using the latest version of pg_dump/pg_restore allows you to have more options.

thx

Dick Visser