...
2.1 Explanation
| Drawio | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Below is a detailed explanation of how the DR cluster is created in the background.
| Drawio | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
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 | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| Code Block |
|---|
-bash-4.2$ ls -lrt /u01 drwx------ (or drwxr-x---). 5 postgres postgres 4096 Aug 16 16:41 tablespace drwx------ (or drwxr-x---). 20 postgres postgres 4096 Aug 26 12:06 PG5433-12 |
The location of the configuration files (postgresql.conf, pg_hba.conf, and pg_indent.conf). This location can be different from the primary data directory, but the example below has these two in the same directory. Keeping the same as the primary is recommended, but this can also be different in the standby. postgresql.conf, pg_hba.conf, and pg_indent.conf need to be placed in the same folder.
For this example, a Hot standby is created that can be accessible for reporting purposes as the databases in the cluster are in read only mode.
...