Skip to content

doctolib/terraform-provider-postgresql

This branch is 38 commits ahead of, 57 commits behind cyrilgdn/terraform-provider-postgresql:main.

Folders and files

NameName
Last commit message
Last commit date
May 15, 2025
Jan 30, 2022
Apr 8, 2025
Sep 24, 2021
Jan 3, 2022
Apr 8, 2025
Apr 9, 2021
Jul 17, 2020
Aug 21, 2021
Mar 20, 2025
Oct 3, 2023
Jul 26, 2023
Jun 5, 2017
Aug 29, 2023
Aug 29, 2023
Apr 8, 2025
Oct 3, 2023
Sep 24, 2021
May 6, 2025

Repository files navigation

Terraform Provider for PostgreSQL

This provider allows to manage with Terraform Postgresql objects like databases, extensions, roles, etc..

It's published on the Terraform registry. It replaces https://github.com/hashicorp/terraform-provider-postgresql since Hashicorp stopped hosting community providers in favor of the Terraform registry.

Requirements

  • Terraform 0.12.x
  • Go 1.16 (to build the provider plugin)

Building The Provider

Clone repository to: $GOPATH/src/github.com/cyrilgdn/terraform-provider-postgresql

$ mkdir -p $GOPATH/src/github.com/cyrilgdn; cd $GOPATH/src/github.com/cyrilgdn
$ git clone git@github.com:cyrilgdn/terraform-provider-postgresql

Enter the provider directory and build the provider

$ cd $GOPATH/src/github.com/cyrilgdn/terraform-provider-postgresql
$ make build

Using the provider

Usage examples can be found in the Terraform provider documentation

Developing the Provider

If you wish to work on the provider, you'll first need Go installed on your machine (version 1.11+ is required). You'll also need to correctly setup a GOPATH, as well as adding $GOPATH/bin to your $PATH.

To compile the provider, run make build. This will build the provider and put the provider binary in the $GOPATH/bin directory.

$ make build
...
$ $GOPATH/bin/terraform-provider-postgresql
...

In order to test the provider, you can simply run make test.

$ make test

In order to run the full suite of Acceptance tests, run make testacc.

Note:

  • Acceptance tests create real resources, and often cost money to run.
$ make testacc

In order to manually run some Acceptance test locally, run the following commands:

# spins up a local docker postgres container
make testacc_setup 

# Load the needed environment variables for the tests
source tests/switch_superuser.sh

# Run the test(s) that you're working on as often as you want
TF_LOG=INFO go test -v ./postgresql -run ^TestAccPostgresqlRole_Basic$

# cleans the env and tears down the postgres container
make testacc_cleanup