From: | Norbert Poellmann <np(at)ibu(dot)de> |
---|---|
To: | "Capobianco, Tony" <Tony(dot)Capobianco(at)bcbsma(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Barman and Hot Standby |
Date: | 2023-04-05 10:37:24 |
Message-ID: | ZC1PZH3hF1tUPnr/@mail.ibu.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)ibu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Loles | 2023-04-05 11:17:44 | The logical replica crashes when a failover occurs in the physical replica |
Previous Message | hubert depesz lubaczewski | 2023-04-05 10:21:24 | Re: Max tables in a cluster? |