Re: Dump version issues

2025-04-23 Thread Adrian Klaver
On 4/23/25 13:02, Pawel Veselov wrote: On Wed, Apr 23, 2025 at 9:13 PM Adrian Klaver wrote: On 4/23/25 11:46, Pawel Veselov wrote: Hello. So, how come older software (according to versions) produces dump files with a greater version than the newer software can understand? Is this Ubuntu pa

Re: Dump version issues

2025-04-23 Thread Pawel Veselov
On Wed, Apr 23, 2025 at 9:13 PM Adrian Klaver wrote: > On 4/23/25 11:46, Pawel Veselov wrote: > > Hello. > > > So, how come older software (according to versions) produces dump > > files with a greater version > > than the newer software can understand? Is this Ubuntu package > > maintainers mess

Dump version issues

2025-04-23 Thread Pawel Veselov
Hello. Was trying to import a database from a cloud deployment, and ran into this. Exported the database with: * pg_dump (PostgreSQL) 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) * RDS PostgreSQL 12.19 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit This produced

Re: Dump version issues

2025-04-23 Thread Tom Lane
Pawel Veselov writes: > Was trying to import a database from a cloud deployment, and ran into this. > Exported the database with: > * pg_dump (PostgreSQL) 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) > * RDS PostgreSQL 12.19 on x86_64-pc-linux-gnu, compiled by gcc (GCC) > 7.3.1 20180712 (Red Hat 7.3.1-1

Re: Dump version issues

2025-04-23 Thread Adrian Klaver
On 4/23/25 11:46, Pawel Veselov wrote: Hello. So, how come older software (according to versions) produces dump files with a greater version than the newer software can understand? Is this Ubuntu package maintainers messing things up? Do: man postgresql-common to see how this handled. I h

Re: Dump version issues

2025-04-23 Thread Adrian Klaver
On 4/23/25 11:46, Pawel Veselov wrote: Hello. Was trying to import a database from a cloud deployment, and ran into this. Exported the database with: * pg_dump (PostgreSQL) 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) Are you sure about the above? Version 1.16 is what you get from a Postgres 17 dum