A Postgresql Pulumi resource package
APACHE-2.0 License
The postgresql resource provider for Pulumi lets you manage postgresql resources in your cloud programs. To use this package, please install the Pulumi CLI first.
This package is available in many languages in the standard packaging formats.
To use from JavaScript or TypeScript in Node.js, install using either npm
:
$ npm install @pulumi/postgresql
or yarn
:
$ yarn add @pulumi/postgresql
To use from Python, install using pip
:
$ pip install pulumi_postgresql
To use from Go, use go get
to grab the latest version of the library
$ go get github.com/pulumi/pulumi-postgresql/sdk/v3
To use from .NET, install using dotnet add package
:
$ dotnet add package Pulumi.Postgresql
The following configuration points are available:
postgresql:host
- (required) The address for the postgresql server connection. Can also be specified with the PGHOST
postgresql:port
- (optional) The port for the postgresql server connection. The default is 5432
. Can also be specifiedPGPORT
environment variable.postgresql:database
- (optional) Database to connect to. The default is postgres
. Can also be specifiedPGDATABASE
environment variable.postgresql:username
- (required) Username for the server connection. The default is postgres
. Can also be specifiedPGUSER
environment variable.postgresql:password
- (optional) Password for the server connection. Can also be specified with the PGPASSWORD
environment variable.postgresql:database_username
- (optional) Username of the user in the database if different than connection username (See user name maps).postgresql:superuser
- (optional) Should be set to false if the user to connect is not a PostgreSQL superuser (as is the case in RDS).postgresql:sslmode
- (optional) Set the priority for an SSL connection to the server. Valid values for sslmode are (note: prefer is not supported by Go's lib/pq):
disable
- No sslrequire
- always SSL (the default, also skip verification)verify-ca
- always SSL (verify that the certificate presented by the server was signed by a trusted CA)verify-full
- Always SSL (verify that the certification presented by the server was signed by a trusted CA and the serverPGSSLMODE
environment variable.postgresql:connect_timeout
- (optional) Maximum wait for connection, in seconds. The default is 180s
. Zero or not specified means wait indefinitely.PGCONNECT_TIMEOUT
environment variable.postgresql:max_connections
- (optional) Set the maximum number of open connections to the database. The default is 4
. Zero means unlimited open connections.postgresql:expected_version
- (optional) Specify a hint to Terraform regarding the expected version that the provider will be talking with. This is apostgresql:clientcert
- (optional) Clientcert block for configuring SSL certificate.
postgresql:clientcert.cert
- (required) The SSL client certificate file path. The file must contain PEM encoded data.postgresql:clientcert.key
- (required) The SSL client certificate private key file path. The file must contain PEM encoded data.For further information, please visit the postgresql provider docs or for detailed reference documentation, please visit the API docs.