PostgreSQL 설치

1. 엔진 설치

1.1. 패키지 설치

[root@www:/root]yum -y install gcc gcc-c++ make autoconf wget readline readline-devel

zlib zlib-devel openssl openssl-devel gettext gettext-devel python python-devel

1.2. 설치 파일 업로드 및 압축 해제

아래 링크를 통해 원하는 버전을 다운로드 합니다.

https://ftp.postgresql.org/pub/source/

–

[root@www:/root]cd /usr/local/src

[root@www:/usr/local/src]ls -al

total 196140

drwxr-xr-x. 5 root root 4096 Nov 4 09:49 .
drwxr-xr-x. 15 root root 4096 Dec 7 2020 ..
-rw-r–r– 1 root root 26791694 Nov 4 09:48 postgresql-12.3.tar.gz
[root@www:/usr/local/src]tar xvzf postgresql-12.3.tar.gz

1.3. 사용자 생성

[root@www:/usr/local/src] groupadd dba

[root@www:/usr/local/src] useradd -d /home/postgres -g dba postgres

1.4. Profile 변경

[root@www:/usr/local/src]su – postgres

[postgres@www:/home/postgres]$ vi .bash_profile

stty erase ^H

### User ENV ###
export PS1=”[`whoami`@`hostname`:$PWD]$ “
​
POSTGRES_HOME=/home/postgres/pgsql
PGLIB=$POSTGRES_HOME/lib
PGDATA=$POSTGRES_HOME/data
MANPATH=$MANPATH:$POSTGRES_HOME/man
​
PATH=$POSTGRES_HOME/bin:$PATH
​
export PATH
export POSTGRES_HOME
export PGLIB
export PGDATA
export MANPATH
​
LD_LIBRARY_PATH=/home/postgres/pgsql/lib
export LD_LIBRARY_PATH

1.5. PostgreSQL 설치

[root@www:/usr/local/src]cd postgresql-12.3

[root@www:/usr/local/src/postgresql-12.3]./configure –prefix=/home/postgres/pgsql —

enable-depend –enable-nls=ko –with-python

……

[root@www:/usr/local/src/postgresql-12.3]make && make install

……

make[1]: Leaving directory `/usr/local/src/postgresql-12.3/config’

PostgreSQL installation complete.

1.6. 데이터 디렉토리 생성

[root@www:/home/postgres]mkdir -p /home/postgres/pgsql/data
[root@www:/home/postgres]chown -R postgres:dba /home/postgres/pgsql

1.7. 클러스터 생성 및 기동

[root@www:/home/postgres]su – postgres

[postgres@www:/home/postgres]$ cd /home/postgres/pgsql/bin
[postgres@www:/home/postgres/pgsql/bin]$ ./initdb -E utf-8 -D
/home/postgres/pgsql/data

…
Success. You can now start the database server using:
    ./pg_ctl -D /home/postgres/pgsql/data -l logfile start
[postgres@www:/home/postgres]$./pg_ctl -D /home/postgres/pgsql/data -l logfile start

1.8. 프로세스 확인

[postgres@www:/home/postgres]$ ps -ef |grep postgres

postgres 2544 1 0 16:40 ? 00:00:00 /home/postgres/pgsql/bin/postgres -D
/home/postgres/pgsql/data

postgres 2548 2544 0 16:40 ? 00:00:00 postgres: checkpointer

postgres 2549 2544 0 16:40 ? 00:00:00 postgres: background writer

postgres 2550 2544 0 16:40 ? 00:00:00 postgres: walwriter

postgres 2551 2544 0 16:40 ? 00:00:00 postgres: autovacuum launcher

postgres 2552 2544 0 16:40 ? 00:00:00 postgres: stats collector

postgres 2553 2544 0 16:40 ? 00:00:00 postgres: logical replication launcher

postgres 2645 31461 0 16:40 pts/8 00:00:00 psql

[postgres@www:/home/postgres]$ pg_ctl status
pg_ctl: server is running (PID: 2544)
/home/postgres/pgsql/bin/postgres “-D” “/home/postgres/pgsql/data”
​

☞ “[Tibero] DBLINK 설정_Tibero to PostgreSQL (4)”에서 계속됩니다.​​