postgreSQL13.8 수동설치

https://www.postgresql.org/ftp/source/v13.8/

PostgreSQL: File Browser

파일 다운로드

# yum install -y tar bzip2 gcc readline-devel zlib-devel make
# tar -xvf 파일명
# sh configure
# make
# make install

# useradd postgres
# mkdir /usr/local/pgsql/data
# chown postgres /usr/local/pgsql/data

# su - postgres

vi .bash_profile

PATH=$PATH:/usr/local/pgsql/bin
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data

export PATH PGLIB PGDATA

 

시작

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

 

/usr/lib/systemd/system 에서 서비스 등록

[Unit]
Description=PostgreSQL server
After=network.target

[Service]
Type=forking

User=postgres
Group=root
# 사용자 /group 은 자신에 맞게 설정

Environment=PGSTARTTIMEOUT=270
Environment=PGDATA=/usr/local/pgsql/data
# data 폴더는 자신에 맞게 설정

ExecStart=/usr/local/pgsql/bin/pg_ctl start -D ${PGDATA} -s
ExecStop=/usr/local/pgsql/bin/pg_ctl stop -D ${PGDATA} -s
ExecReload=/usr/local/pgsql/bin/pg_ctl reload -D ${PGDATA} -s

TimeoutSec=300

[Install]
WantedBy=multi-user.target

위 내용 넣고

# systemctl daemon-reload
# systemctl enable --now postgres

방화벽 포트도 추가

/root/postgresql-13.8/contrib/btree_gist에서

make

make install

/root/postgresql-13.8/contrib/pg_trgm에서

make

make install

 

CREATE EXTENSION IF NOT EXISTS btree_gist;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
select * from pg_available_extensions;

수동설치는 다운받은거에있음

yum설치는 postgres contrib설치?해야 동작