1. Postgres OS 계정

groupadd --gid 6000 postgres
adduser --create-home --shell /bin/bash --gid 6000 --uid 6000 postgres
passwd postgres

2. Postgres 다운

https://www.postgresql.org/ftp/source/v15.3/postgresql-15.3.tar.gz

3. Postgres 설치

cp ~/postgresql-15.3.tar.gz /opt

tar -zxf /opt/postgresql-15.3.tar.gz
cd postgresql-15.3

sudo ./configure --without-readline
sudo make && sudo make install

==========================================================
-- prefix 옵션은 엔진 설치 경로이며, 기본값은 '/usr/local/pgsql'
-- configure 과정에서 에러 발생 시 아래 패키지 설치 후 재 실행

configure: error: no acceptable C compiler found in $PATH
=> $ sudo yum install gcc

configure: error: readline library not found
=> $ sudo yum install readline-devel

configure: error: zlib library not found
=> $ sudo yum install zlib-devel
==========================================================

4. Postgres 초기화

cd /usr/local/pgsql/bin
./initdb -D /pgData

5. Postgres 설정

cd /pgData
vi pg_hba.conf
(맨 밑에)
host    all             all             172.16.1.1/32           md5 

vi postgresql.conf

listen_addresses = "172.16.1.25"
port = 5432

6. Postgres 실행

./pg_ctl -D /pgData start
waiting for server to start....
server started

# 정지
./pg_ctl -D /pgData stop
 waiting for server to shut down....
 server stopped

# 재실행
./pg_ctl -D /pgData restart
 waiting for server to shut down....
 server stopped
 waiting for server to start....
 server started

7. Postgres 전역 변수 설정

vi ~/.bash_profile
export LD_LIBRARY_PATH=:$HOME/pgsql/lib
export PATH=$PATH:$HOME/pgsql/bin
export PGDATA=$HOME/pgsql/data

source ~/.bash_profile