From: | "MichaelDBA(at)sqlexec(dot)com" <michaeldba(at)sqlexec(dot)com> |
---|---|
To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
Cc: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>, pgsql-admin(at)lists(dot)postgresql(dot)org, Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in> |
Subject: | Re: PG_Base Backup take 8 to 9Hrs |
Date: | 2022-02-08 14:53:37 |
Message-ID: | 9FC73308-0CB7-425A-8CD1-6750A4295E8A@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Use pgbackrest instead
Sent from my iPhone
> On Feb 8, 2022, at 8:02 AM, Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
>
> Hi,
>
> Please don't try to recall messages sent on a mailing list. That won't work
> and will spam everyone.
>
>> On Tue, Feb 08, 2022 at 11:36:19AM +0000, Ram Pratap Maurya wrote:
>>
>> We are using Postgres -11 version and current PG DB size is 450 GB .
>>
>> Archive log enable in Database and we are running Full PG_Base backup and it
>> will take 8 to 9 Hrs to complete the backup ,
>>
>> Please suggest how to reduce the full DB backup time.
>
> That's ~16MB/s, so many times slower than a single old 7200RPM drive. The
> problem is likely not with postgres, you should get a better storage or a
> better network.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-02-08 15:21:52 | Re: pgadmin doesn't show the tables in brand new created db |
Previous Message | Roberto D. Maggi | 2022-02-08 14:48:50 | pgadmin doesn't show the tables in brand new created db |