...
The method used for creating the DR cluster (WAL Streaming)
The replication user that is used for streaming connection to the primary cluster. By default, the Postgres user is used. It is recommended to use a different user for establishing this connection.
SUPERUSER
pg_read_all_stats
role needed for the user because retrieving streaming sync status between primary database and standby database requiresSUPERUSER
pg_read_all_stats
access. Sample user creation SQL used
Code Block |
---|
create user repuser replication login encrypted password 'xxxxxx'; alter ROLEGRANT pg_read_all_stats TO repuser SUPERUSER; |
The password of the replication user that is used for streaming connection to the primary cluster.
A replication test that can be done to ensure the correct username and password with necessary privileges and the whether the pg_hba.conf updates are correct.
The result of the replication test. By, default the observer is enabled that will start monitoring the configuration as soon the DR cluster is created.
Click start to start creating the DR cluster using WAL streaming method.
...