CipherStash Encryption Migrator options

CipherStash Encryption Migrator is used to encrypt existing data or to apply index changes after encryption configuration changes of a protected database. To install and use the Encryption Migrator, see Using CipherStash Encryption Migrator.

SettingDescriptionDefaultEnvironment Variables
-t, --tableSpecifies the table to migrateNone (Required)CS_TABLE
-k, --primary-keyList of primary key columns (space-delimited)idCS_PRIMARY_KEY
-c, --columnsList of columns to migrate (key=value pairs space-delimited)None (Required)CS_COLUMNS
-H, --hostHost address of CipherStash Proxy instance127.0.0.1CS_HOST
-P, --portPort of CipherStash Proxy instance6432CS_PORT
-N, --database-nameDatabase name (or CipherStash Proxy pool name)None (Required)CS_DATABASE__NAME
-U, --usernameUsername for the CipherStash Proxy poolNone (Required)CS_USERNAME, CS_DATABASE__USERNAME
-p, --passwordPassword for the CipherStash Proxy poolNone (Required)CS_PASSWORD, CS_DATABASE__PASSWORD
-b, --batch-sizeNumber of records to process at once100CS_BATCH_SIZE
-d, --dry-runRuns without updating. Loads data but does not perform updatesNone (Optional)CS_DRY_RUN
-v, --verboseEnables verbose loggingNone (Optional)CS_VERBOSE
-D, --debugEnables debug outputNone (Optional)CS_DEBUG
-f, --log-formatLog format (text or structured)textCS_LOG_FORMAT
-h, --helpDisplays this help message--
-V, --versionPrints the version of the tool--
--decryptDecrypts. Assumes source is encrypted and target is plaintextNone (Optional)

Database Details

As Migrator relies on Proxy for encryption, the database connection options should reference the CipherStash Proxy pool, not the actual Postgres database connection details.

Note

The database connection ENV variable definitions are shared with CipherStash Proxy, allowing for reuse of the shared configuration options.