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 1lrSVa-00048F-2q for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 21:46:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrSVX-00024w-MX for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 21:46:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrSVX-00024n-EN for pgsql-performance@lists.postgresql.org; Thu, 10 Jun 2021 21:46:35 +0000 Received: from aws.mailpen.com ([52.43.43.172] helo=aws2.mailpen.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrSVR-0002Uo-1I for pgsql-performance@postgresql.org; Thu, 10 Jun 2021 21:46:34 +0000 Received: from [172.20.70.208] (unknown [50.35.114.95]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by aws2.mailpen.com (Postfix) with ESMTPSA id C1D2DC64F7F for ; Thu, 10 Jun 2021 14:46:27 -0700 (PDT) Subject: Re: AWS forcing PG upgrade from v9.6 a disaster From: "Dean Gibson (DB Administrator)" To: 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> Organization: UltiMeth Systems Message-ID: <780b160d-7a35-41ce-5627-57e705436db3@mailpen.com> Date: Thu, 10 Jun 2021 14:46:27 -0700 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: <4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com> Content-Type: multipart/alternative; boundary="------------AED1E4960F1A0770302749A9" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------AED1E4960F1A0770302749A9 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 2021-06-10 10:43, Dean Gibson (DB Administrator) wrote: > On 2021-06-10 09:54, Ranier Vilela wrote: >> Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator) >> > escreveu: >> >> >> ...  Do I need quotes on the command line? >> >> See at: >> https://www.postgresql.org/docs/13/app-pg-dumpall.html >> >> >> Your cmd lacks = >> =>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql >> >> regards, Ranier Vilela > > ... > > However, the result was the same:  3.5GB before running out of space. > It turns out the "=" is not needed.  The double-quoting is (this works): pg_dumpall -U Admin --exclude-database '"MailPen"'  >zzz.sql --------------AED1E4960F1A0770302749A9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 2021-06-10 10:43, Dean Gibson (DB Administrator) wrote:
On 2021-06-10 09:54, Ranier Vilela wrote:
Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator) <postgresql@mailpen.com> escreveu:

...  Do I need quotes on the command line?
See at:

Your cmd lacks =
=>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql

regards, Ranier Vilela

...

However, the result was the same:  3.5GB before running out of space.


It turns out the "=" is not needed.  The double-quoting is (this works):

pg_dumpall -U Admin --exclude-database '"MailPen"'  >zzz.sql
--------------AED1E4960F1A0770302749A9--