Re: Question about pg_dump + pg_restore + pg_toast - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Question about pg_dump + pg_restore + pg_toast
Date
Msg-id 9288d07b0ae4f7d6c1d7a5cc0a6f72ed1830872c.camel@cybertec.at
Whole thread Raw
In response to Re: Question about pg_dump + pg_restore + pg_toast  (Ron Johnson <ronljohnsonjr@gmail.com>)
List 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 by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast
Next
From: Edwin UY
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast