Re: Question about pg_dump + pg_restore + pg_toast

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux