> On 2 Oct 2024, at 07:23, Sam Kidman <sam@fresho.com> wrote:
> Are there any other solutions to this issue? It could be quite
> troublesome for us as we have a few different postgres server versions
> in use in different applications but we use the same set of client
> tools for all of them.
This is per design of pg_dump, the documentation states the following:
"it is not guaranteed that pg_dump's output can be loaded into a server of
an older major version — not even if the dump was taken from a server of
that version. Loading a dump file into an older server may require manual
editing of the dump file to remove syntax not understood by the older
server."
Running the appropriate version of pg_dump for the target cluster, or applying
manual (or scripted) editing of the dump file is the option.
--
Daniel Gustafsson
