pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBarman and Hot Standby
2+ messages / 2 participants
[nested] [flat]
* Barman and Hot Standby
@ 2023-04-04 22:24 Capobianco, Tony <Tony.Capobianco@bcbsma.com>
0 siblings, 1 reply; 2+ messages in thread
From: Capobianco, Tony @ 2023-04-04 22:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Barman and Hot Standby
@ 2023-04-05 10:37 Norbert Poellmann <np@ibu.de>
parent: Capobianco, Tony <Tony.Capobianco@bcbsma.com>
0 siblings, 0 replies; 2+ messages in thread
From: Norbert Poellmann @ 2023-04-05 10:37 UTC (permalink / raw)
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-04-05 10:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-04-04 22:24 Barman and Hot Standby Capobianco, Tony <Tony.Capobianco@bcbsma.com>
2023-04-05 10:37 ` Norbert Poellmann <np@ibu.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox