Cloudera Manager 7.13.x 가 지원하는 PostgreSQL 은 14 · 15 · 16 · 17 이다.[1]
CM 서버와 DB 사이 지연은 10 ms 미만이어야 하고, 임베디드 PostgreSQL 은 운영에서 지원되지 않는다.[2]
설치는 PostgreSQL 설치 를 따른다. 여기에는 Cloudera 가 요구하는 설정만 둔다.
dnf install -y glibc-langpack-en glibc-langpack-ko
echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
postgresql.conf 에 넣는다. max_connections 는 "DB 하나당 100 + 50" 으로 잡는다. PostgreSQL 12 이상은 jit = off 를 권장한다.[2:1]
listen_addresses = '*'
port = 5432
max_connections = 300
password_encryption = scram-sha-256
jit = off
shared_buffers = 256MB
dynamic_shared_memory_type = posix
wal_buffers = 8MB
max_wal_size = 1GB
min_wal_size = 80MB
checkpoint_completion_target = 0.9
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'
pg_hba.conf 에 넣는다. 기존 ident 줄보다 앞에 둬야 한다. Hue · Hive 등이 다른 노드에서 붙으므로 클러스터 대역을 연다.
host all all 127.0.0.1/32 scram-sha-256
host all all 10.0.0.0/24 scram-sha-256 # 클러스터 노드 대역으로 바꾼다
systemctl enable postgresql --now
Cloudera 가 요구하는 DB 와 계정.[2:2] Ranger KMS · Schema Registry · SMM 은 쓰는 서비스가 있을 때만.
CREATE ROLE scm LOGIN PASSWORD '${MASKED}';
CREATE ROLE rman LOGIN PASSWORD '${MASKED}';
CREATE ROLE hue LOGIN PASSWORD '${MASKED}';
CREATE ROLE hive LOGIN PASSWORD '${MASKED}';
CREATE ROLE oozie LOGIN PASSWORD '${MASKED}';
CREATE ROLE rangeradmin LOGIN PASSWORD '${MASKED}';
CREATE ROLE rangerkms LOGIN PASSWORD '${MASKED}';
CREATE ROLE schemaregistry LOGIN PASSWORD '${MASKED}';
CREATE ROLE smm LOGIN PASSWORD '${MASKED}';
CREATE DATABASE scm OWNER scm ENCODING 'UTF8';
CREATE DATABASE rman OWNER rman 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 ranger OWNER rangeradmin ENCODING 'UTF8';
CREATE DATABASE rangerkms OWNER rangerkms ENCODING 'UTF8';
CREATE DATABASE schemaregistry OWNER schemaregistry ENCODING 'UTF8';
CREATE DATABASE smm OWNER smm ENCODING 'UTF8';
-- Hive · Oozie 는 반드시
ALTER DATABASE hive SET standard_conforming_strings = off;
ALTER DATABASE oozie SET standard_conforming_strings = off;
-- 선택: 관리 편의용 superuser
CREATE ROLE root WITH LOGIN SUPERUSER PASSWORD '${MASKED}';
CREATE DATABASE root OWNER root ENCODING 'UTF8';
Cloudera Data Services on premises — Software Support Matrix (Postgres 14, 15, 16, 17). 2026-09-17 확인. https://docs.cloudera.com/cdp-private-cloud-data-services/latest/installation-ecs/topics/cdppvc-installation-software-support-matrix-base-and-ds-ecs.html ↩︎
Configuring and Starting the PostgreSQL Server (7.3.1) · Database Requirements. https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/cdp-private-cloud-base-installation/topics/cdpdc-configuring-starting-postgresql-server.html ↩︎ ↩︎ ↩︎