Re: Another pg_dump using split and gzip for large databases

Поиск
Список
Период
Сортировка
От James Doherty
Тема Re: Another pg_dump using split and gzip for large databases
Дата
Msg-id CAMxig9oyn5xQzDp1q3_kbA9qUOqkADzn8KAWbBzL7e+HTjnTdw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Another pg_dump using split and gzip for large databases  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
Дерево обсуждения
They key to my comment is splits —filter command which allows gzip each of the split files

On Wed, Jul 28, 2021 at 18:46 Bruce Momjian <bruce@momjian.us> wrote:
On Sat, Jul 17, 2021 at 03:09:52PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/backup-dump.html
> Description:
>
> pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz'

Wow, odd we didn't have an example of using gzip and split together;
patch attached.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

--
James M Doherty President Revive Consulting LLC

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Indexes on Expressions - a note to remind users to run ANALYZE after creation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Logical error