Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2
Date: 2021-06-20 19:34:45
Message-ID: YM+YVXfEZyRP9PLl@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Sun, Jun 20, 2021 at 01:47:47PM -0400 schrieb Tom Lane:

> Hence, the only way to make this scenario work would be for the
> restore script to explicitly override default_transaction_read_only.
[...]
> Also, doing so would result in ignoring default_transaction_read_only
> no matter what the source of that was. I think it's probably not
> hard to construct scenarios where someone would really not be happy
> about such behavior.

Any chance pg_dump (and/or pg_restore) might gain an option
--ignore-read-only ? That way, PostgreSQL need not decide
for users.

Thanks,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2021-06-20 19:58:52 Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2
Previous Message Tom Lane 2021-06-20 18:14:30 Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2