[CentOS7] PostgreSQL 13 설치 및 실행 방법

PostgreSQL repository 설치 및 활성화

$ sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
$ sodu yum -y update

 

PostgreSQL repository 활성화 확인

$ sudo yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.kakao.com
 * epel: ftp.jaist.ac.jp
 * extras: mirror.kakao.com
 * updates: mirror.navercorp.com
repo id                  repo name                                             status
base/7/x86_64            CentOS-7 - Base                                       10,072
epel/x86_64              Extra Packages for Enterprise Linux 7 - x86_64        13,642
extras/7/x86_64          CentOS-7 - Extras                                        498
pgdg-common/7/x86_64     PostgreSQL common RPMs for RHEL/CentOS 7 - x86_64        321
pgdg10/7/x86_64          PostgreSQL 10 for RHEL/CentOS 7 - x86_64                 950
pgdg11/7/x86_64          PostgreSQL 11 for RHEL/CentOS 7 - x86_64               1,043
pgdg12/7/x86_64          PostgreSQL 12 for RHEL/CentOS 7 - x86_64                 614
pgdg13/7/x86_64          PostgreSQL 13 for RHEL/CentOS 7 - x86_64                 342
pgdg96/7/x86_64          PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64                918
updates/7/x86_64         CentOS-7 - Updates                                     2,594
repolist: 30,994

 

PostgreSQL 설치

$ sudo yum -y install postgresql13 postgresql13-server

 

PostgreSQL 초기화

$ sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
Initializing database ... OK

 

PostgreSQL 서비스 시작

$ sudo systemctl start postgresql-13

 

PostgreSQL 서비스 상태 확인

$ sudo systemctl status postgresql-13
● postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; disabled; vendor preset: disabled)
   Active: active (running) since 화 2021-08-31 13:41:39 KST; 15s ago
     Docs: https://www.postgresql.org/docs/13/static/
  Process: 16247 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 16254 (postmaster)
    Tasks: 8
   Memory: 14.0M
   CGroup: /system.slice/postgresql-13.service
           ├─16254 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
           ├─16256 postgres: logger 
           ├─16258 postgres: checkpointer 
           ├─16259 postgres: background writer 
           ├─16260 postgres: walwriter 
           ├─16261 postgres: autovacuum launcher 
           ├─16262 postgres: stats collector 
           └─16263 postgres: logical replication launcher 

 8월 31 13:41:39 localhost.localdomain systemd[1]: Starting PostgreSQL 13 database server...
 8월 31 13:41:39 localhost.localdomain postmaster[16254]: 2021-08-31 13:41:39.216 KST [16254] 로그:  서버 로그를 로그 수집 프로세스로 보냅니다.
 8월 31 13:41:39 localhost.localdomain postmaster[16254]: 2021-08-31 13:41:39.216 KST [16254] 힌트:  이제부터 서버 로그는 "log" 디렉터리에 보관됩니다.
 8월 31 13:41:39 localhost.localdomain systemd[1]: Started PostgreSQL 13 database server.

 

재부팅 시 PostgreSQL 서비스가 시작되록 서비스 활성화

$ sudo systemctl enable postgresql-13
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-13.service to /usr/lib/systemd/system/postgresql-13.service.

 

PostgreSQL Admin Password 설정

$ sudo su - postgres
$ psql -c "alter user postgres with password '원하는비밀번호'"
ALTER ROLE

 

외부 접속을 허용이 필요할 경우 postgresql.conf, pg_hba.conf 파일을 수정해야 한다.

$ sudo sudo vi /var/lib/pgsql/13/data/postgresql.conf
listen_addresses = '*'

$ sudo sudo vi /var/lib/pgsql/13/data/pg_hba.conf
  
# 모든 IP 허용
host  all all 0.0.0.0/0  md5

# 특정 IP 대역 허용 (192.168.0.1 ~ 192.168.0.255)
host  all  all 192.168.0.0/24

# 특정 IP 만 허용
host  all  all 192.168.0.100/32

 

PostgreSQL 설정 변경 시 재시작을 해줘야 한다.

$ systemctl restart postgresql-13

 

추가) PostgreSQL을 재시작 하지 않고 설정 파일 변경 내용을 적용하는 방법

$ sudo su - postgres
$ /usr/pgsql-13/bin/pg_ctl reload -D /var/lib/pgsql/13/data/
서버가 시스템 시그널을 받았음