Skip to content

Instantly share code, notes, and snippets.

@bendrucker
Last active July 10, 2020 01:03
Show Gist options
  • Save bendrucker/87141262bedea3169993f70c89c2502a to your computer and use it in GitHub Desktop.
Save bendrucker/87141262bedea3169993f70c89c2502a to your computer and use it in GitHub Desktop.
Results of running PostgreSQL provider acceptance tests against AWS Redshift
$ TF_ACC=1 go test ./postgresql -v -timeout 120m
=== RUN TestProvider
--- PASS: TestProvider (0.00s)
=== RUN TestProvider_impl
--- PASS: TestProvider_impl (0.00s)
=== RUN TestAccPostgresqlDatabase_Basic
TestAccPostgresqlDatabase_Basic: testing.go:569: Step 0 error: errors during apply:
Error: Error creating database "mydb_default_owner": pq: TEMPLATE is not supported
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test702034510/main.tf line 75:
(source code not available)
Error: error creating role myrole: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test702034510/main.tf line 2:
(source code not available)
--- FAIL: TestAccPostgresqlDatabase_Basic (0.62s)
=== RUN TestAccPostgresqlDatabase_DefaultOwner
TestAccPostgresqlDatabase_DefaultOwner: testing.go:569: Step 0 error: errors during apply:
Error: error creating role myrole: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test321151664/main.tf line 2:
(source code not available)
Error: Error creating database "mydb_default_owner": pq: TEMPLATE is not supported
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test321151664/main.tf line 75:
(source code not available)
--- FAIL: TestAccPostgresqlDatabase_DefaultOwner (0.42s)
=== RUN TestAccPostgresqlDatabase_Update
TestAccPostgresqlDatabase_Update: testing.go:569: Step 0 error: errors during apply:
Error: Error creating database "test_db": pq: TEMPLATE is not supported
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test785530722/main.tf line 2:
(source code not available)
--- FAIL: TestAccPostgresqlDatabase_Update (0.18s)
=== RUN TestAccPostgresqlDatabase_GrantOwner
TestAccPostgresqlDatabase_GrantOwner: testing.go:569: Step 0 error: errors during apply:
Error: error creating role test_owner: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test886630628/main.tf line 2:
(source code not available)
--- FAIL: TestAccPostgresqlDatabase_GrantOwner (0.23s)
=== RUN TestAccPostgresqlDatabase_GrantOwnerNotNeeded
TestAccPostgresqlDatabase_GrantOwnerNotNeeded: utils_test.go:70: could not execute query CREATE ROLE test_owner; GRANT test_owner TO test: pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlDatabase_GrantOwnerNotNeeded (0.14s)
=== RUN TestAccPostgresqlDefaultPrivileges
TestAccPostgresqlDefaultPrivileges: utils_test.go:70: could not execute query CREATE ROLE tf_tests_role_1594255500249912000 LOGIN ENCRYPTED PASSWORD 'testpwd': pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlDefaultPrivileges (0.14s)
=== RUN TestAccPostgresqlDefaultPrivileges_GrantOwner
TestAccPostgresqlDefaultPrivileges_GrantOwner: utils_test.go:70: could not execute query CREATE ROLE tf_tests_role_1594255500389909000 LOGIN ENCRYPTED PASSWORD 'testpwd': pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlDefaultPrivileges_GrantOwner (0.14s)
=== RUN TestAccPostgresqlExtension_Basic
TestAccPostgresqlExtension_Basic: utils_test.go:25: Skip extension tests for Postgres 8.0.2
--- SKIP: TestAccPostgresqlExtension_Basic (0.00s)
=== RUN TestAccPostgresqlExtension_SchemaRename
TestAccPostgresqlExtension_SchemaRename: utils_test.go:25: Skip extension tests for Postgres 8.0.2
--- SKIP: TestAccPostgresqlExtension_SchemaRename (0.00s)
=== RUN TestAccPostgresqlExtension_Database
TestAccPostgresqlExtension_Database: utils_test.go:70: could not execute query CREATE ROLE tf_tests_role_1594255500535139000 LOGIN ENCRYPTED PASSWORD 'testpwd': pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlExtension_Database (0.14s)
=== RUN TestCreateGrantQuery
--- PASS: TestCreateGrantQuery (0.00s)
=== RUN TestCreateRevokeQuery
--- PASS: TestCreateRevokeQuery (0.00s)
=== RUN TestAccPostgresqlGrant
TestAccPostgresqlGrant: utils_test.go:70: could not execute query CREATE ROLE tf_tests_role_1594255500676739000 LOGIN ENCRYPTED PASSWORD 'testpwd': pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlGrant (0.14s)
=== RUN TestAccPostgresqlGrantDatabase
TestAccPostgresqlGrantDatabase: utils_test.go:25: Skip extension tests for Postgres 8.0.2
--- SKIP: TestAccPostgresqlGrantDatabase (0.00s)
=== RUN TestAccPostgresqlRole_Basic
TestAccPostgresqlRole_Basic: utils_test.go:25: Skip extension tests for Postgres 8.0.2
--- SKIP: TestAccPostgresqlRole_Basic (0.00s)
=== RUN TestAccPostgresqlRole_Update
TestAccPostgresqlRole_Update: utils_test.go:25: Skip extension tests for Postgres 8.0.2
--- SKIP: TestAccPostgresqlRole_Update (0.00s)
=== RUN TestAccPostgresqlSchema_Basic
TestAccPostgresqlSchema_Basic: testing.go:569: Step 0 error: errors during apply:
Error: Error reading schema: pq: cannot cast type aclitem[] to character varying[]
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test157935030/main.tf line 11:
(source code not available)
Error: error creating role role_all_without_grant: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test157935030/main.tf line 2:
(source code not available)
Error: error creating role role_all_with_grant: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test157935030/main.tf line 7:
(source code not available)
TestAccPostgresqlSchema_Basic: testing.go:630: Error destroying resource! WARNING: Dangling resources
may exist. The full state and error is shown below.
Error: errors during refresh: Error reading schema: pq: cannot cast type aclitem[] to character varying[]
State: <nil>
--- FAIL: TestAccPostgresqlSchema_Basic (1.59s)
=== RUN TestAccPostgresqlSchema_AddPolicy
TestAccPostgresqlSchema_AddPolicy: testing.go:569: Step 0 error: errors during apply:
Error: error creating role all_without_grant_stay: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 2:
(source code not available)
Error: error creating role all_without_grant_drop: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 6:
(source code not available)
Error: error creating role all_with_grantdrop: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 22:
(source code not available)
Error: error creating role policy_compose: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 10:
(source code not available)
Error: error creating role all_with_grantstay: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 18:
(source code not available)
Error: error creating role policy_move: pq: syntax error at or near "ROLE"
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test647378520/main.tf line 14:
(source code not available)
--- FAIL: TestAccPostgresqlSchema_AddPolicy (1.32s)
=== RUN TestAccPostgresqlSchema_Database
TestAccPostgresqlSchema_Database: utils_test.go:70: could not execute query CREATE ROLE tf_tests_role_1594255503730423000 LOGIN ENCRYPTED PASSWORD 'testpwd': pq: database "postgres" does not exist
--- FAIL: TestAccPostgresqlSchema_Database (0.14s)
=== RUN TestAccPostgresqlSchema_DropCascade
TestAccPostgresqlSchema_DropCascade: testing.go:569: Step 0 error: errors during apply:
Error: Error reading schema: pq: cannot cast type aclitem[] to character varying[]
on /var/folders/7p/z_kw6fc9693fly126tljpml40000gn/T/tf-test269227338/main.tf line 2:
(source code not available)
TestAccPostgresqlSchema_DropCascade: testing.go:630: Error destroying resource! WARNING: Dangling resources
may exist. The full state and error is shown below.
Error: errors during refresh: Error reading schema: pq: cannot cast type aclitem[] to character varying[]
State: <nil>
--- FAIL: TestAccPostgresqlSchema_DropCascade (1.21s)
FAIL
FAIL github.com/terraform-providers/terraform-provider-postgresql/postgresql 6.722s
FAIL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment