Re: PG_Base Backup take 8 to 9Hrs

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PG_Base Backup take 8 to 9Hrs
Date: 2022-02-10 15:16:14
Message-ID: c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Just keep in mind that logical dumps and loads do not support Point In
Time Recovery (PITR).

Wells Oliver wrote on 2/10/2022 9:36 AM:
> Can you just try good ole pg_dump with --format=directory and --jobs=X
> where X is some decent number, e.g. 16? We just packed up a 700GB DB
> using 16 jobs and it took maybe 80 minutes.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mladen Gogala 2022-02-10 16:45:25 Re: PG_Base Backup take 8 to 9Hrs
Previous Message Wells Oliver 2022-02-10 14:36:38 Re: PG_Base Backup take 8 to 9Hrs