Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-bugs-owner+M38719=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
 id 1WqMvS-00017V-KC
 for pgsql-bugs@arkaria.postgresql.org; Fri, 30 May 2014 13:32:50 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-bugs-owner+M38719=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
 id 1WqMvS-0005vv-3j
 for pgsql-bugs@arkaria.postgresql.org; Fri, 30 May 2014 13:32:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <andres@2ndquadrant.com>)
 id 1WqMvR-0005vo-4y
 for pgsql-bugs@postgresql.org; Fri, 30 May 2014 13:32:49 +0000
Received: from mail.anarazel.de ([217.115.131.40])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <andres@2ndquadrant.com>) id 1WqMvN-00067H-Hd
 for pgsql-bugs@postgresql.org; Fri, 30 May 2014 13:32:48 +0000
Received: from intern.anarazel.de (p5DDC7B35.dip0.t-ipconnect.de
 [93.220.123.53]) (Authenticated sender: andres@anarazel.de)
 by mail.anarazel.de (Postfix) with ESMTPSA id AF8784E8003;
 Fri, 30 May 2014 15:32:44 +0200 (CEST)
Date: Fri, 30 May 2014 15:32:44 +0200
From: Andres Freund <andres@2ndquadrant.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>,
 Alvaro Herrera <alvherre@2ndquadrant.com>
Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
Message-ID: <20140530133244.GG25431@alap3.anarazel.de>
References: <20140530121631.GE25431@alap3.anarazel.de>
 <20140530132916.GM28490@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20140530132916.GM28490@momjian.us>
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-bugs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-bugs.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@postgresql.org>
List-Post: <mailto:pgsql-bugs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-bugs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
X-Mailing-List: pgsql-bugs
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

On 2014-05-30 09:29:16 -0400, Bruce Momjian wrote:
> This is a bug in 9.3 pg_upgrade as well?

Yes.

>  Why has no one reported it before?

My guess is that it wasn't attributed to pg_upgrade in the
past. Typically the error will only occur a fair amount of time
later. You'll just see vacuums randomly erroring out with slru.c errors
about nonexistant files :(.

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs