| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Question about pg_dump + pg_restore + pg_toast |
| Date: | 2025-03-02 06:39:13 |
| Message-ID: | 9288d07b0ae4f7d6c1d7a5cc0a6f72ed1830872c.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin UY | 2025-03-02 09:45:30 | Re: Question about pg_dump + pg_restore + pg_toast |
| Previous Message | Ron Johnson | 2025-03-02 00:44:27 | Re: Question about pg_dump + pg_restore + pg_toast |