From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Dean Gibson (DB Administrator)" <postgresql@mailpen.com>
cc: pgsql-performance@postgresql.org
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
In-reply-to: <4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com>
References: <88dec70b-eb63-0b72-0b5d-253851ef127b@mailpen.com>
 <92cc8563-195f-8727-d887-5f2bb63f231f@mailpen.com>
 <20210601041635.GQ2082@telsasoft.com>
 <a38c45cf-3bbd-b43a-0f8a-11539c1c6dc1@mailpen.com>
 <a7e9da9d-7433-ee02-9e35-db6b19acdcd4@mailpen.com>
 <18f77a0c-dade-b86a-cbeb-6f85d3d137e1@dunslane.net>
 <ec18a226-6bef-7ba6-e176-c751e189270d@mailpen.com>
 <CAEudQAodj-ywxc-3fgh8wK7oP8WXCoNSs0j8EF4HK+uUixTqMA@mail.gmail.com>
 <4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com>
Comments: In-reply-to "Dean Gibson (DB Administrator)"
 <postgresql@mailpen.com>
	message dated "Thu, 10 Jun 2021 10:43:13 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1682561.1623348017.1@sss.pgh.pa.us>
Date: Thu, 10 Jun 2021 14:00:17 -0400
Message-ID: <1682562.1623348017@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1682562.1623348017%40sss.pgh.pa.us>
Precedence: bulk

"Dean Gibson (DB Administrator)" <postgresql@mailpen.com> 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).

			regards, tom lane