Re: Question about pg_dump + pg_restore + pg_toast

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Question about pg_dump + pg_restore + pg_toast
Дата
Msg-id 9288d07b0ae4f7d6c1d7a5cc0a6f72ed1830872c.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Question about pg_dump + pg_restore + pg_toast  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
On Sat, 2025-03-01 at 19:44 -0500, Ron Johnson wrote:
> [warning and instructions for downgrading PostgreSQL]
> 1. Why would you need to edit the dump file?

Because it might not load into a server with a lower version.

> 2. It's not 2013 anymore: Use multiple threads when backing up!

You cannot do that with the "plain" format, since it writes to a
single file.  And you cannot use the "directory" format that would
allow parallelization, because you cannot edit the DDL statements
with a binary format.

Just don't downgrade PostgreSQL.  There is no good reason to do that.

Yours,
Laurenz Albe



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