Re: [GENERAL] pg_upgrade ?deficiency

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, "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-11-25 13:35:13
Message-ID: 20131125133513.GA26140@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Sat, Nov 23, 2013 at 08:44:42AM -0800, Kevin Grittner wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> > I am not a fan of backpatching any of this.
>
> Here's my problem with that.  Here's setup to create what I don't
> think is all that weird a setup:
>
> The cluster is created in the state that was dumped, default read
> only flags and all.
>
> Are you saying that you find current behavior acceptable in back
> branches?

First, I don't need to see a 300-line pg_dump restore output to know it
is a bug. Second, what you didn't do is to address the rest of my
paragraph:

> I am not a fan of backpatching any of this. We have learned the fix is
> more complex than thought, and the risk of breakage and having pg_dump
> diffs change between minor releases doesn't seem justified.

We have to balance the _one_ user failure report we have received vs.
potential breakage.

Now, others seem to be fine with a backpatch, so perhaps it is safe. I
am merely pointing out that, with all backpatching, we have to balance
the fix against possible breakage and behavioral change.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Thomas 2013-11-25 16:29:53 Re: Re: corruption issue after server crash - ERROR: unexpected chunk number 0
Previous Message Albe Laurenz 2013-11-25 10:10:29 Re: Solution for Synonyms

Browse pgsql-hackers by date

  From Date Subject
Next Message Rajeev rastogi 2013-11-25 13:37:17 Re: PostgreSQL Service on Windows does not start. ~ "is not a valid Win32 application"
Previous Message Sawada Masahiko 2013-11-25 12:02:47 Re: Logging WAL when updating hintbit