Thread: Barman and Hot Standby
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
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