Feedback-ID: i76984098:Fastmail
Message-ID: <95c0ba97-f427-4a4b-8e18-67c1ba3a60fd@aklaver.com>
Date: Wed, 26 Nov 2025 11:26:45 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Wal streaming
To: Andrew <adhenry.9@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <4b91a533-b2b7-42fe-bfb7-d92d56c6c1c1@aklaver.com>
 <D99EB7AB-72F7-4769-BE90-92ED6F77AAFF@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <D99EB7AB-72F7-4769-BE90-92ED6F77AAFF@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/95c0ba97-f427-4a4b-8e18-67c1ba3a60fd%40aklaver.com>
Precedence: bulk

On 11/25/25 23:27, Andrew wrote:
> 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 streaming archiver and backup method Postgres. Previous to this I was using the archive and restore commands in postgresql.conf to 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 method in barman.
> 
> So my question is, can I disable the archive command now that I am using streaming?

I am not going to straight up say you can disable the archive command as 
I will not be the one that has to bear the consequences.

What I will say:

1) Have you tested that the Barman, repmgr setups work to do a recovery?

2) Are the two archive processes(streaming replication, 
barman-wal-archive) going to different locations?

3) There is also the question of whether the two archive methods are in 
sync. In other words would you get the same restore if used either at 
some point in time?

My personal opinion is you would be best served by having only one 
tested process working.

> 
> Regards
> Andrew
> Sent from my iPhone
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com