Обсуждение: Barman and Hot Standby

On Tue, Apr 04, 2023 at 10:24:20PM +0000, Capobianco, Tony wrote:

Hi,

in my understanding of your question streaming replication

    https://www.postgresql.org/docs/15/high-availability.html

with Hot Standby:

    https://www.postgresql.org/docs/15/hot-standby.html

is the way to go.

Replication is a quite different task than to archive WAL files,
what you have accomplished already with archive_command

cheers

Norbert Poellmann

--
Norbert Poellmann EDV-Beratung             email  : np@ibu.de
Severinstrasse 5                           telefon: 089 38469995  
81541 Muenchen, Germany                    telefon: 0179 2133436 


> I have barman successfully running and performing scheduled backups.
> 
> psql -d db -p 1234 -c "show archive_command"
> archive_command
> --------------------------------------------------------
> barman-wal-archive 10.11.12.13 cluster_name %p
> 
> 
> psql -d db -p 1234 -c "show wal_level"
> 
> wal_level
> 
> -----------
> 
> replica
> 
> 
> How can I add hot standby functionality to my environment if the archive_command is already defined with
barman-wal-archive?
> 
> Thanks.
> Tony