Re: Wal streaming - Mailing list pgsql-general

From Andrew
Subject Re: Wal streaming
Date
Msg-id D99EB7AB-72F7-4769-BE90-92ED6F77AAFF@gmail.com
Whole thread Raw
In response to Re: Wal streaming  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Wal streaming
List pgsql-general
Hi,

I’m using Postgres 17 and the latest versions of repmgr and barman

1. I’m replicating my database to another node using streaming replication. wal_level=replica, hot_standby=on.
2. I’ve got barman running on the primary node locally and have setup the barman config for streaming replication using
streamingarchiver and backup method Postgres. Previous to this I was using the archive and restore commands in
postgresql.confto use barman-wal-archive|restore to copy the wal files to barman’s wal folder.  
3. Barman is on node 1 where the primary is running. The replica database used by repmgr is on node 2.
4. My archive command is still configured to use barman-wal-archive despite having moved to a streaming replication
methodin barman.  

So my question is, can I disable the archive command now that I am using streaming?

Regards
Andrew
Sent from my iPhone

> On 25 Nov 2025, at 16:54, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 11/25/25 05:46, Andrew wrote:
>> Hi,
>> New to the list. If I’m Using streaming archiving with repmgr, and streaming archiving with barman, do I still need
tomaintain my archive command, and have processes in place to delete archived wals periodically?  Or are they in effect
defunctdue to wal retention policies within Postgres? 
>
> You are going to need to expand on this as it is unclear to me what your processes are.
>
> 1) What is the repmgr setup for streaming?
>
> 2) What is the Barman setup for streaming?
>
> 3) What locations are 1 & 2 streaming to?
>
> 4) What is the process you have in place now to prune the archives?
>
> 5) What are the Postgres version you are working with?
>
>> Regards
>> Andrew
>> Sent from my iPhone
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DROP ROLE blocked by pg_init_privs
Next
From: immerrr again
Date:
Subject: Re: DROP ROLE blocked by pg_init_privs