GaramX postgresql:configuration https://www.garamx.com/dokuwiki/ 2026-05-06T16:41:54+00:00 GaramX https://www.garamx.com/dokuwiki/ https://www.garamx.com/dokuwiki/lib/tpl/darkblue/images/favicon.ico text/html 2025-04-15T10:05:18+00:00 Anonymous (anonymous@undisclosed.example.com) postgresql:configuration:log https://www.garamx.com/dokuwiki/doku.php?id=postgresql:configuration:log&rev=1744711518&do=diff Query Log 작성 Postgresql은 select, update, insert등등 DB에 호출된 Query를 기록해주는 기능을 제공한다. postgresql.conf의 주요 * log_direcorty='log' * log_filename='postgresql-%Y-%m-%d_%H%M%S.log' * log_statement='all' text/html 2025-04-15T10:05:18+00:00 Anonymous (anonymous@undisclosed.example.com) postgresql:configuration:pg_hba https://www.garamx.com/dokuwiki/doku.php?id=postgresql:configuration:pg_hba&rev=1744711518&do=diff pg_hba.conf PostgreSQL Client Authentication Configuration File # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 172.30.1.1/24 trust # IPv6 local connections: host all all ::1/12…