new, setup 

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read

new

dbvcli new {-t|--type} pgsql [--OPTIONS] dbvcli setup {-t|--type} pgsql [--OPTIONS]

Create a new PostgreSQL Configuration

Option

Type

Description

Option

Type

Description

--license

string

license key

--name

string

new configuration name

--source-host

string

host name of source cluster

--source-pgbin-dir

string

PostgreSQL bin directory on standby host

--source-port

string

PostgreSQL port number of source cluster

--standby-host

string

host name for standby cluster

--standby-pgbin-dir

string

PostgreSQL bin directory on standby host

--standby-port

string

PostgreSQL port number for standby cluster

--username

string

PostgreSQL user name for Authentication on primary host

--password

string

PostgreSQL user password for Authentication on primary host

-bash-4.2$ ./dbvcli -t pgsql new Connecting to the Control Center at centlin72.oraclekiwi.co.nz:4433 ✓ Source Cluster 1/3 Select the host containing the source cluster. Source Host: (•) centlin71.oraclekiwi.co.nz ( ) centlin72.oraclekiwi.co.nz Discovering system information on host centlin71.oraclekiwi.co.nz ✓ Source Cluster 2/3 Select the source cluster or enter the port number manually. Source Cluster: (•) 5432 (version: 15) (data dir: /u01/PG5432) ( ) Manual Entry Source Cluster Authentication 1/2 Prompt Skipped (Using PostgreSQL Username: ) Source Cluster Authentication 2/2 Prompt Skipped (Using PostgreSQL Password: ) CLUSTER DISCOVERED ----------------------- ------------------ Cluster Info Config Cluster Info Value ----------------------- ------------------ Cluster Name Data Directory /u01/PG5432 Configuration Directory /u01/PG5432 DATABASES ------------- ------------- Database Name Database Size ------------- ------------- postgres 7.42 MB track 895.41 MB template1 7.34 MB template0 7.27 MB Source Cluster 3/3 Select or enter the directory containing the binaries for the PostgreSQL installation to use on the source host. Source PostgreSQL Installation: (•) /usr/pgsql-15/bin (version: 15.6) ( ) Manual Entry Standby Cluster 1/3 Select the host for the standby cluster. Standby Host: ( ) centlin71.oraclekiwi.co.nz (•) centlin72.oraclekiwi.co.nz Discovering system information on host centlin72.oraclekiwi.co.nz ✓ Standby Cluster 2/3 Enter the PostgreSQL port number to use for the standby cluster. Standby Port: > 5432 Standby Cluster 3/3 Select or enter the directory containing the binaries for the PostgreSQL installation to use on the standby host. Standby PostgreSQL Installation: (•) /usr/pgsql-15/bin (version: 15.6) ( ) Manual Entry Configuration Name Enter the name for this Configuration. This is how the configuration will be identified in the Control Center. Configuration Name: > PG5432 License Key Enter a license key for this configuration. License Key: > 4jo70-xxxxx-7gplh-xxxxx-pjpnk-2o1za-xxxxx New configuration PG5432 was created successfully. Configuration PG5432 (centlin71.oraclekiwi.co.nz -> centlin72.oraclekiwi.co.nz) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ No standby │ │ ││ cluster │ │ ││ │ └───────────────┘└───────────────┘