티스토리 뷰
postgresql 14 버전을 선 설치 후
geometry 타입을 사용하기 위해 postgis 설치가 필요했다.
postgis.x86_64 를 설치해서
yum list | grep postgis 명령어를 통해 확인했으나, 설치에 문제는 없어 보였다.
psql -U postgres -d postgres 로 db 수행 후에
create extension postgis; 를 수행하니
ERROR: could not open extension control file "/postgresql/share/extension/postgis.control": No such file or directory
에러가 지속 발생했다.
다른 버전의 postgis 를 설치해서 수정해보려 하였으나, 설치가 제대로 되지 않았고
여러번의 시도 끝내 해결 방법을 찾았다.
yum 을 통해 postgis 패키지 확인 시 'epel' 저장소에서 제공되는 Postgis 버전인 2.0.7-2.el7 이 설치되어 있었다.
yum list available | grep postgis
postgis.x86_64 2.0.7-2.el7 epel
postgis-docs.x86_64 2.0.7-2.el7 epel
postgis-utils.x86_64 2.0.7-2.el7 epel
현재 설치된 postgresql 은 14버전이기 때문에 14버전에 맞는 postgis 패키지 설치가 필요했다.
pgdg 저장소 문제로 보여 저장소 재설정을 수행했다.
* root 계정에서 수행
* 타 user로 수행 시 sudo 권한을 준 곳에서 yum 앞에 sudo 명령어를 붙여 수행
1. 기존 pgdg 삭제
yum remove pgdg-redhat-repo
2. postgresql 14 용 pgdg 저장소 재설치
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
3. 저장소 cache 비우기
* yum 명령어를 이용해서 어플리케이션을 설치하다 보면 repository가 꼬여서 yum install 이 제대로 실행이 안되거나 임시로 저장소를 추가했는데 필요 없어져서 제거할 필요가 있다거나 하는 경우가 생기는 일을 방지하기 위함
yum clean all
yum makecache
4. 최신 버전의 postgis 패키지 설치
yum install postgis31_14.x86_64
yum install postgis31_14.x86_64
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* epel: d2lzkl7pfhq30w.cloudfront.net
Resolving Dependencies
--> Running transaction check
---> Package postgis31_14.x86_64 0:3.1.9-1.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: geos310 >= 3.10.3 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: gdal34-libs >= 3.4.3 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libgeotiff16 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.30()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Running transaction check
---> Package SFCGAL.x86_64 0:1.3.1-2.rhel7 will be installed
--> Processing Dependency: CGAL for package: SFCGAL-1.3.1-2.rhel7.x86_64
---> Package SFCGAL-libs.x86_64 0:1.3.1-2.rhel7 will be installed
--> Processing Dependency: libboost_serialization-mt.so.1.53.0()(64bit) for package: SFCGAL-libs-1.3.1-2.rhel7.x86_64
---> Package gdal34-libs.x86_64 0:3.4.3-4.rhel7 will be installed
--> Processing Dependency: ogdi41 for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libspatialite43-devel for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libgeotiff16-devel for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: armadillo for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libzstd.so.1()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libspatialite.so.7()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libogdi.so.4()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
---> Package geos310.x86_64 0:3.10.3-1.rhel7 will be installed
---> Package libgeotiff16.x86_64 0:1.6.0-6.rhel7 will be installed
---> Package proj72.x86_64 0:7.2.1-1.rhel7 will be installed
--> Processing Dependency: sqlite33 for package: proj72-7.2.1-1.rhel7.x86_64
--> Running transaction check
---> Package CGAL.x86_64 0:4.7-1.rhel7.1 will be installed
--> Processing Dependency: libGLU.so.1()(64bit) for package: CGAL-4.7-1.rhel7.1.x86_64
---> Package armadillo.x86_64 0:10.8.2-1.el7 will be installed
--> Processing Dependency: libarpack.so.2()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
--> Processing Dependency: liblapack.so.3()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
--> Processing Dependency: libsuperlu.so.5.1()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
---> Package boost-serialization.x86_64 0:1.53.0-27.el7 will be installed
---> Package libgeotiff16-devel.x86_64 0:1.6.0-6.rhel7 will be installed
--> Processing Dependency: libtiff-devel for package: libgeotiff16-devel-1.6.0-6.rhel7.x86_64
---> Package libspatialite43.x86_64 0:4.3.0a-15.rhel7 will be installed
--> Processing Dependency: geos39 >= 3.9.0 for package: libspatialite43-4.3.0a-15.rhel7.x86_64
---> Package libspatialite43-devel.x86_64 0:4.3.0a-15.rhel7 will be installed
---> Package libzstd.x86_64 0:1.5.5-1.el7 will be installed
---> Package ogdi41.x86_64 0:4.1.0-2.rhel7 will be installed
---> Package sqlite33.x86_64 0:3.30.1-6.rhel7 will be installed
--> Processing Dependency: sqlite33-libs = 3.30.1-6.rhel7 for package: sqlite33-3.30.1-6.rhel7.x86_64
--> Running transaction check
---> Package SuperLU.x86_64 0:5.2.0-5.el7 will be installed
--> Processing Dependency: libsatlas.so.3()(64bit) for package: SuperLU-5.2.0-5.el7.x86_64
---> Package arpack.x86_64 0:3.1.3-2.el7 will be installed
---> Package geos39.x86_64 0:3.9.2-1.rhel7 will be installed
---> Package lapack.x86_64 0:3.4.2-8.el7 will be installed
--> Processing Dependency: libblas.so.3()(64bit) for package: lapack-3.4.2-8.el7.x86_64
---> Package libtiff-devel.x86_64 0:4.0.3-27.el7_3 will be installed
--> Processing Dependency: libtiff(x86-64) = 4.0.3-27.el7_3 for package: libtiff-devel-4.0.3-27.el7_3.x86_64
---> Package mesa-libGLU.x86_64 0:9.0.0-4.el7 will be installed
---> Package sqlite33-libs.x86_64 0:3.30.1-6.rhel7 will be installed
--> Running transaction check
---> Package atlas.x86_64 0:3.10.1-12.el7 will be installed
---> Package blas.x86_64 0:3.4.2-8.el7 will be installed
---> Package libtiff-devel.x86_64 0:4.0.3-27.el7_3 will be installed
--> Processing Dependency: libtiff(x86-64) = 4.0.3-27.el7_3 for package: libtiff-devel-4.0.3-27.el7_3.x86_64
--> Finished Dependency Resolution
Error: Package: libtiff-devel-4.0.3-27.el7_3.x86_64 (base)
Requires: libtiff(x86-64) = 4.0.3-27.el7_3
Installed: libtiff-4.0.3-35.el7.x86_64 (@anaconda)
libtiff(x86-64) = 4.0.3-35.el7
Available: libtiff-4.0.3-27.el7_3.x86_64 (base)
libtiff(x86-64) = 4.0.3-27.el7_3
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
** libtiff-devel 패키지가 특정 버전의 libtiff 패키지를 필요로 하는데, 현재 설치된 libtiff 패키지의 버전이 다르기 때문에 발생한 오류를 잡기 위해 패키지 다운그래이드 수행
yum downgrade libtiff-4.0.3-27.el7_3.x86_64
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* epel: d2lzkl7pfhq30w.cloudfront.net
Resolving Dependencies
--> Running transaction check
---> Package libtiff.x86_64 0:4.0.3-27.el7_3 will be a downgrade
---> Package libtiff.x86_64 0:4.0.3-35.el7 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================================================================================================================
Package Arch Version Repository Size
===============================================================================================================================================================================================
Downgrading:
libtiff x86_64 4.0.3-27.el7_3 base 170 k
Transaction Summary
===============================================================================================================================================================================================
Downgrade 1 Package
Total download size: 170 k
Is this ok [y/d/N]: y
Downloading packages:
libtiff-4.0.3-27.el7_3.x86_64.rpm | 170 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libtiff-4.0.3-27.el7_3.x86_64 1/2
Cleanup : libtiff-4.0.3-35.el7.x86_64 2/2
Verifying : libtiff-4.0.3-27.el7_3.x86_64 1/2
Verifying : libtiff-4.0.3-35.el7.x86_64 2/2
Removed:
libtiff.x86_64 0:4.0.3-35.el7
Installed:
libtiff.x86_64 0:4.0.3-27.el7_3
Complete!
** 패키지 업데이트를 수행하여 libtiff 와 libtiff-devel 패키지를 업데이트 함으로서 호환성 문제 해결
yum update libtiff libtiff-devel
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* epel: d2lzkl7pfhq30w.cloudfront.net
Package(s) libtiff-devel available, but not installed.
No packages marked for update
[root@localhost share]# sudo yum install postgis31_14.x86_64 --skip-broken
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* epel: d2lzkl7pfhq30w.cloudfront.net
Resolving Dependencies
--> Running transaction check
---> Package postgis31_14.x86_64 0:3.1.9-1.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: geos310 >= 3.10.3 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: gdal34-libs >= 3.4.3 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libgeotiff16 for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.30()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: postgis31_14-3.1.9-1.rhel7.x86_64
--> Running transaction check
---> Package SFCGAL.x86_64 0:1.3.1-2.rhel7 will be installed
--> Processing Dependency: CGAL for package: SFCGAL-1.3.1-2.rhel7.x86_64
---> Package SFCGAL-libs.x86_64 0:1.3.1-2.rhel7 will be installed
--> Processing Dependency: libboost_serialization-mt.so.1.53.0()(64bit) for package: SFCGAL-libs-1.3.1-2.rhel7.x86_64
---> Package gdal34-libs.x86_64 0:3.4.3-4.rhel7 will be installed
--> Processing Dependency: ogdi41 for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libspatialite43-devel for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libgeotiff16-devel for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: armadillo for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libzstd.so.1()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libspatialite.so.7()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
--> Processing Dependency: libogdi.so.4()(64bit) for package: gdal34-libs-3.4.3-4.rhel7.x86_64
---> Package geos310.x86_64 0:3.10.3-1.rhel7 will be installed
---> Package libgeotiff16.x86_64 0:1.6.0-6.rhel7 will be installed
---> Package proj72.x86_64 0:7.2.1-1.rhel7 will be installed
--> Processing Dependency: sqlite33 for package: proj72-7.2.1-1.rhel7.x86_64
--> Running transaction check
---> Package CGAL.x86_64 0:4.7-1.rhel7.1 will be installed
--> Processing Dependency: libGLU.so.1()(64bit) for package: CGAL-4.7-1.rhel7.1.x86_64
---> Package armadillo.x86_64 0:10.8.2-1.el7 will be installed
--> Processing Dependency: libarpack.so.2()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
--> Processing Dependency: liblapack.so.3()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
--> Processing Dependency: libsuperlu.so.5.1()(64bit) for package: armadillo-10.8.2-1.el7.x86_64
---> Package boost-serialization.x86_64 0:1.53.0-27.el7 will be installed
---> Package libgeotiff16-devel.x86_64 0:1.6.0-6.rhel7 will be installed
--> Processing Dependency: libtiff-devel for package: libgeotiff16-devel-1.6.0-6.rhel7.x86_64
---> Package libspatialite43.x86_64 0:4.3.0a-15.rhel7 will be installed
--> Processing Dependency: geos39 >= 3.9.0 for package: libspatialite43-4.3.0a-15.rhel7.x86_64
---> Package libspatialite43-devel.x86_64 0:4.3.0a-15.rhel7 will be installed
---> Package libzstd.x86_64 0:1.5.5-1.el7 will be installed
---> Package ogdi41.x86_64 0:4.1.0-2.rhel7 will be installed
---> Package sqlite33.x86_64 0:3.30.1-6.rhel7 will be installed
--> Processing Dependency: sqlite33-libs = 3.30.1-6.rhel7 for package: sqlite33-3.30.1-6.rhel7.x86_64
--> Running transaction check
---> Package SuperLU.x86_64 0:5.2.0-5.el7 will be installed
--> Processing Dependency: libsatlas.so.3()(64bit) for package: SuperLU-5.2.0-5.el7.x86_64
---> Package arpack.x86_64 0:3.1.3-2.el7 will be installed
---> Package geos39.x86_64 0:3.9.2-1.rhel7 will be installed
---> Package lapack.x86_64 0:3.4.2-8.el7 will be installed
--> Processing Dependency: libblas.so.3()(64bit) for package: lapack-3.4.2-8.el7.x86_64
---> Package libtiff-devel.x86_64 0:4.0.3-27.el7_3 will be installed
---> Package mesa-libGLU.x86_64 0:9.0.0-4.el7 will be installed
---> Package sqlite33-libs.x86_64 0:3.30.1-6.rhel7 will be installed
--> Running transaction check
---> Package atlas.x86_64 0:3.10.1-12.el7 will be installed
---> Package blas.x86_64 0:3.4.2-8.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================================================================================================================
Package Arch Version Repository Size
===============================================================================================================================================================================================
Installing:
postgis31_14 x86_64 3.1.9-1.rhel7 pgdg14 3.7 M
Installing for dependencies:
CGAL x86_64 4.7-1.rhel7.1 pgdg-common 254 k
SFCGAL x86_64 1.3.1-2.rhel7 pgdg-common 15 k
SFCGAL-libs x86_64 1.3.1-2.rhel7 pgdg-common 1.7 M
SuperLU x86_64 5.2.0-5.el7 epel 180 k
armadillo x86_64 10.8.2-1.el7 epel 36 k
arpack x86_64 3.1.3-2.el7 epel 101 k
atlas x86_64 3.10.1-12.el7 base 4.5 M
blas x86_64 3.4.2-8.el7 base 399 k
boost-serialization x86_64 1.53.0-27.el7 base 169 k
gdal34-libs x86_64 3.4.3-4.rhel7 pgdg-common 8.1 M
geos310 x86_64 3.10.3-1.rhel7 pgdg-common 864 k
geos39 x86_64 3.9.2-1.rhel7 pgdg-common 647 k
lapack x86_64 3.4.2-8.el7 base 5.4 M
libgeotiff16 x86_64 1.6.0-6.rhel7 pgdg-common 95 k
libgeotiff16-devel x86_64 1.6.0-6.rhel7 pgdg-common 30 k
libspatialite43 x86_64 4.3.0a-15.rhel7 pgdg-common 2.4 M
libspatialite43-devel x86_64 4.3.0a-15.rhel7 pgdg-common 74 k
libtiff-devel x86_64 4.0.3-27.el7_3 base 473 k
libzstd x86_64 1.5.5-1.el7 epel 292 k
mesa-libGLU x86_64 9.0.0-4.el7 base 196 k
ogdi41 x86_64 4.1.0-2.rhel7 pgdg-common 219 k
proj72 x86_64 7.2.1-1.rhel7 pgdg-common 2.5 M
sqlite33 x86_64 3.30.1-6.rhel7 pgdg-common 625 k
sqlite33-libs x86_64 3.30.1-6.rhel7 pgdg-common 551 k
Transaction Summary
===============================================================================================================================================================================================
Install 1 Package (+24 Dependent packages)
Total download size: 33 M
Installed size: 140 M
Is this ok [y/d/N]: y
Downloading packages:
경고: /var/cache/yum/x86_64/7/pgdg-common/packages/CGAL-4.7-1.rhel7.1.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 73e3b907: NOKEY ] 0.0 B/s | 96 kB --:--:-- ETA
Public key for CGAL-4.7-1.rhel7.1.x86_64.rpm is not installed
(1/25): CGAL-4.7-1.rhel7.1.x86_64.rpm | 254 kB 00:00:01
(2/25): SFCGAL-1.3.1-2.rhel7.x86_64.rpm | 15 kB 00:00:01
(3/25): SuperLU-5.2.0-5.el7.x86_64.rpm | 180 kB 00:00:00
(4/25): armadillo-10.8.2-1.el7.x86_64.rpm | 36 kB 00:00:00
(5/25): arpack-3.1.3-2.el7.x86_64.rpm | 101 kB 00:00:00
(6/25): SFCGAL-libs-1.3.1-2.rhel7.x86_64.rpm | 1.7 MB 00:00:00
(7/25): atlas-3.10.1-12.el7.x86_64.rpm | 4.5 MB 00:00:00
(8/25): boost-serialization-1.53.0-27.el7.x86_64.rpm | 169 kB 00:00:00
(9/25): blas-3.4.2-8.el7.x86_64.rpm | 399 kB 00:00:00
(10/25): geos310-3.10.3-1.rhel7.x86_64.rpm | 864 kB 00:00:02
(11/25): lapack-3.4.2-8.el7.x86_64.rpm | 5.4 MB 00:00:00
(12/25): gdal34-libs-3.4.3-4.rhel7.x86_64.rpm | 8.1 MB 00:00:03
(13/25): geos39-3.9.2-1.rhel7.x86_64.rpm | 647 kB 00:00:00
(14/25): libgeotiff16-1.6.0-6.rhel7.x86_64.rpm | 95 kB 00:00:00
(15/25): libgeotiff16-devel-1.6.0-6.rhel7.x86_64.rpm | 30 kB 00:00:00
(16/25): libspatialite43-devel-4.3.0a-15.rhel7.x86_64.rpm | 74 kB 00:00:00
(17/25): libzstd-1.5.5-1.el7.x86_64.rpm | 292 kB 00:00:00
(18/25): mesa-libGLU-9.0.0-4.el7.x86_64.rpm | 196 kB 00:00:00
(19/25): libtiff-devel-4.0.3-27.el7_3.x86_64.rpm | 473 kB 00:00:00
(20/25): ogdi41-4.1.0-2.rhel7.x86_64.rpm | 219 kB 00:00:00
(21/25): libspatialite43-4.3.0a-15.rhel7.x86_64.rpm | 2.4 MB 00:00:01
(22/25): sqlite33-3.30.1-6.rhel7.x86_64.rpm | 625 kB 00:00:00
(23/25): sqlite33-libs-3.30.1-6.rhel7.x86_64.rpm | 551 kB 00:00:00
Public key for postgis31_14-3.1.9-1.rhel7.x86_64.rpm is not installed
(24/25): postgis31_14-3.1.9-1.rhel7.x86_64.rpm | 3.7 MB 00:00:02
(25/25): proj72-7.2.1-1.rhel7.x86_64.rpm | 2.5 MB 00:00:02
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 3.4 MB/s | 33 MB 00:00:09
Retrieving key from file:///etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL7
Importing GPG key 0x73E3B907:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: f245 f0bf 96ac 1827 44ca ff2e 64fa ce11 73e3 b907
Package : pgdg-redhat-repo-42.0-38PGDG.noarch (@/pgdg-redhat-repo-latest.noarch)
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL7
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : sqlite33-libs-3.30.1-6.rhel7.x86_64 1/25
Installing : geos39-3.9.2-1.rhel7.x86_64 2/25
Installing : geos310-3.10.3-1.rhel7.x86_64 3/25
Installing : atlas-3.10.1-12.el7.x86_64 4/25
Installing : arpack-3.1.3-2.el7.x86_64 5/25
Installing : SuperLU-5.2.0-5.el7.x86_64 6/25
Installing : sqlite33-3.30.1-6.rhel7.x86_64 7/25
Installing : proj72-7.2.1-1.rhel7.x86_64 8/25
Installing : libgeotiff16-1.6.0-6.rhel7.x86_64 9/25
Installing : libspatialite43-4.3.0a-15.rhel7.x86_64 10/25
Installing : libspatialite43-devel-4.3.0a-15.rhel7.x86_64 11/25
Installing : mesa-libGLU-9.0.0-4.el7.x86_64 12/25
Installing : CGAL-4.7-1.rhel7.1.x86_64 13/25
Installing : ogdi41-4.1.0-2.rhel7.x86_64 14/25
Installing : libzstd-1.5.5-1.el7.x86_64 15/25
Installing : blas-3.4.2-8.el7.x86_64 16/25
Installing : lapack-3.4.2-8.el7.x86_64 17/25
Installing : armadillo-10.8.2-1.el7.x86_64 18/25
Installing : libtiff-devel-4.0.3-27.el7_3.x86_64 19/25
Installing : libgeotiff16-devel-1.6.0-6.rhel7.x86_64 20/25
Installing : boost-serialization-1.53.0-27.el7.x86_64 21/25
Installing : SFCGAL-libs-1.3.1-2.rhel7.x86_64 22/25
Installing : SFCGAL-1.3.1-2.rhel7.x86_64 23/25
Installing : gdal34-libs-3.4.3-4.rhel7.x86_64 24/25
Installing : postgis31_14-3.1.9-1.rhel7.x86_64 25/25
Verifying : arpack-3.1.3-2.el7.x86_64 1/25
Verifying : SFCGAL-libs-1.3.1-2.rhel7.x86_64 2/25
Verifying : boost-serialization-1.53.0-27.el7.x86_64 3/25
Verifying : proj72-7.2.1-1.rhel7.x86_64 4/25
Verifying : atlas-3.10.1-12.el7.x86_64 5/25
Verifying : libtiff-devel-4.0.3-27.el7_3.x86_64 6/25
Verifying : armadillo-10.8.2-1.el7.x86_64 7/25
Verifying : blas-3.4.2-8.el7.x86_64 8/25
Verifying : libzstd-1.5.5-1.el7.x86_64 9/25
Verifying : lapack-3.4.2-8.el7.x86_64 10/25
Verifying : libgeotiff16-1.6.0-6.rhel7.x86_64 11/25
Verifying : ogdi41-4.1.0-2.rhel7.x86_64 12/25
Verifying : CGAL-4.7-1.rhel7.1.x86_64 13/25
Verifying : SuperLU-5.2.0-5.el7.x86_64 14/25
Verifying : libspatialite43-4.3.0a-15.rhel7.x86_64 15/25
Verifying : SFCGAL-1.3.1-2.rhel7.x86_64 16/25
Verifying : libspatialite43-devel-4.3.0a-15.rhel7.x86_64 17/25
Verifying : gdal34-libs-3.4.3-4.rhel7.x86_64 18/25
Verifying : geos39-3.9.2-1.rhel7.x86_64 19/25
Verifying : mesa-libGLU-9.0.0-4.el7.x86_64 20/25
Verifying : postgis31_14-3.1.9-1.rhel7.x86_64 21/25
Verifying : libgeotiff16-devel-1.6.0-6.rhel7.x86_64 22/25
Verifying : geos310-3.10.3-1.rhel7.x86_64 23/25
Verifying : sqlite33-3.30.1-6.rhel7.x86_64 24/25
Verifying : sqlite33-libs-3.30.1-6.rhel7.x86_64 25/25
Installed:
postgis31_14.x86_64 0:3.1.9-1.rhel7
Dependency Installed:
CGAL.x86_64 0:4.7-1.rhel7.1 SFCGAL.x86_64 0:1.3.1-2.rhel7 SFCGAL-libs.x86_64 0:1.3.1-2.rhel7 SuperLU.x86_64 0:5.2.0-5.el7
armadillo.x86_64 0:10.8.2-1.el7 arpack.x86_64 0:3.1.3-2.el7 atlas.x86_64 0:3.10.1-12.el7 blas.x86_64 0:3.4.2-8.el7
boost-serialization.x86_64 0:1.53.0-27.el7 gdal34-libs.x86_64 0:3.4.3-4.rhel7 geos310.x86_64 0:3.10.3-1.rhel7 geos39.x86_64 0:3.9.2-1.rhel7
lapack.x86_64 0:3.4.2-8.el7 libgeotiff16.x86_64 0:1.6.0-6.rhel7 libgeotiff16-devel.x86_64 0:1.6.0-6.rhel7 libspatialite43.x86_64 0:4.3.0a-15.rhel7
libspatialite43-devel.x86_64 0:4.3.0a-15.rhel7 libtiff-devel.x86_64 0:4.0.3-27.el7_3 libzstd.x86_64 0:1.5.5-1.el7 mesa-libGLU.x86_64 0:9.0.0-4.el7
ogdi41.x86_64 0:4.1.0-2.rhel7 proj72.x86_64 0:7.2.1-1.rhel7 sqlite33.x86_64 0:3.30.1-6.rhel7 sqlite33-libs.x86_64 0:3.30.1-6.rhel7
Complete!
** package cache 클리어
yum clean all
yum makecache
5. postgis 설치 확인
yum list available | grep pgdg14
여기까지 수행 시에 pgdg14 패키지가 정상 설치되었을 것이다.
그럼 리눅스 재실행 후에 psql 접속을 시도해본다. 정상적으로 postgis extension 이 설치됨을 확인할 수 있다.
$ psql -d postgres -U postgres
psql (14.2)
도움말을 보려면 "help"를 입력하십시오.
postgres=# create extension postgis;
CREATE EXTENSION
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
링크
TAG
- 파이썬 오름차순 정렬
- 파이썬 거꾸로
- 오른쪽정렬
- 백준2441
- 코테
- 파이썬 덧셈
- 백준1942
- 백준
- 백준2920
- 코테준비
- 백준 2742
- 리눅스계정
- 백준 별찍기
- 별찍기 -4
- 별찍기 -3
- range특징
- 백준2440
- 별찍기 -2
- 백준2007년
- 리눅스계정경로
- 파이썬 find
- 파이썬 오른쪽정렬
- reversed함수
- 백준코테
- 파이썬 내림차순 정렬
- 백준11721
- 코딩테스트
- 별찍기 -1
- 파이썬 반복문
- 파이썬
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 |
글 보관함