ALTER DATABASE scottdb SET log_min_duration_statement=10;
ALTER USER scott SET log_min_duration_statement=10;
위와 같은 설정을 했다면 각각의 설정은 어떤 catalog 에서 확인가능할까요?
pg_settings 은 아닙니다.
주킹2015-01-29 (목) 09:51
pg_catalog의 pg_db_role_setting에서 확인이 가능합니다.
좀 더 편하게 보기 위해
select d.datname as "name",pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",d.datcollate as "Collate",
d.datctype as "Ctype",pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges",
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
ELSE 'No Access'
END as "Size",
t.spcname as "Tablespace",s.setconfig,
pg_catalog.shobj_description(d.oid, 'pg_database') as "Description"
from pg_database d
left outer join pg_db_role_setting s on d.oid=s.setdatabase
JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid
order by 1;