Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrPLI-0006EX-Jr for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 18:23:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrPLH-0000vO-Hy for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 18:23:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrPLH-0000uf-9n for pgsql-performance@lists.postgresql.org; Thu, 10 Jun 2021 18:23:47 +0000 Received: from relay9-d.mail.gandi.net ([217.70.183.199]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrPLD-0005Ma-Je for pgsql-performance@postgresql.org; Thu, 10 Jun 2021 18:23:46 +0000 Received: (Authenticated sender: adsend@dunslane.net) by relay9-d.mail.gandi.net (Postfix) with ESMTPSA id 51E3CFF802; Thu, 10 Jun 2021 18:23:40 +0000 (UTC) Subject: Re: AWS forcing PG upgrade from v9.6 a disaster To: Tom Lane , "Dean Gibson (DB Administrator)" Cc: pgsql-performance@postgresql.org References: <88dec70b-eb63-0b72-0b5d-253851ef127b@mailpen.com> <92cc8563-195f-8727-d887-5f2bb63f231f@mailpen.com> <20210601041635.GQ2082@telsasoft.com> <18f77a0c-dade-b86a-cbeb-6f85d3d137e1@dunslane.net> <4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com> <1682562.1623348017@sss.pgh.pa.us> From: Andrew Dunstan Message-ID: Date: Thu, 10 Jun 2021 14:23:39 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.4.0 MIME-Version: 1.0 In-Reply-To: <1682562.1623348017@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/10/21 2:00 PM, Tom Lane wrote: > "Dean Gibson (DB Administrator)" writes: >> On 2021-06-10 09:54, Ranier Vilela wrote: >>> Your cmd lacks = >>> =>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql >> I read that before posting, but missed that. Old command line patterns >> die hard! >> However, the result was the same: 3.5GB before running out of space. > [ experiments... ] Looks like you gotta do it like this: > > pg_dumpall '--exclude-database="MailPen"' ... > > This surprises me, as I thought it was project policy not to > case-fold command-line arguments (precisely because you end > up needing weird quoting to prevent that). > > Ouch. That looks like a plain old bug. Let's fix it. IIRC I just used the same logic that we use for pg_dump's --exclude-* options, so we need to check if they have similar issues. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com