Re: Question about pg_dump + pg_restore + pg_toast

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Question about pg_dump + pg_restore + pg_toast
Date: 2025-03-01 21:27:19
Message-ID: 3072390.1740864439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Edwin UY <edwin(dot)uy(at)gmail(dot)com> writes:
> If need be, do I manually edit the dumpfile using something like vi?

That's usually the last-ditch answer. Often you can just feed the
script to psql and ignore any errors, though.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-03-02 00:40:14 Re: Question about pg_dump + pg_restore + pg_toast
Previous Message Edwin UY 2025-03-01 20:53:48 Re: Question about pg_dump + pg_restore + pg_toast