| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
| Cc: | Kevin Grittner <kgrittn(at)ymail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)2ndquadrant(dot)com>, "Hilbert, Sebastian" <Sebastian(dot)Hilbert(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] pg_upgrade ?deficiency |
| Date: | 2013-12-02 18:24:18 |
| Message-ID: | 20131202182418.GG5274@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, Dec 2, 2013 at 06:57:53PM +0100, Karsten Hilbert wrote:
> On Mon, Dec 02, 2013 at 11:41:10AM -0500, Bruce Momjian wrote:
>
> > > > If there were databases or users with default_transaction_read_only
> > > > set in the old cluster, the pg_dumpall run will cause that property
> > > > to be set in the new cluster, so what you are saying seems to be
> > > > that a cluster can't be upgraded to a new major release if any
> > > > database within it has that set.
> > >
> > > That is *precisely* my use case which I initially asked about.
> >
> > The use-case would be that default_transaction_read_only is turned on in
> > postgresql.conf
>
> Are you telling me which use case I initially asked
> about on this thread ?
No, this is another use-case that is fixed the pg_upgrade patch. The
ALTER DATABASE SET is also fixed by this patch.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zev Benjamin | 2013-12-02 18:38:03 | Re: unnest on multi-dimensional arrays |
| Previous Message | Pavel Stehule | 2013-12-02 18:24:13 | Re: unnest on multi-dimensional arrays |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-12-02 18:30:42 | Re: Extension Templates S03E11 |
| Previous Message | David E. Wheeler | 2013-12-02 18:22:56 | Re: Extension Templates S03E11 |