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

From Ron Johnson
Subject Re: Question about pg_dump + pg_restore + pg_toast
Date
Msg-id CANzqJaC4Gi9QFAoxGM6XLcScd_L+awdzKOiSjcHV75znzRpQ7Q@mail.gmail.com
Whole thread Raw
In response to Re: Question about pg_dump + pg_restore + pg_toast  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question about pg_dump + pg_restore + pg_toast
List pgsql-admin
On Sat, Mar 1, 2025 at 4:27 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Edwin UY <edwin.uy@gmail.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.

Single-threaded text is pretty slow for a 500GB database.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast
Next
From: Ron Johnson
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast