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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: using pgbackrest in a PG streaming replication cfg with repmgr
Date: 2025-08-26 18:56:02
Message-ID: CANzqJaCgPp_BDjNdcwmq=Zpg=t0R4CZfNO=MXC241e-GASqrZQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 26, 2025 at 1:45 PM Ghiurea, Isabella <
Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)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.

https://www.postgresql.org/docs/16/runtime-config-replication.html
<https://www.postgresql.org/docs/16/runtime-config-replication.html#GUC-MAX-STANDBY-STREAMING-DELAY>

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Apple Pine 2025-08-28 17:59:37 pgAdmin 4 ?
Previous Message Ron Johnson 2025-08-26 18:50:10 Re: using pgbackrest in a PG streaming replication cfg with repmgr