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 1lrOiF-0004nC-AM for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 17:43:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrOiE-0003yN-9U for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 17:43:26 +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 1lrOiE-0003y4-1M for pgsql-performance@lists.postgresql.org; Thu, 10 Jun 2021 17:43:26 +0000 Received: from aws.mailpen.com ([52.43.43.172] helo=aws2.mailpen.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrOi9-0004wC-IQ for pgsql-performance@postgresql.org; Thu, 10 Jun 2021 17:43:24 +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 67A00C64F7F for ; Thu, 10 Jun 2021 10:43:13 -0700 (PDT) Subject: Re: AWS forcing PG upgrade from v9.6 a disaster 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> From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems Message-ID: <4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com> Date: Thu, 10 Jun 2021 10:43:13 -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: Content-Type: multipart/alternative; boundary="------------1D45212C63A7D48A2B2A1B50" 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. --------------1D45212C63A7D48A2B2A1B50 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 2021-06-10 09:54, Ranier Vilela wrote: > Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator) > > escreveu: > > > I guess I don't understand what that option does: > > =>pg_dumpall -U Admin --exclude-database MailPen >zzz.sql > pg_dump: error: could not write to output file: No space left on > device > pg_dumpall: error: pg_dump failed on database "MailPen", exiting > > I expected a tiny file, not 3.5GB.  "MailPen" is the only database > (other than what's pre-installed).  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 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. --------------1D45212C63A7D48A2B2A1B50 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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:

I guess I don't understand what that option does:

=>pg_dumpall -U Admin --exclude-database MailPen >zzz.sql
pg_dump: error: could not write to output file: No space left on device
pg_dumpall: error: pg_dump failed on database "MailPen", exiting

I expected a tiny file, not 3.5GB.  "MailPen" is the only database (other than what's pre-installed).  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

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.

--------------1D45212C63A7D48A2B2A1B50--