Re: pg_dump --with-* options - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: pg_dump --with-* options
Date
Msg-id 8f4dc84b52165fa31402259b2ab45ae7a04dff42.camel@j-davis.com
Whole thread Raw
In response to pg_dump --with-* options  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: pg_dump --with-* options
List pgsql-hackers
On Thu, 2025-06-12 at 21:16 +0200, Peter Eisentraut wrote:
> > Do we have other options that are order-sensitive?
>
> I think most of them are.  For example:
>
> psql -p 5432 -p 5433
> initdb --data-checksums --no-data-checksums
> postgres --shared-buffers=1GB --shared-buffers=2GB

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




pgsql-hackers by date:

Previous
From: Christoph Berg
Date:
Subject: Re: pgsql: Introduce pg_shmem_allocations_numa view
Next
From: Dimitrios Apostolou
Date:
Subject: Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward