Re: AWS forcing PG upgrade from v9.6 a disaster - Mailing list pgsql-performance

From Tom Lane
Subject Re: AWS forcing PG upgrade from v9.6 a disaster
Date
Msg-id 1682562.1623348017@sss.pgh.pa.us
Whole thread Raw
In response to Re: AWS forcing PG upgrade from v9.6 a disaster  ("Dean Gibson (DB Administrator)" <postgresql@mailpen.com>)
Responses Re: AWS forcing PG upgrade from v9.6 a disaster  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-performance
"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



pgsql-performance by date:

Previous
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
Next
From: Andrew Dunstan
Date:
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster