Re: AWS forcing PG upgrade from v9.6 a disaster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AWS forcing PG upgrade from v9.6 a disaster
Дата
Msg-id 1682562.1623348017@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: AWS forcing PG upgrade from v9.6 a disaster  ("Dean Gibson (DB Administrator)" <postgresql@mailpen.com>)
Ответы Re: AWS forcing PG upgrade from v9.6 a disaster
Список 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 по дате отправления:

Предыдущее
От: "Dean Gibson (DB Administrator)"
Дата:
Сообщение: Re: AWS forcing PG upgrade from v9.6 a disaster
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: AWS forcing PG upgrade from v9.6 a disaster