Обсуждение: using pgbackrest in a PG streaming replication cfg with repmgr

Поиск
Список
Период
Сортировка

using pgbackrest in a PG streaming replication cfg with repmgr

От
"Ghiurea, Isabella"
Дата:

Hi List, 

We  have a requirement to start using pgbackrest for  db backups  on slave PG hosts already configured in Streaming Replication  .   To avoid any issues with WAL files  transfer and performance in  existing PG streaming replication configuration , we plan to run pgbackrest only at a slave host and only full database backups ( no need for PITR/incremental  when already have synchronous replication) . My questions are :

-How do I cfg pgbackrest to not archive/use WAL files  without affecting the synchronous  streaming replication?

- Are any known issues with pgbackrest + repmgr  when running : repmgr standby switchover  ?( to promote a new  db master while slave is online ) or repmgr promote ?

thank you !!!




Re: using pgbackrest in a PG streaming replication cfg with repmgr

От
Ron Johnson
Дата:
On Tue, Aug 26, 2025 at 1:45 PM Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

 no need for PITR/incremental  when already have synchronous replication


What happens when you take backups on Sundays, today is Tuesday, but you need the state of the database as it was on Monday at 09:00?

Remember: replication is not a backup!!

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Re: using pgbackrest in a PG streaming replication cfg with repmgr

От
Ron Johnson
Дата:
On Tue, Aug 26, 2025 at 1:45 PM Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

and only full database backups


If you only want to do full backups, then use pg_dump on the replica server.  Might need to adjust parameters like max_standby_streaming_delay and hot_standby_feedbac, just like for long-running queries on the replica.


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!