Re: PG_Base Backup take 8 to 9Hrs

Поиск
Список
Период
Сортировка
От MichaelDBA@sqlexec.com
Тема Re: PG_Base Backup take 8 to 9Hrs
Дата
Msg-id 9FC73308-0CB7-425A-8CD1-6750A4295E8A@sqlexec.com
обсуждение исходный текст
Ответ на Re: PG_Base Backup take 8 to 9Hrs  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-admin
Use pgbackrest instead

Sent from my iPhone

> On Feb 8, 2022, at 8:02 AM, Julien Rouhaud <rjuju123@gmail.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.
>
>




В списке pgsql-admin по дате отправления:

Предыдущее
От: "Roberto D. Maggi"
Дата:
Сообщение: pgadmin doesn't show the tables in brand new created db
Следующее
От: Ron
Дата:
Сообщение: Re: pgadmin doesn't show the tables in brand new created db