Message-ID: <8f4dc84b52165fa31402259b2ab45ae7a04dff42.camel@j-davis.com>
Subject: Re: pg_dump --with-* options
From: Jeff Davis <pgsql@j-davis.com>
To: Peter Eisentraut <peter@eisentraut.org>, Nathan Bossart
	 <nathandbossart@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: Thu, 12 Jun 2025 14:20:11 -0700
In-Reply-To: <350edd98-7e91-4b63-b393-ba8b681b0799@eisentraut.org>
References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org>
	 <aEMLzPQtjRbj2R7X@nathan>
	 <17f63ecf-679c-4337-817f-908bb159701f@eisentraut.org>
	 <ad5175ba8abb9caec1fe59187ad7e54d3d24d797.camel@j-davis.com>
	 <350edd98-7e91-4b63-b393-ba8b681b0799@eisentraut.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/8f4dc84b52165fa31402259b2ab45ae7a04dff42.camel%40j-davis.com>
Precedence: bulk

On Thu, 2025-06-12 at 21:16 +0200, Peter Eisentraut wrote:
> > Do we have other options that are order-sensitive?
>=20
> I think most of them are.=C2=A0 For example:
>=20
> psql -p 5432 -p 5433
> initdb --data-checksums --no-data-checksums
> postgres --shared-buffers=3D1GB --shared-buffers=3D2GB

Interesting. I don't think the "last option wins" model applies to
other pg_dump options, though. For instance, in PG17:

  pg_dump --data-only --schema-only
  pg_dump: error: options -s/--schema-only and -a/--data-only cannot be
used together

I don't think it's simple to start using "last option wins" behavior
now. There are probably some combinations of options where it's not
clear whether a later option is an extra constraint or will override a
previous option.

Regards,
	Jeff Davis