Back to destination list
Official
PostgreSQL
This destination plugin lets you sync data from a CloudQuery source to a PostgreSQL compatible database.
Loading plugin documentation
This destination plugin lets you sync data from a CloudQuery source to a PostgreSQL compatible database.
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
POSTGRESQL_CONNECTION_STRING
:kind: destination
spec:
name: "postgresql"
path: "cloudquery/postgresql"
registry: "cloudquery"
version: "v8.9.0"
write_mode: "overwrite-delete-stale"
# Learn more about the configuration options at https://cql.ink/postgresql_destination
spec:
# set the environment variable in DSN format like "user=postgres password=pass+0-[word host=localhost port=5432 dbname=postgres sslmode=disable"
# you can also specify it in URI format like "postgres://postgres:pass@localhost:5432/postgres?sslmode=disable". any special URI characters need to be percent-encoded
connection_string: "${POSTGRESQL_CONNECTION_STRING}"
# Optional parameters:
# pgx_log_level: error
# batch_size: 10000 # 10K entries
# batch_size_bytes: 100000000 # 100 MB
# batch_timeout: 60s
# create_performance_indexes: false #create indexes that help with performance when using `write_mode: overwrite-delete-stale`
batch_size
and batch_size_bytes
.connection_string
(string
) (required)pgxpool
"user=user password=pass+0-[word host=localhost port=5432 dbname=mydb sslmode=disable"
DSN format"postgres://user:pass@localhost:5432/mydb?sslmode=prefer"
connect with tcp and prefer TLS"postgres://user:pass@localhost:5432/mydb?sslmode=disable&application_name=pgxtest&search_path=myschema&connect_timeout=5"
be explicit with all options"postgres://localhost:5432/mydb?sslmode=disable"
connect with os username cloudquery is being run as"postgres:///mydb?host=/tmp"
connect over unix socket"dbname=mydb"
unix domain socket, just specifying the db name - useful if you want to use peer authenticationpgx_log_level
(string
) (optional) (default: error
)batch_size
(integer
) (optional) (default: 10000
)batch_size_bytes
(integer
) (optional) (default: 100000000
(= 100 MB))batch_timeout
(duration
) (optional) (default: 60s
(= 60 seconds))create_performance_indexes
(boolean
) (optional) (default: false
)write_mode: overwrite-delete-stale
.pgx
built-in logging and might output data/sensitive information to logs so make sure to not use it in production but only for debugging.kind: destination
spec:
name: postgresql
path: cloudquery/postgresql
registry: cloudquery
version: "v8.9.0"
spec:
connection_string: ${PG_CONNECTION_STRING}
pgx_log_level: debug # Available: error, warn, info, debug, trace. Default: "error"