BUG FIXES:
postgresql_grant
: fix grant on function by removing prokind column selection, as is it not available on postgresql version < 11 and its not to expect to have a window(w) or aggregate function(a) with the same name as a normal function(f)
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. [#27]
BUG FIXES:
- Mark Provider
password
as sensitive. [#26] - Fix destruction of databases created in RDS. [#17]
- Fix DEFAULT values for the
postgresql_database
resource. [#9]
NOTES:
- Same functionality as that of Terraform 0.9.8. Repacked as part of Provider Splitout