Re: Question about pg_dump + pg_restore + pg_toast

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Question about pg_dump + pg_restore + pg_toast
Date: 2025-03-02 00:40:14
Message-ID: CANzqJaC4Gi9QFAoxGM6XLcScd_L+awdzKOiSjcHV75znzRpQ7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Mar 1, 2025 at 4:27 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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.

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!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-03-02 00:44:27 Re: Question about pg_dump + pg_restore + pg_toast
Previous Message Tom Lane 2025-03-01 21:27:19 Re: Question about pg_dump + pg_restore + pg_toast