Skip to main content
Pre-release

This release is a pre-release and may not be stable for production use.

Actions Status Slack NPM version Python version NuGet version PkgGoDev License

postgresql Resource Provider

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.

Installing

This package is available in many languages in the standard packaging formats.

Node.js (Java/TypeScript)

To use from JavaScript or TypeScript in Node.js, install using either npm:

$ npm install @pulumi/postgresql

or yarn:

$ yarn add @pulumi/postgresql

Python

To use from Python, install using pip:

$ pip install pulumi_postgresql

Go

To use from Go, use go get to grab the latest version of the library

$ go get github.com/pulumi/pulumi-postgresql/sdk/v3

.NET

To use from .NET, install using dotnet add package:

$ dotnet add package Pulumi.Postgresql

Configuration

The following configuration points are available:

  • postgresql:host - (required) The address for the postgresql server connection. Can also be specified with the PGHOST environment variable.
  • postgresql:port - (optional) The port for the postgresql server connection. The default is 5432. Can also be specified with the PGPORT environment variable.
  • postgresql:database - (optional) Database to connect to. The default is postgres. Can also be specified with the PGDATABASE environment variable.
  • postgresql:username - (required) Username for the server connection. The default is postgres. Can also be specified with the PGUSER 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). In this case, some features might be disabled (e.g.: Refreshing state password from database).
  • 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 ssl
    • require - 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 server host name matches the one in the certificate) Additional information on the options and their implications can be seen in the libpq(3) SSL guide. Can also be specified with the PGSSLMODE environment variable.
  • postgresql:connect_timeout - (optional) Maximum wait for connection, in seconds. The default is 180s. Zero or not specified means wait indefinitely. Can also be specified with the 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 a required hint in order for the provider to talk with an ancient version of PostgreSQL. This parameter is expected to be a PostgreSQL Version or current. Once a connection has been established, the provider will fingerprint the actual version. Default: 9.0.0.
  • postgresql: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.

Reference

For further information, please visit the postgresql provider docs or for detailed reference documentation, please visit the API docs.

Metadata

Release files for pulumi-postgresql 3.14.0a1731737772

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pulumi-postgresql 3.14.0a1731737772
File Size Uploaded Provenance Actions
pulumi_postgresql-3.14.0a1731737772.tar.gz 44.3 kB Without provenance Details for pulumi_postgresql-3.14.0a1731737772.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for pulumi-postgresql 3.14.0a1731737772
File Interpreter ABI Platform Actions
pulumi_postgresql-3.14.0a1731737772-py3-none-any.whl Python 3 none any Details for pulumi_postgresql-3.14.0a1731737772-py3-none-any.whl

Total release size: 114.0 kB

Release files / pulumi_postgresql-3.14.0a1731737772.tar.gz

Download URL pulumi_postgresql-3.14.0a1731737772.tar.gz
Size 44.3 kB
Tags Source
SHA-256 checksum
How to use checksums
33e7734476eb81fd6fb4624e26be8f57e2923f2390854f7d0f4a983f83138a69
BLAKE2b-256 checksum
How to use checksums
64863a5f9c21880b88e9ea2fd60cf3211aa95fbc38dc3ff83026ec12a3c95117
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.11.8

Release files / pulumi_postgresql-3.14.0a1731737772-py3-none-any.whl

Download URL pulumi_postgresql-3.14.0a1731737772-py3-none-any.whl
Size 69.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
7e8c77cee20477ad4235ebee1a82f95b37bf5f85b2257400678031c1ab27e2de
BLAKE2b-256 checksum
How to use checksums
60e5800a2bd0b7c43f16a8cce7c6041cd89a933be19feb4143a45ae4b172ea5c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.11.8

Security for pulumi-postgresql 3.14.0a1731737772

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page