| From: | "Dean Gibson (DB Administrator)" <postgresql(at)mailpen(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: AWS forcing PG upgrade from v9.6 a disaster |
| Date: | 2021-06-10 21:46:27 |
| Message-ID: | 780b160d-7a35-41ce-5627-57e705436db3@mailpen.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
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(at)mailpen(dot)com <mailto:postgresql(at)mailpen(dot)com>> escreveu:
>>
>>
>> ... Do I need quotes on the command line?
>>
>> See at:
>> https://www.postgresql.org/docs/13/app-pg-dumpall.html
>> <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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2021-06-10 22:02:58 | Re: Race condition in InvalidateObsoleteReplicationSlots() |
| Previous Message | Andrew Dunstan | 2021-06-10 21:39:00 | Re: "an SQL" vs. "a SQL" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ayub Khan | 2021-06-11 16:28:26 | Re: waiting for client write |
| Previous Message | Dean Gibson (DB Administrator) | 2021-06-10 19:29:05 | Re: AWS forcing PG upgrade from v9.6 a disaster |