Re: pg_dump no-owner option

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: borisnov(at)acm(dot)org
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump no-owner option
Date: 2021-01-13 17:54:20
Message-ID: 1288537.1610560460@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> Currently the documentation reads:
> This option is only meaningful for the plain-text format.

> This statement is imprecise.

Yeah, I agree --- it's not clear whether the option is ignored or
rejected. Explicitly saying it's ignored is an improvement.

> Would be much better to change the behavior of the utility to allow the
> option for all formats, but htis is somewhat more than just documentaion
> change.

I disagree that that would be an improvement. Per the next sentence that
you omitted, the right time to apply this and similar options is when
extracting data from the archive format. (pg_dump to text effectively
constructs an archive dump in-memory and then extracts from that, so that
its "back half" logic is identical to pg_restore's.) Filtering this info
before dumping the archive would save no meaningful amount of space, while
restricting how the archive could be used later.

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-01-13 21:22:10 Truncate View
Previous Message Magnus Hagander 2021-01-13 10:10:49 Re: Typo