FEATURES:
-
postgresql_default_privileges
: Support default privileges for schema - @kostiantyn-nemchenko #126 -
provider
: Add support for RDS IAM credentials - @Jell #134 -
postgresql_grant
: Support for procedures and routines - @alec-rabold #128
FIXES:
postgresql_grant
: fixtuple concurrently updated
error - @boekkooi-lengoo #169
DEV IMPROVEMENTS:
-
Upgrade Terraform SDK to v2- @cyrilgdn #140
-
Remove vendor directory - @cyrilgdn (and lint fixed by @Jell ) #139 #146
-
docker-compose: Use Docker healthcheck to wait for Postgres to be available - @boekkooi-lengoo #168
FEATURES / FIXES:
-
postgresql_replication_slot
: Create resource to manage replication slots - @BarnabyShearer #70 -
postgresql_physical_replication_slot
: Create resource to manage physical replication slots - @nerzhul #107 -
postgresql_grant
: Addobjects
setting to manage individual objects - @alec-rabold #105 -
Disable
statement_timeout
for connections that need locks - @cyrilgdn #123 -
postgresql_default_privileges
: Allow empty privileges list - @alec-rabold #118 -
postgresql_extension
: Support CREATE EXTENSION ... CASCADE - @kostiantyn-nemchenko #108 -
postgresql_grant
: add foreign data wrapper and server support - @kostiantyn-nemchenko #109
DEV IMPROVEMENTS:
- Run golangci-lint in GH actions and fix errors - @cyrilgdn #122
DOCUMENTATION:
postgresql_grant
: Add missingwith_grant_option
documentation - @ryancausey #64
FEATURES / FIXES:
- Stop locking catalog for every resources - @cyrilgdn #80
DOCUMENTATION:
- Add miss
drop_cascade
docs forpostgresql_extension
- @MaxymVlasov #89
FEATURES:
- Update Go version to 1.16: This allows builds for for darwin arm64 - @benfdking #76
FEATURES:
-
postgresql_default_privileges
: Addwith_grant_option
- @stawii, @cyrilgdn #10 / #63 -
postgresql_default_privileges
: Makeschema
optional for default privileges on all schemas - @darren-reddick #59 -
postgresql_role
: Addidle_in_transaction_session_timeout
suppor - @colesnodgrass #39
FIXES:
- Fix connect_timeout for gocloud - @ynaka81 #56
FIXES:
- Fix building of connection string parameters - @mcwarman #47
FEATURES:
-
gocloud: Allow to connect with GoCloud to AWS/GCP instances - @cyrilgdn #29
-
postgresql_grant
: Manage grant on schema - @cyrilgdn #30⚠️ This depreciates thepolicy
attribute inpostgresql_schema
-
postgresql_grant
: Allow an empty privileges list (revoke) - @cyrilgdn #26 -
postgresql_grant
/postgresql_default_privileges
: ManagePUBLIC
role - @cyrilgdn #27
FEATURES:
-
postgresql_database
: Drop connections before drop database (Postgresql >=13) - @p4cket #14⚠️ In previous versions, Terraform failed to drop databases if they are still in used. Now databases will be dropped in any case. -
Use lazy connections - @cyrilgdn #5
FEATURES:
postgresql_grant_role
(New resource): Grant role to another role - @dvdliao #4
FIXES:
-
postgresql_role
: Fix quoted search_path - @lovromazgon #1 -
postgresql_grant
: Fix SQL error on function - @p4cket #15
BUG FIXES:
- Revert "Use lazy connections" #199 Plugin panics if not able to connect to the database.
FEATURES:
-
postgresql_extension
: Support drop cascade. (#162 - @multani) -
Use lazy connections. (#199 - @estahn)(Reverted in 1.8.1)
BUG FIXES:
postgresql_grant
: Fix grant on function by removingprokind
column selection. (#171 - @Tommi2Day)
DEV IMPROVEMENTS:
- Set up Github Workflows to create releases. (#3 - @thenonameguy)
This is the first release on Terraform registry
DEV IMPROVEMENTS:
- Add goreleaser config
- Pusblish on Terraform registry: https://registry.terraform.io/providers/cyrilgdn/postgresql/latest
BUG FIXES:
-
all resources: Fix some specific use case on
withRolesGranted
helper. (#162) -
postgresql_role
: Fixbypass_row_level_security
attribute. (#158)
FEATURES:
-
all resources: Grant object owners to connected user when needed. This greatly improves support of non-superuser admin (e.g.: on AWS RDS) (#146)
-
postgresql_grant
,postgresql_default_privileges
: Implement grant on functions. (#144) -
postgresql_default_privileges
: Implement grant on type. (#134)
DEV IMPROVEMENTS:
- Upgrade to Go 1.14 and replace errwrap.Wrapf by fmt.Errorf. (#145)
DOCUMENTATION:
FEATURES:
-
postgresql_grant
: Implement grant on database. (#123) -
Support client/server SSL certificates. (#126)
-
Use SDK validations functions instead of custom ones. (#122)
BUG FIXES:
- Fix
max_connections
validation to allow 0 (unlimited). (#128)
FEATURES:
postgresql_role
: Allow to configurestatement_timeout
for a role. (#105)
FIXES:
- Don't md5 SCRAM-SHA-256 passwords. (#114)
DEV IMPROVEMENTS:
- Upgrade lib/pq to v1.3.0 to support SCRAM-SHA-256 password. (#113)
DOCUMENTATION:
-
Update the "use" section to link to the official provider usage documentation. (#115)
-
postgresql_schema
: Add missing documentation fordatabase
setting. (#118)
FEATURES:
-
postgresql_schema
: Adddatabase
attribute. (#100) -
provider
: Trust expected_version if provided (#103) This allows to disable the version detection which requires a database connection, so plan on empty state does not require a connection. -
postgresql_schema
: Adddrop_cascade
attribute. (#108)
FEATURES:
postgresql_role
: Addsearch_path
attribute. (#93)
BUG FIXES:
postgresql_default_privileges
: Grant owner to connected role before applying default privileges. (#71)
NOTES:
- Terraform SDK migrated to new standalone Terraform plugin SDK v1.0.0
FEATURES:
postgresql_extension
: allow to create extension on another database from the provider.
BREAKING CHANGES:
postgresql_role
: Remove default value for password field.
FEATURES:
- Terraform v0.12 compatibility: Terraform SDK has been upgraded to v0.12.2.
FEATURES:
postgresql_role
: Addroles
attribute. (#52)
BUG FIXES:
-
postgresql_grant
,postgresql_default_privileges
: Fix schema verification. (#74) -
postgresql_extension
: AddIF NOT EXISTS
when creating extension. (#76)
FEATURES:
- New resource: postgresql_grant. This resource allows to grant privileges on all existing tables or sequences for a specified role in a specified schema. (#53)
- New resource: postgresql_default_privileges. This resource allow to manage default privileges for tables or sequences for a specified role in a specified schema. (#53)
BUG FIXES:
postgresql_role
: Fix syntax error withvalid_until
attribute. (#69)
BUG FIXES:
provider
: Add asuperuser
setting to fix role password update when provider is not connected as a superuser. (#66)
FEATURES:
- Add
database_username
in provider configuration to manage user name maps (e.g.: needed for Azure) (#58)
BUG FIXES:
create_database
is now being applied correctly on role creation (#43)- Updating a role password doesn't actually update the role password (#54)
superuser
is now being applied correctly on role creation (#45)- Feature flag system was not working. (#61)
- Updating database does not work for connection_limit / allow_connection / is_template (#61)
- Disable postgresql_extension for Postgres < 9.1 (#61)
- Disable REPLICATION flag in role for Postgres < 9.1. (#61)
postgresql_database
: Fix the way the database owner is granted / revoked during create/update/delete. (#59)
TESTS:
- Travis: Run acceptance tests against multiple Postgres versions.
BUG FIXES:
- Parse Azure PostgreSQL version (#40)
FEATURES:
- support for Postgresql v10 (#31)
DEPRECATED:
provider
:sslmode
is the correct spelling for the various SSL modes. Markssl_mode
as the deprecated spelling. In probably 6mo timessl_mode
will be removed as an alternate spelling. [hashicorp/terraform-provider-postgresql#27]
BUG FIXES:
- Mark Provider
password
as sensitive. [hashicorp/terraform-provider-postgresql#26] - Fix destruction of databases created in RDS. [hashicorp/terraform-provider-postgresql#17]
- Fix DEFAULT values for the
postgresql_database
resource. [hashicorp/terraform-provider-postgresql#9]
NOTES:
- Same functionality as that of Terraform 0.9.8. Repacked as part of Provider Splitout