yc datatransfer endpoint create postgres-source
Статья создана
Обновлена 2 декабря 2024 г.
Create PostgreSQL source
Command Usage
Syntax:
yc datatransfer endpoint create postgres-source [<ENDPOINT-NAME>] [Flags...] [Global Flags...]
Flags
| Flag | Description |
|---|---|
--file |
stringPath to a file with grpc request, see proto files in the protobuf API specification: https://github.com/yandex-cloud/cloudapi/tree/master/yandex/cloud/datatransfer/v1 |
--name |
stringEndpoint name |
--description |
stringEndpoint description |
--cluster-id |
stringYandex Managed Service for PostgreSQL cluster ID |
--host |
value[,value]PostgreSQL server host name or IP address |
--port |
intPostgreSQL server port |
--ca-certificate |
stringPath to the CA certificate of the PostgreSQL server. Implies enabled TLS |
--subnet-id |
stringYandex Virtual Private Cloud subnet ID to access the PostgreSQL server through |
--database |
stringDatabase name |
--user |
stringUser name |
--raw-password |
stringRaw password value (unsafe, consider --password-file) |
--password-file |
stringPath to the file containing password |
-i,--include-table |
value[,value]Do not transfer tables other than these |
-p,--exclude-table |
value[,value]Do not transfer these tables |
--slot-lag-limit |
intTerminate replication once the WAL lag on the slot exceeds the specified limit, in bytes. Unlimited by default |
--service-schema |
stringSchema to create auxiliary tables in |
-b,--transfer-before-data |
value[,value]Schema objects to transfer before transferring data, one of [sequence, sequence_owned_by, table, primary_key, fk_constraint, default_values, constraint, index, view, function, trigger, type, rule, collation, policy, cast, materialized_view, sequence_set] |
-a,--transfer-after-data |
value[,value]Schema objects to transfer after transferring data, one of [sequence, sequence_owned_by, table, primary_key, fk_constraint, default_values, constraint, index, view, function, trigger, type, rule, collation, policy, cast, materialized_view, sequence_set] |
Global Flags
| Flag | Description |
|---|---|
--profile |
stringSet the custom configuration file. |
--debug |
Debug logging. |
--debug-grpc |
Debug gRPC logging. Very verbose, used for debugging connection problems. |
--no-user-output |
Disable printing user intended output to stderr. |
--retry |
intEnable gRPC retries. By default, retries are enabled with maximum 5 attempts. Pass 0 to disable retries. Pass any negative value for infinite retries. Even infinite retries are capped with 2 minutes timeout. |
--cloud-id |
stringSet the ID of the cloud to use. |
--folder-id |
stringSet the ID of the folder to use. |
--folder-name |
stringSet the name of the folder to use (will be resolved to id). |
--endpoint |
stringSet the Cloud API endpoint (host:port). |
--token |
stringSet the OAuth token to use. |
--impersonate-service-account-id |
stringSet the ID of the service account to impersonate. |
--no-browser |
Disable opening browser for authentication. |
--format |
stringSet the output format: text (default), yaml, json, json-rest. |
--jq |
stringQuery to select values from the response using jq syntax |
-h,--help |
Display help for the command. |