Rocky Linux 8.6에서 PostgreSQL 14, PostGIS 3.2.1 설치

# 전체 패키지 최신 버전으로 업데이트(옵션)

dnf upgrade --refresh -y

# Postgresql 14 설치

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql14-server
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
(참조 : https://www.postgresql.org/download/linux/redhat)

# postgresql DBMS 접속

sudo -i -u postgres
psql

# PostGIS 3.2.1 설치

sudo dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
sudo dnf install dnf-plugins-core
sudo dnf config-manager --set-enabled powertools
sudo dnf -y install postgis32_14