cloudsql teraform drop instance - ghdrako/doc_snipets GitHub Wiki

jak uniknac;

Error: Error, failed to deleteuser admin-acp-prd in instance clone-acp-prd: googleapi: Error 400: Invalid request: failed to delete user admin-acp-prd: . role "admin-acp-prd" cannot be dropped because some objects depend on it Details: 4 objects in database postgres., invalid

1. skasuj baze ebkdb
2. skasuj extension pg_stat_statement
3. drop extension pg_stat_statement cascade;

drop extension pg_stat_statements;
 
SQL Error [42501]: ERROR: must be owner of extension pg_stat_statements
 
select * from pg_catalog.pg_extension;
 
oid   |extname           |extowner|extnamespace|extrelocatable|extversion|extconfig|extcondition|

------+------------------+--------+------------+--------------+----------+---------+------------+

14040|plpgsql           |      10|          11|false         |1.0       |NULL     |NULL        |

141275|pg_stat_statements|   16466|        2200|true          |1.8       |NULL     |NULL        |
 

albo

ALTER EXTENSION pg_stat_statements OWNER TO postgres;

4. usun z teraformow opcje dla pg_stat_statement

pg_stat_statements.max"="10000"                    
"pg_stat_statements.track"="all"

5. reasign REASSIGN OWNED BY "admin-acp-prd" TO postgres; DROP OWNED BY "admin-acp-prd";

SELECT oid::regclass, relkind
FROM pg_class
WHERE relowner = (SELECT oid FROM pg_roles WHERE rolname = 'admin-acp-prd');

Czyszczenie stat

lifecycle {destroy = false}