PGbackrest very slow!

Поиск
Список
Период
Сортировка
От Pär Mattsson
Тема PGbackrest very slow!
Дата
Msg-id CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com
обсуждение исходный текст
Ответы Re: PGbackrest very slow!
Re: PGbackrest very slow!
Список pgsql-admin
Hi!
I have  3 node postgres cluster with repmgr and pgpool.

Pgbackrest is configed like this
We use pgbackrest with this config
=======================================

[global]

backup-standby=y

repo1-path=/postgresql/backup

repo1-retention-full=2

start-fast=y

 

[PG]

pg1-path=/postgresql/data

pg2-host=node2

pg2-host-user=postgres

pg2-path=/postgresql/data

pg3-host=node3

pg3-host-user=postgres

pg3-path=/postgresql/data

=================================================

I run the backuplike this


/usr/bin/pgbackrest --log-level-console=detail --stanza=PG --type=full backup

 


The backup of 50GB took 40 min.

It is not a network issue. I tested to transfer 2GB between two host and it took 4 sec.


I think backup-standby=y slows down the backup out of all minds.


Br Pär

 

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