Re: pg_dump why no indicator of completion

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: pg_dump why no indicator of completion
Дата
Msg-id A65804DE-890B-4709-AAC4-516748687D72@crazybean.net
обсуждение исходный текст
Ответ на Re: pg_dump why no indicator of completion  (richard coleman <rcoleman.ascentgl@gmail.com>)
Ответы Re: pg_dump why no indicator of completion  (richard coleman <rcoleman.ascentgl@gmail.com>)
Список pgsql-admin

On May 1, 2023, at 9:55 AM, richard coleman <rcoleman.ascentgl@gmail.com> wrote:

Are you writing that pg_dump is unfit for purpose and that I should be using a commercial backup solution instead?


pg_dump is a logical backup.  If you need a fast logical backup; then it’s the right tool.  To get a fast logical backup use the directory format, multiple threads (jobs), and turn off compression.  You shouldn’t have to wait days to get a logical backup; if so, maybe your system is too small and/or disks are too slow.

i.e.  pg_dump --format=d --file=prod --compress=0 —jobs=16 prod

However, for database backups a binary solution is best as it is faster and allows for point in time recovery if archiving is enabled.

Relying on logical backups as a backup solution seems like a bad idea.

-rui

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: pg_dump why no indicator of completion
Следующее
От: richard coleman
Дата:
Сообщение: Re: pg_dump why no indicator of completion