From: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
To: PGSQL ADMIN <pgsql-admin@postgresql.org>
Subject: using pgbackrest in a  PG streaming replication cfg with repmgr
Thread-Topic: using pgbackrest in a  PG streaming replication cfg with repmgr
Thread-Index: AQHcFrEgBBH4zLjayUWWejgLw/tqlw==
Date: Tue, 26 Aug 2025 17:44:51 +0000
Message-ID: <d0939d84fc0f494f8aade7d3d0915f29@nrc-cnrc.gc.ca>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_d0939d84fc0f494f8aade7d3d0915f29nrccnrcgcca_"
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/d0939d84fc0f494f8aade7d3d0915f29%40nrc-cnrc.gc.ca>
Precedence: bulk

--_000_d0939d84fc0f494f8aade7d3d0915f29nrccnrcgcca_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 issu=
es with WAL files  transfer and performance in  existing PG streaming repli=
cation configuration , we plan to run pgbackrest only at a slave host and o=
nly 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 th=
e synchronous  streaming replication?

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

thank you !!!


--_000_d0939d84fc0f494f8aade7d3d0915f29nrccnrcgcca_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Helvetica,sans-serif;" dir=3D"ltr">
<p>Hi List,&nbsp;</p>
<p>We&nbsp; have a requirement to start using pgbackrest for&nbsp; db backu=
ps&nbsp; on slave PG hosts already configured in Streaming Replication&nbsp=
; .&nbsp;&nbsp; To avoid any issues with WAL files&nbsp; transfer and perfo=
rmance in&nbsp; 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&nbsp; when already have synchronous replication)=
 . My questions are :</p>
<p>-How do I cfg pgbackrest to not archive/use WAL files&nbsp; without affe=
cting the synchronous&nbsp; streaming replication?</p>
<p>- Are any known issues with pgbackrest &#43; repmgr&nbsp; when running :=
 <span>repmgr standby switchover&nbsp; ?( to promote a new&nbsp; db master =
while slave is online ) or repmgr promote ?
<br>
</span></p>
<p>thank you !!!</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
</div>
</body>
</html>

--_000_d0939d84fc0f494f8aade7d3d0915f29nrccnrcgcca_--