Provision PostgreSQL operations via CLI

To create a VDB via CLI, you must first create a dSource. For more information on creating a dSource, refer to Link operation via CLI section.

To create a VDB and perform operations via CLI, log in to the Delphix Continuous Data Engine using the admin user account.

CODE

ssh admin@<CONTINUOUS-DATA-FQDN-or-IP>

Provision

Run the following commands to provision a VDB. The following example uses testdb dSource.

CODE

database provision
set type=AppDataProvisionParameters
set container.name=testvdb
set container.group=Untitled 
set source.allowAutoVDBRestartOnHostReboot=true
set sourceConfig.repository="rh86-pg15-t1.dlpxdc.co/Postgres vFiles (15.2)"
set timeflowPointParameters.container=testdb
set sourceConfig.name=testscfgv
set source.parameters="{\"mountLocation\":\"/tmp/singldb2v\", \"privilegedOsUser\":\"\", \"postgresPort\":5443, \"configSettingsStg\":[{\"propertyName\":\"wal_keep_segments\", \"value\": \"8\"}]}"
commit

Disable

Run the following commands to disable a dSource. You must select the same sourceConfig name that was given during VDB creation.

CODE

source
select testscfgv
disable
commit

Enable

Run the following command to enable a dSource.

CODE

source
select testscfgv
enable
commit

Stop

Run the following command to stop a dSource.

CODE

source
select testscfgv
stop
commit

Start

Run the following command to start a dSource.

CODE

source
select testscfgv
start
commit