Re: Question about pg_dump + pg_restore + pg_toast

Yikes, I thought it is alright so long as I use the latest version of
pg_dump and restore.
Thanks for the warning.

On Tue, Feb 25, 2025 at 12:35 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Mon, 2025-02-24 at 22:19 +1300, Edwin UY wrote:
> > We are upgrading this database from v12 to v16 and we want to do a dump
> of it in case we decided to do a restore from v16 to v12.
> > SO, after the upgrade, in case we want to rollback to v12, we will do a
> pg_dump using v16 and then using v12 pg_restore
>
> Be warned that downgrade is not supported and restoring the dump to v12
> might well fail.
> You might have to manually edit the dump file until you can restore it
> without errors.
>
> Yours,
> Laurenz Albe
>
> --
>
> *E-Mail Disclaimer*
> Der Inhalt dieser E-Mail ist ausschliesslich fuer den
> bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
> dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
> dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung
> oder
> Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich
> in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
>
> *CONFIDENTIALITY NOTICE & DISCLAIMER
> *This message and any attachment are
> confidential and may be privileged or otherwise protected from disclosure
> and solely for the use of the person(s) or entity to whom it is intended.
> If you have received this message in error and are not the intended
> recipient, please notify the sender immediately and delete this message
> and
> any attachment from your system. If you are not the intended recipient, be
> advised that any use of this message is prohibited and may be unlawful,
> and
> you must not copy this message or attachment or disclose the contents to
> any other person.
>