enable hot standby, allowing read-only connections to the standby cluster
--standby-conf-dir
string
directory for the standby cluster config files on standby host
--standby-data-dir
string
directory for the standby cluster data files on standby host
--tablespace-dir
key=val
customize directory on standby for tablespaces
--streaming-password
string
password to use for the replication connection to the primary cluster
--streaming-username
string
username to use for the replication connection to the primary cluster
-bash-4.2$ ./dbvcli -d PG5432 create-standby streaming
Connecting to the Control Center at centlin72.oraclekiwi.co.nz:4433 ✓
Checking available actions for this configuration ✓
Standby Cluster Location 1/2
Enter the directory on the standby host that will contain the standby cluster
data files. This directory must be empty or nonexistent.
Standby cluster data files directory:
> /u01/PG5432
Standby Cluster Location 2/2
Enter the directory on the standby host that will contain the standby cluster
configuration files. This directory must be empty or nonexistent.
Standby cluster config files directory:
> /u01/PG5432
Hot Standby
Select whether to enable hot standby, allowing read-only connections to the
standby cluster.
Enable hot standby:
(•) Yes
( ) No
Streaming Mode Configuration 1/2
Enter the PostgreSQL username to use for the streaming connection to the source
cluster.
The source cluster must be configured to accept replication connections from the
standby host as this user. Additionally, this user must be granted the
pg_read_all_stats role.
Streaming username:
> repuser
Streaming Mode Configuration 2/2
Enter the password for the streaming connection to the source cluster.
Streaming password:
> *******
Observer
Select whether to enable the Observer. The Observer will watch your
Configuration, and notify you on the Dashboard in case any problems are detected
with your Disaster Recovery Configuration.
Enable Observer:
(•) Yes
( ) No
Confirmation
A base backup of the source cluster will be created and transferred to the
standby host, where it will be used to create the standby cluster. Select Yes to
proceed with creating the standby cluster, or No to cancel the operation.
Create Standby Cluster:
(•) Yes
( ) No
2024-11-01 12:11:02
2024-11-01 12:11:02 Running pre-checks for standby cluster creation
2024-11-01 12:11:02 Preparing to create standby cluster
2024-11-01 12:11:02 Backing up primary cluster
2024-11-01 12:11:02 Backing up config files in directory /u01/PG5432...
2024-11-01 12:11:02 done
2024-11-01 12:11:02 Sending backup to standby
2024-11-01 12:11:02 Sending file 2-base-20241031T231102Z-0_49C68898-0_49C68898-1-1-config.tar to centlin72.oraclekiwi.co.nz...
2024-11-01 12:11:03 done
2024-11-01 12:11:02 Creating standby cluster from backup
2024-11-01 12:11:02 Creating base backup...
2024-11-01 12:11:03 pg_basebackup: initiating base backup, waiting for checkpoint to complete
2024-11-01 12:11:03 pg_basebackup: checkpoint completed
2024-11-01 12:11:03 Base backup started at LSN 0/4A000028
2024-11-01 12:11:03 pg_basebackup: write-ahead log start point: 0/4A000028 on timeline 1
2024-11-01 12:11:03 pg_basebackup: starting background WAL receiver
2024-11-01 12:11:04 33873/940513 kB (3%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:05 82641/940513 kB (8%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:06 131857/940513 kB (14%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:07 182801/940513 kB (19%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:08 243985/940513 kB (25%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:09 295633/940513 kB (31%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:10 349777/940513 kB (37%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:11 362129/940513 kB (38%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:12 394577/940513 kB (41%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:13 442705/940513 kB (47%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:14 485137/940513 kB (51%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:15 527889/940513 kB (56%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:16 576145/940513 kB (61%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:17 623633/940513 kB (66%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:18 668561/940513 kB (71%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:19 715409/940513 kB (76%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:20 766097/940513 kB (81%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:21 810961/940513 kB (86%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:22 856529/940513 kB (91%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:23 904593/940513 kB (96%), 0/1 tablespace (/u01/PG5432/base/16387/16389 )
2024-11-01 12:11:24 917291/940513 kB (97%), 0/1 tablespace (/u01/PG5432/base/4/2600 )
2024-11-01 12:11:25 928721/940513 kB (98%), 0/1 tablespace (/u01/PG5432/base/5/3456_fsm )
2024-11-01 12:11:26 940523/940523 kB (100%), 0/1 tablespace (/u01/PG5432/global/pg_control )
2024-11-01 12:11:26 940523/940523 kB (100%), 1/1 tablespace
2024-11-01 12:11:26 Base backup ended at LSN 0/4A000138
2024-11-01 12:11:26 pg_basebackup: write-ahead log end point: 0/4A000138
2024-11-01 12:11:26 pg_basebackup: waiting for background process to finish streaming ...
2024-11-01 12:11:26 pg_basebackup: syncing data to disk ...
2024-11-01 12:11:31 pg_basebackup: renaming backup_manifest.tmp to backup_manifest
2024-11-01 12:11:31 pg_basebackup: base backup completed
2024-11-01 12:11:32 done
2024-11-01 12:11:32 done
2024-11-01 12:11:32 Extracting config files into /u01/PG5432...
2024-11-01 12:11:32 done
2024-11-01 12:11:32 Starting standby cluster
2024-11-01 12:11:32 Using pg_ctl to start cluster at /u01/PG5432 on 5432...
2024-11-01 12:11:33 pg_ctl: waiting for server to start....2024-11-01 12:11:33.019 NZDT [2475] LOG: redirecting log output to logging collector process
2024-11-01 12:11:33 pg_ctl: 2024-11-01 12:11:33.019 NZDT [2475] HINT: Future log output will appear in directory "log".
2024-11-01 12:11:36 pg_ctl: ... done
2024-11-01 12:11:36 pg_ctl: server started
2024-11-01 12:11:36 done
2024-11-01 12:11:36 Applying DR configuration
2024-11-01 12:11:37 PostgreSQL agents updated for DR.
2024-11-01 12:11:37 Applying Observer settings
2024-11-01 12:11:37 Observer enabled.
2024-11-01 12:11:37
Task succeeded