echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
listen_addresses = '*'
port = 5432
max_connections = 100
shared_buffers = 256MB
dynamic_shared_memory_type = posix
log_destination = 'stderr'
logging_collector = on
log_directory = 'log'
log_filename = 'postgresql-%a.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
log_line_prefix = '%m [%p] '
log_timezone = 'Asia/Seoul'
datestyle = 'iso, ymd'
timezone = 'Asia/Seoul'
lc_messages = 'ko_KR.UTF-8'
lc_monetary = 'ko_KR.UTF-8'
lc_numeric = 'ko_KR.UTF-8'
lc_time = 'ko_KR.UTF-8'
default_text_search_config = 'pg_catalog.simple'
wal_buffers = 8MB
max_wal_size = 1GB
min_wal_size = 80MB
checkpoint_completion_target = 0.9
pg_hba.conf에 다음 추가
host all all 0.0.0.0/0 md5
CREATE ROLE scm LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE cmf LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE rman LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE ranger LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE ranger LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE hue LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE hive LOGIN PASSWORD 'P@ssW0rd!' ;
CREATE ROLE oozie LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE schemaregistry LOGIN PASSWORD 'P@ssW0rd' ;
CREATE ROLE smm LOGIN PASSWORD 'P@ssW0rd' ;
CREATE DATABASE scm OWNER scm ENCODING 'UTF8';
CREATE DATABASE scm OWNER cmf ENCODING 'UTF8';
CREATE DATABASE rman OWNER rman ENCODING 'UTF8';
CREATE DATABASE ranger OWNER ranger ENCODING 'UTF8';
CREATE DATABASE ranger OWNER ranger ENCODING 'UTF8';
CREATE DATABASE hue OWNER hue ENCODING 'UTF8';
CREATE DATABASE hive OWNER hive ENCODING 'UTF8';
CREATE DATABASE oozie OWNER oozie ENCODING 'UTF8';
CREATE DATABASE schemaregistry OWNER schemaregistry ENCODING 'UTF8';
CREATE DATABASE smm OWNER smm ENCODING 'UTF8';