...
2.1 Explanation
| Drawio |
|---|
| mVer | 2 |
|---|
| zoom | 1 |
|---|
| simple | 0 |
|---|
| zoominComment | 10 |
|---|
| inCommentcustContentId | 03679945223 |
|---|
| pageId | 3673391206 |
|---|
| custContentIdlbox | 36799452231 |
|---|
| diagramDisplayName | csd-streaming-customer-v1 |
|---|
| lbox | 1 |
|---|
| contentVer | 4 |
|---|
| revision | 4 |
|---|
| baseUrl | https://dbvisit.atlassian.net/wiki |
|---|
| diagramName | csd-streaming-customer-v1 |
|---|
| pCenter | 0 |
|---|
| width | 1021 |
|---|
| links | |
|---|
| tbstyle | |
|---|
| height | 1334.23 |
|---|
|
...
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. Sample user creation SQL used. SUPERUSER role needed here because only SUPERUSER can retrieve the for the user because retrieving streaming sync status between primary database and standby database requires SUPERUSER access. Sample user creation SQL used
| Code Block |
|---|
create user repuser replication login encrypted password 'xxxxxx';
alter ROLE repuser SUPERUSER; |
...
Below is a detailed explanation of how the DR cluster is created in the background.
| Drawio |
|---|
| mVer | 2 |
|---|
| zoom | 1 |
|---|
| simple | 0 |
|---|
| zoominComment | 10 |
|---|
| inCommentcustContentId | 03679846991 |
|---|
| pageId | 3673391206 |
|---|
| custContentIdlbox | 36798469911 |
|---|
| diagramDisplayName | csd-archive-customer-v1.drawio |
|---|
| lbox | 1 |
|---|
| contentVer | 3 |
|---|
| revision | 3 |
|---|
| baseUrl | https://dbvisit.atlassian.net/wiki |
|---|
| diagramName | csd-archive-customer-v1.drawio |
|---|
| pCenter | 0 |
|---|
| width | 1038.4999999999998 |
|---|
| links | |
|---|
| tbstyle | |
|---|
| height | 877.1199999999999 |
|---|
|
...
This method of creating the standby is specific to Dbvisit. The wal files from the primary are copied to standby at regular intervals and applied on the standby.
| Drawio |
|---|
| mVer | 2 |
|---|
| zoom | 1 |
|---|
| simple | 0 |
|---|
| zoominComment | 10 |
|---|
| inCommentcustContentId | 03679880259 |
|---|
| pageId | 3673391206 |
|---|
| custContentIdlbox | 36798802591 |
|---|
| diagramDisplayName | csd-logshipping-customer-v1.drawio | lbox | 1 |
|---|
| contentVer | 3 |
|---|
| revision | 3 |
|---|
| baseUrl | https://dbvisit.atlassian.net/wiki |
|---|
| diagramName | csd-logshipping-customer-v1.drawio |
|---|
| pCenter | 0 |
|---|
| width | 1038.5 |
|---|
| links | |
|---|
| tbstyle | |
|---|
| height | 1107.12 |
|---|
|
...