public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sam Kidman <[email protected]>
To: [email protected]
Subject: pg_dump 17 produces files incompatible with older server versions
Date: Wed, 2 Oct 2024 13:23:25 +0800
Message-ID: <CA+FDo=vj+MPhROnDF1b6R=dPrgXeLGUaFbHu=YnHEz7LocSu4A@mail.gmail.com> (raw)

Hello

We're developing a rails application and part of our development
workflow involves dumping out the database schema using pg_dump, which
is restored whenever we drop and create our development database.

As of version 17 we now have SET transaction_timeout = 0 in the schema file.

Unfortunately we use the latest version of the client tools (ie
pg_dump and kin) but we run the same database server version as we use
in production (12) and so now we're unable to import our database
schema with the error below:

ERROR:  unrecognized configuration parameter "transaction_timeout"

It might be easier for us if we could configure pg_dump to _not_
output setting runtime parameters - they're not that important for the
use case of applying a schema to a database for local development.

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.

Best,

-- 

Sam Kidman

Web Developer

Melbourne

0498 592 582
[email protected]
www.fresho.com

view thread (2+ messages)  latest in thread

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]
  Subject: Re: pg_dump 17 produces files incompatible with older server versions
  In-Reply-To: <CA+FDo=vj+MPhROnDF1b6R=dPrgXeLGUaFbHu=YnHEz7LocSu4A@mail.gmail.com>

* 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