[Ubuntu 22.04 LTS] postgresql postgis pgadmin 설치

아래는 postgresql postgis pgadmin 설치 방법입니다.

 

postgresql postgis 설치 및 버전 확인

ffoooo@mapserver:~$ sudo apt-get install postgresql-14
ffoooo@mapserver:~$ sudo apt-get install postgis postgresql-14-postgis-3
ffoooo@mapserver:~$ sudo -i -u postgres
postgres@mapserver:~$ psql
psql (14.5 (Ubuntu 14.5-0ubuntu0.22.04.1))
Type "help" for help.

postgres=# SELECT version();
                                                             version
---------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit
(1 row)

 

아래 내용을 DB 설정후 쿼리를 실행해 gis를 사용 가능하게 만들어 준다.

postgres=# CREATE EXTENSION postgis;
postgres=# CREATE EXTENSION postgis_topology;
postgres=# CREATE EXTENSION fuzzystrmatch;
postgres=# CREATE EXTENSION postgis_tiger_geocoder;
postgres=# CREATE EXTENSION postgis_sfcgal;
postgres=# CREATE EXTENSION postgis_raster;
postgres=# SELECT PostGIS_Version();
            postgis_version
---------------------------------------
 3.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)

 

버전 확인

postgres=# select version();
postgres=# select postgis_version();
postgres=# select postgis_full_version();
# 종료
postgres=# \q

---

pgadmin4 설치

ffoooo@mapserver:~$ sudo apt-get install pgadmin4

아래 에러가 나올경우 경로를 추가하여 준다.
E: Package 'pgadmin4' has no installation candidate

 

pgadmin4 다운로드 하는 url 추가가 필요하다. (확인필요)

ffoooo@mapserver:~$ sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
ffoooo@mapserver:~$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
# Create the file repository configuration:
ffoooo@mapserver:~$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
# Import the repository signing key:
ffoooo@mapserver:~$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
ffoooo@mapserver:~$ curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
ffoooo@mapserver:~$ sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
ffoooo@mapserver:~$ sudo apt-get update

 

---

 

Ubuntu에서 PostgreSQL 설치 및 데이터 저장 위치 변경하기

https://dev-j.tistory.com/17

 

Ubuntu에서 PostgreSQL 설치 및 데이터 저장 위치 변경하기