Blogacrynite.com

Register a database

Create a reusable PostgreSQL connection profile that later commands refer to by name.

Command

$acrynite database register <name> \
$ --host <hostname> \
$ --username <username> \
$ --database <database-name>

Example

$acrynite database register production \
$ --host db.example.com \
$ --port 5432 \
$ --username acrynite_backup \
$ --database app_db \
$ --ssl-mode require

Options

OptionDescription
--hostPostgreSQL hostname.
--portPostgreSQL port. Defaults to 5432.
--usernamePostgreSQL username.
--databaseDatabase name.
--ssl-modeSSL connection mode.
--dump-pathOptional dump path setting.
--passwordDatabase password.

Avoid exposing passwords in shell history. database show never displays the stored password.