1. Docs
  2. Intro to Pulumi
  3. Cloud Providers
  4. PostgreSQL
  5. PostgreSQL Setup

PostgreSQL Setup

The Pulumi PostgreSQL provider uses the PostgreSQL SDK to manage and provision resources.

Pulumi relies on the PostgreSQL SDK to authenticate requests from your computer to PostgreSQL. Your credentials are never sent to pulumi.com.

The Pulumi PostgreSQL Provider needs to be configured with PostgreSQL credentials before it can be used to manage resources.

Configuring Credentials

In order to communicate your configuration details to Pulumi:

  1. Set the environment variables PGHOST and PGUSER:

    $ export PGHOST=XXXXXXXXXXXXXX
$ export PGUSER=YYYYYYYYYYYYYY

  2. Set them using configuration, if you prefer that they be stored alongside your Pulumi stack for easy multi-user access:

    $ pulumi config set postgresql:host XXXXXXXXXXXXXX
$ pulumi config set postgresql:user YYYYYYYYYYYYYY

If you are going to set postgresql:password, please remember to pass --secret so that it is properly encrypted. A full set of configuration parameters can be found listed on the Project README.