To create a connection profile for PostgreSQL, run:
gdcloud database connection-profiles create postgresql pg-connection-profile-sample \
--password=123456 --username=my-user --host=1.2.3.4 --port=5432 --ca-certificate=/path/to/ca.crt
REQUIRED FLAGS
--ca-certificate string file path for x509 PEM-encoded certificate of the CA that signed the database server's certificate.
--host string IP or hostname of the database.
--password string Password for the user that the migration service uses to connect to the database.
--username string Username that the migration service uses to connect to the database.
OPTIONAL FLAGS
--client-certificate string file path for x509 PEM-encoded certificate that will be used by the replica to authenticate against the database server.
--port int32 Network port of the database. (default 5432)
--private-key string file path for Unencrypted PKCS#1 or PKCS#8 PEM-encoded private key associated with the Client Certificate.
GDCLOUD WIDE FLAGS
These flags are available to all commands: --configuration, --format, --help, --project, --quiet.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThe \u003ccode\u003egdcloud database connection-profiles create\u003c/code\u003e command is used to establish a connection profile for data migration for a specified database type.\u003c/p\u003e\n"],["\u003cp\u003eCreating a connection profile requires specifying the database type, connection profile name, username, password, host, and CA certificate.\u003c/p\u003e\n"],["\u003cp\u003eThe command allows for optional flags such as client certificate, private key, and port, with the default port for connections set to 5432.\u003c/p\u003e\n"],["\u003cp\u003eThere are global flags that are available for use with this command, including \u003ccode\u003e--configuration\u003c/code\u003e, \u003ccode\u003e--format\u003c/code\u003e, \u003ccode\u003e--help\u003c/code\u003e, \u003ccode\u003e--project\u003c/code\u003e, and \u003ccode\u003e--quiet\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# gdcloud database connection-profiles create\n\nNAME\n----\n\ngdcloud database connection-profiles create - Create a connection profile for data migration for specified database type.\n\nSYNOPSIS\n--------\n\n gdcloud database connection-profiles create DATABASE_TYPE CONNECTION_PROFILE_NAME [flags]\n\n### EXAMPLES\n\n To create a connection profile for PostgreSQL, run:\n\n gdcloud database connection-profiles create postgresql pg-connection-profile-sample \\\n --password=123456 --username=my-user --host=1.2.3.4 --port=5432 --ca-certificate=/path/to/ca.crt\n\n### REQUIRED FLAGS\n\n --ca-certificate string file path for x509 PEM-encoded certificate of the CA that signed the database server's certificate.\n --host string IP or hostname of the database.\n --password string Password for the user that the migration service uses to connect to the database.\n --username string Username that the migration service uses to connect to the database.\n\n### OPTIONAL FLAGS\n\n --client-certificate string file path for x509 PEM-encoded certificate that will be used by the replica to authenticate against the database server.\n --port int32 Network port of the database. (default 5432)\n --private-key string file path for Unencrypted PKCS#1 or PKCS#8 PEM-encoded private key associated with the Client Certificate.\n\n### GDCLOUD WIDE FLAGS\n\nThese flags are available to all commands: `--configuration`, `--format`, `--help`, `--project`, `--quiet`.\n\nFor more information, see the [gdcloud CLI reference overview](/distributed-cloud/hosted/docs/latest/gdch/resources/gdcloud-reference/gdcloud) page."]]