Postgres Pro
Downloads
Home   >   mailing lists

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

From Edwin UY
Subject Re: Question about pg_dump + pg_restore + pg_toast
Date
Msg-id CA+wokJ-N5KZ=bSNrVnOz_NS9zGofbZu1HijLq9QzmTpb87XN6Q@mail.gmail.com
Whole thread Raw
In response to Re: Question about pg_dump + pg_restore + pg_toast  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Yeah tried to do the pg_dump, 8 hours down the line, not even halfway done. As expected, it is stuck on the way with the largest toast.

pg_dump -v -d [database] -U [user] \
  -h [hostname] \
  --if-exists --clean -Fc \
  -f [dumpfile] \
  --quote-all-identifiers -n [schemaname]

Will try the -Fd and -j option.


On Sun, Mar 2, 2025 at 1:40 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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: Laurenz Albe
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast
Next
From: kaido vaikla
Date:
Subject: pg_upgrade and generated column