Content Comparison

Introduction

There are three methods for creating a DR cluster, each with two options.

• WAL Streaming

  • Hot Standby

  • Warm Standby

• WAL file Archiving

  • Hot Standby

  • Warm Standby

• WAL file Shipping

  • Hot Standby

  • Warm Standby

For Hot Standby, the standby database is accessible by the application as a read-only cluster, and the databases under the cluster can be queried and used for reporting purposes. This can happen while the standby cluster databases are still getting synced by the primary cluster.

The Warm Standby Cluster databases are not accessible by the application but are still getting synced by the primary cluster.

To create a DR cluster, you can either click on setup now? or “Set Up Disaster Recovery”

...

WAL Archiving (Hot Standby)

Few points to remember when creating HOT DR cluster using the WAL Archive method.

1. A full backup is taken on the primary and sent to the standby server.

2. The primary cluster will be restarted before creating the cluster to update the parameters on postgresql.conf file. All parameters added by Dbvisit will be added in the end.

3. Ensure that the backup locations have enough free space available on both primary and standby for backup and restore operations.

Below are the details that need to be entered when creating the DR cluster using WAL Archive method.

( 1 ) The data file locations of the standby cluster. This value is default value as seen on the primary but can be changed to a different location.

( 2 ) The standby is run as a HOT standby, so the databases of the cluster are accessible to the user as a read-only databases.

( 3 ) The method used for creating the DR cluster is “WAL file Archiving”.

( 4 ) The base backup location of the primary server and the location to which it is transferred on the standby server.

( 5 ) The custom backup location where the WAL files are copied in primary and then transferred to the standby location from which it is applied.

( 6 ) The archive timeout setting. This value in seconds will ensure that the standby is synced with the primary every 60secs. This value can be changed to a higher value.

( 7 ) The observer is enabled by default to monitor the configuration as soon as the DR cluster is created.

( 8 ) Press start to start the creation process.

...