Re: [GENERAL] pg_upgrade ?deficiency - Mailing list pgsql-hackers

From Karsten Hilbert
Subject Re: [GENERAL] pg_upgrade ?deficiency
Date
Msg-id 20131123172421.GL4151@hermes.hilbert.loc
Whole thread Raw
In response to Re: [GENERAL] pg_upgrade ?deficiency  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Nov 23, 2013 at 12:11:56PM -0500, Tom Lane wrote:

> I also agree with *not* changing pg_dump, since it is not the charter
> of pg_dump to recreate a whole cluster, and the objection about possibly
> restoring into a database that was meant to be protected by this setting
> seems to have some force.

This is were the suggestion comes in (which was already raised)
to add some commandline option to the effect of
--ignore-default-tx-readonly

which, however, I agree with can be worked around by
projects (like GNUmed, in which context this issue
came up at all) providing restore scripts setting
PGOPTIONS appropriately ...

Thanks for all the work,
Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_upgrade ?deficiency
Next
From: Kevin Grittner
Date:
Subject: Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files