Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration from CentOS7 to RedHat 9 - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Migration from CentOS7 to RedHat 9
Date
Msg-id CANzqJaDeA9f6P8xs0rZwYB6tbSy9hFibcBGwQqaSpenE3pCSBg@mail.gmail.com
Whole thread Raw
In response to Migration from CentOS7 to RedHat 9  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: Migration from CentOS7 to RedHat 9
List pgsql-admin
Tree view
On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <wasimd60@gmail.com> wrote:
Hi All

I took dump via pg_dump doing ssh from Red hat it took almost 10 hours for 400GB data including 99GB of BLOBS large objects.

ssh postgres@ipaddre "pg_dump -U postgres -d DB1 F c -b -v" > /path/pg.dump

I see a typo.  Is this a copy/paste of what you ran?

Is this normal?

Maybe.  Blobs are slow.  I'd have done a multi-threaded pg_dump, though blobs might be the bottleneck.

--
Death to America, and butter sauce.
Iraq lobster!

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Migration from CentOS7 to RedHat 9
Next
From: Wasim Devale
Date:
Subject: Re: Migration from CentOS7 to RedHat 9