new, setup

new

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

Create a new PostgreSQL Configuration

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

Example

-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    │
│               ││               │
└───────────────┘└───────────────┘

We're here to help!

new

Comments