public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniel Gustafsson <[email protected]>
To: Sam Kidman <[email protected]>
Cc: [email protected]
Subject: Re: pg_dump 17 produces files incompatible with older server versions
Date: Wed, 2 Oct 2024 20:23:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+FDo=vj+MPhROnDF1b6R=dPrgXeLGUaFbHu=YnHEz7LocSu4A@mail.gmail.com>
References: <CA+FDo=vj+MPhROnDF1b6R=dPrgXeLGUaFbHu=YnHEz7LocSu4A@mail.gmail.com>

> On 2 Oct 2024, at 07:23, Sam Kidman <[email protected]> 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_dump 17 produces files incompatible with older server versions
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox