Hi, I’m configuring an environment that is pointed at an external AWS rds instance (postgres 11.x) I notice this error when trying to backup through the UI: [2019-10-25 21:50:35] Dumping the public schema of the database... [2019-10-25 21:50:35] pg_dump: server version: 11.5; pg_dump version: 10.10 (Debian 10.10-1.pgdg100+1) [2019-10-25 21:50:35] pg_dump: aborting because of server version mismatch I guess this is because the docker container’s pg_dump version is not matching the version of the external rds database. Any suggestions on how to deal with this? Should I just use an external db that isn’t 11.x?

[صورة] thomas_grice: Should I just use an external db that isn’t 11.x? The supported PostgreSQL version currently is 10.x. We plan on upgrading to 12.x in the next release cycle.

Google Cloud Platform provides Postgres 11 by default. Version 10 is only available as “beta”. When can we expect support for 11.x?

We plan on moving to 12.x in a few months. 11.x will be skipped.

We deployed on postgres 11 already. Can we continue using? Is backup the only feature not working? How to downgrade to 10, if we can not export/import?

As PostgreSQL is very solid on keeping features working and not trigger happy with removing features it should work, except for the backup and restore which depends on the container pg_dump version. We don’t run it, and don’t test on it, so you are on your own if any problem arises.

We were in the same boat: deployed on GCP-managed Postgres 11 because the docs called for Postgres 10+. We just ended up adding a custom command to our bootstrap to install the PG 11 client tools and swap pg_dump to use that version by default. - exec: cmd: - apt-get update && apt-get install postgresql-client-11 && update-alternatives --install /usr/bin/pg_dump pg_dump /usr/lib/postgresql/11/bin/pg_dump 1

This is a reasonable workaround, we plan to upgrade pg in our official images to 12 over the next few months

We now run PostgreSQL 12 update which is available in AWS RDS.

لا يمكن عمل نسخة احتياطية بسبب عدم تطابق الإصدار على AWS

مطور

Falco (Falco) 12 مايو 2020، 6:54م 9

ندير الآن PostgreSQL 12 update المتاح في AWS RDS.

الموضوع		الردود	مرات العرض
Pg_dump backup failure for remote pgsql - port & version differentials; what options exist? Self-hosting	6	3564	20 أغسطس 2022
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3420	14 فبراير 2019
Backup has failed. pg_dump: server version: 9.6.3; pg_dump version: 9.5.10 Development	7	9211	2 ديسمبر 2017
Backup Failed error Product Support	4	307	8 مايو 2025
Supported postgresql versions Self-hosting	17	3691	2 مارس 2025

لا يمكن عمل نسخة احتياطية بسبب عدم تطابق الإصدار على AWS

الموضوعات ذات الصلة