Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqpn9-0006qe-1d for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Feb 2019 01:44:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqpn7-0001X4-Ma for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Feb 2019 01:44:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqpn7-0001Ww-DG for pgsql-bugs@lists.postgresql.org; Tue, 05 Feb 2019 01:44:49 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqpn0-0006Bk-8S for pgsql-bugs@lists.postgresql.org; Tue, 05 Feb 2019 01:44:48 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x151id3L004468; Mon, 4 Feb 2019 20:44:39 -0500 From: Tom Lane To: Tom Cassidy cc: Alvaro Herrera , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #15602: pg_dump archive items not in correct section order In-reply-to: <23ab4c34-f612-ad5f-5df8-fae676952c73@mossridge.com.au> References: <201901231644.rh46t3asx75y@alvherre.pgsql> <7655.1549301072@sss.pgh.pa.us> <23ab4c34-f612-ad5f-5df8-fae676952c73@mossridge.com.au> Comments: In-reply-to Tom Cassidy message dated "Tue, 05 Feb 2019 01:42:09 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4466.1549331079.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Mon, 04 Feb 2019 20:44:39 -0500 Message-ID: <4467.1549331079@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tom Cassidy writes: > On 5/2/19 4:24 am, Tom Lane wrote: >> Tom, are you in a position to rebuild pg_dump with this fix applied, >> and see if it cures your original case as well as the simplified one? > I downloaded the git source and built postgres from REL_11_STABLE branch= = > using the instructions at = > https://blog.2ndquadrant.com/testing-new-postgresql-versions-without-mes= sing-up-your-install/. = > Your patch looked like it was already applied to this branch so I = > didn't apply it. Yeah, I committed it a couple hours ago --- "git log" would confirm whether you had it or not. > Running pg_dump from the patched version I didn't notice any warning = > output on either the original database or the simplified test case = > database, so it appears that this patch solves the issue. Cool, thanks for checking! regards, tom lane