Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL replication and Archive command for pgbackrest on same server conf - Mailing list pgsql-general

From Ruben Morais
Subject Re: WAL replication and Archive command for pgbackrest on same server conf
Date
Msg-id CAG8sLzuiX5AXGAOSesK-gSzAEpV6BLciUhBnwSyVXbuhCn3Utg@mail.gmail.com
Whole thread Raw
In response to WAL replication and Archive command for pgbackrest on same server conf  (KK CHN <kkchn.in@gmail.com>)
List pgsql-general
Tree view
hi, 

you can combine:

archive_command = 'pgbackrest --stanza=Demo  archive-push  %p && cp %p /data/archive/%f '

You need to change your standby replica to consume the wals from pgbackrest if you want instead to use both commands.

Rúben Morais

 (+351) 965775713           ruben.gmorais@gmail.com


On Mon, Aug 19, 2024 at 2:10 PM KK CHN <kkchn.in@gmail.com> wrote:
Hi List ,

I am trying to configure the pgbackrest  on a live server ( RHEL9, EPAS16 and Pgbacrest .2.52)  which is having a working   WAL archive configuration  to a standby server in postgresql.conf as follows


1. archive_mod =on
2. archive_level=replica
3. archive_command = 'cp %p /data/archive/%f'  


To do the pgbackrest conf on the same   archive_command   directive (So both the existing WAL configuration as well as my new pgbackrest option both will work smoothly.   how to add an entry  in line 3  ??

archive_command = 'pgbackrest --stanza=Demo  archive-push  cp %p /data/archive/%f '



Please correct me If I am doing wrong in the above line..


Thank you,
Krish                                

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: use of postgres reg* datatypes in user tables?
Next
From: milist ujang
Date:
Subject: pg 16.4, logical replication, use case = data archiving