centos7下postgresql13 + postgis + timescaledb 时序库完整纯离线安装包
在本文中，我们将深入探讨如何在CentOS 7操作系统中离线安装PostgreSQL 13数据库服务器，并结合PostGIS和TimescaleDB扩展进行时序数据管理。这些组件都是开源的，广泛应用于地理空间数据处理和时间序列数据分析。离线安装方案对于那些网络环境受限或者希望在隔离环境中部署服务的用户来说尤其重要。
让我们了解每个组件的基础知识：
1. **PostgreSQL 13**：PostgreSQL是一个强大的、开源的对象关系型数据库管理系统，具有ACID事务、多版本并发控制（MVCC）以及丰富的SQL支持。PostgreSQL 13引入了许多性能改进、安全增强以及对大表的优化。
2. **PostGIS**：PostGIS是PostgreSQL的一个扩展，它为数据库添加了支持地理和几何对象的功能。这使得PostgreSQL能够处理地理空间数据，例如地图坐标、地理位置等，广泛用于GIS应用。
3. **TimescaleDB**：TimescaleDB是基于PostgreSQL构建的开源时序数据库，专为时间序列数据的高效存储和查询而设计。它提供了SQL接口和熟悉的PostgreSQL语法，同时增强了对时间序列数据特有的插入、查询和分析操作的支持。
为了在CentOS 7上进行离线安装，你需要遵循以下步骤：
1. **下载离线安装包**：确保你已经获取到了包含所有依赖的完整安装包，包括PostgreSQL 13、PostGIS和TimescaleDB。这些通常会是一个.tgz或.rpm格式的文件。
2. **安装基础依赖**：在开始安装前，需要确保系统中已经安装了必要的基础工具，如`epel-release`和`yum-utils`。你可以通过运行以下命令来安装它们：
```
sudo yum install epel-release yum-utils
```
3. **安装PostgreSQL 13**：将PostgreSQL 13的RPM包移动到你的系统中，然后使用`yum localinstall`命令进行安装：
```
sudo mv postgresql13*.rpm /var/cache/yum/x86_64/7/base/packages/
sudo yum localinstall /var/cache/yum/x86_64/7/base/packages/postgresql13*.rpm
```
4. **配置PostgreSQL 13**：设置PostgreSQL的数据目录，创建初始系统用户和数据库，启动并设置开机启动服务：
```
sudo mkdir -p /var/lib/pgsql/13/data
sudo chown -R postgres:postgres /var/lib/pgsql/13/data
sudo su -c "gosu postgres initdb --encoding=UTF8 --data-checksums" -s /bin/bash postgres
sudo systemctl start postgresql-13
sudo systemctl enable postgresql-13
```
5. **安装PostGIS**：将PostGIS的RPM包移到合适的位置，然后安装：
```
sudo mv postgis30_13*.rpm /var/cache/yum/x86_64/7/epel/packages/
sudo yum localinstall /var/cache/yum/x86_64/7/epel/packages/postgis30_13*.rpm
```
接着，创建一个带有PostGIS扩展的新数据库：
```
sudo su -c "psql -c 'CREATE EXTENSION postgis;'" -U postgres
```
6. **安装TimescaleDB**：将TimescaleDB的RPM包安装到系统中：
```
sudo mv timescaledb--pg13..rpm /var/cache/yum/x86_64/7/epel/packages/
sudo yum localinstall /var/cache/yum/x86_64/7/epel/packages/timescaledb--pg13..rpm
```
在PostgreSQL中创建TimescaleDB扩展：
```
sudo su -c "psql -c 'CREATE EXTENSION IF NOT EXISTS timescaledb;'" -U postgres
```
7. **验证安装**：你可以通过连接到PostgreSQL服务器并运行查询来检查PostGIS和TimescaleDB是否正确安装：
```
psql -U postgres -d your_database_name
SELECT postgis_version();
SELECT * FROM timescaledb_information.chunks;
```
以上就是在CentOS 7下离线安装PostgreSQL 13、PostGIS和TimescaleDB的详细步骤。离线安装虽然需要更多手动操作，但能确保在没有互联网连接的情况下也能顺利完成安装。记得在实际操作时替换掉命令中的占位符，并根据实际情况调整路径。在部署完成后，你可以利用PostgreSQL的强健性、PostGIS的空间分析能力和TimescaleDB对时序数据的高效管理，为你的应用程序提供强大的数据存储和处理能力。
文件下载
资源详情
[{"title":"（ 102 个子文件 94.64MB ） centos7下postgresql13 + postgis + timescaledb 时序库完整纯离线安装包","children":[{"title":"glibc-common-2.17-326.el7_9.x86_64.rpm <span style='color:#111;'> 11.50MB </span>","children":null,"spread":false},{"title":"gdal34-libs-3.4.3-4.rhel7.x86_64.rpm <span style='color:#111;'> 8.06MB </span>","children":null,"spread":false},{"title":"perl-5.16.3-299.el7_9.x86_64.rpm <span style='color:#111;'> 7.97MB </span>","children":null,"spread":false},{"title":"libicu-50.2-4.el7_7.i686.rpm <span style='color:#111;'> 6.91MB </span>","children":null,"spread":false},{"title":"libicu-50.2-4.el7_7.x86_64.rpm <span style='color:#111;'> 6.87MB </span>","children":null,"spread":false},{"title":"libicu-50.2-4.el7_7.x86_64.rpm <span style='color:#111;'> 6.87MB </span>","children":null,"spread":false},{"title":"postgis33_13-3.3.2-1.rhel7.x86_64.rpm <span style='color:#111;'> 5.76MB </span>","children":null,"spread":false},{"title":"postgresql13-server-13.10-1PGDG.rhel7.x86_64.rpm <span style='color:#111;'> 5.36MB </span>","children":null,"spread":false},{"title":"glibc-2.17-326.el7_9.i686.rpm <span style='color:#111;'> 4.26MB </span>","children":null,"spread":false},{"title":"glibc-2.17-326.el7_9.x86_64.rpm <span style='color:#111;'> 3.64MB </span>","children":null,"spread":false},{"title":"proj72-7.2.1-1.rhel7.x86_64.rpm <span style='color:#111;'> 2.51MB </span>","children":null,"spread":false},{"title":"libspatialite43-4.3.0a-15.rhel7.x86_64.rpm <span style='color:#111;'> 2.38MB </span>","children":null,"spread":false},{"title":"poppler-data-0.4.6-3.el7.noarch.rpm <span style='color:#111;'> 2.15MB </span>","children":null,"spread":false},{"title":"SFCGAL-libs-1.3.1-2.rhel7.x86_64.rpm <span style='color:#111;'> 1.65MB </span>","children":null,"spread":false},{"title":"perl-Encode-2.51-7.el7.x86_64.rpm <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"timescaledb_13-2.10.0-1.rhel7.x86_64.rpm <span style='color:#111;'> 1.43MB </span>","children":null,"spread":false},{"title":"postgresql13-13.10-1PGDG.rhel7.x86_64.rpm <span style='color:#111;'> 1.42MB </span>","children":null,"spread":false},{"title":"dejavu-sans-fonts-2.33-6.el7.noarch.rpm <span style='color:#111;'> 1.41MB </span>","children":null,"spread":false},{"title":"geos311-3.11.2-1.rhel7.x86_64.rpm <span style='color:#111;'> 896.52KB </span>","children":null,"spread":false},{"title":"xerces-c-3.1.1-10.el7_7.x86_64.rpm <span style='color:#111;'> 878.65KB </span>","children":null,"spread":false},{"title":"geos310-3.10.3-1.rhel7.x86_64.rpm <span style='color:#111;'> 863.00KB </span>","children":null,"spread":false},{"title":"poppler-0.26.5-43.el7.1.x86_64.rpm <span style='color:#111;'> 787.45KB </span>","children":null,"spread":false},{"title":"perl-libs-5.16.3-299.el7_9.x86_64.rpm <span style='color:#111;'> 689.58KB </span>","children":null,"spread":false},{"title":"geos39-3.9.2-1.rhel7.x86_64.rpm <span style='color:#111;'> 646.32KB </span>","children":null,"spread":false},{"title":"sqlite33-3.30.1-6.rhel7.x86_64.rpm <span style='color:#111;'> 624.04KB </span>","children":null,"spread":false},{"title":"postgresql13-contrib-13.10-1PGDG.rhel7.x86_64.rpm <span style='color:#111;'> 614.54KB </span>","children":null,"spread":false},{"title":"libX11-1.6.7-4.el7_9.x86_64.rpm <span style='color:#111;'> 607.07KB </span>","children":null,"spread":false},{"title":"sqlite33-libs-3.30.1-6.rhel7.x86_64.rpm <span style='color:#111;'> 549.96KB </span>","children":null,"spread":false},{"title":"libtiff-devel-4.0.3-35.el7.x86_64.rpm <span style='color:#111;'> 473.91KB </span>","children":null,"spread":false},{"title":"unixODBC-2.3.1-14.el7.x86_64.rpm <span style='color:#111;'> 413.23KB </span>","children":null,"spread":false},{"title":"postgresql13-libs-13.10-1PGDG.rhel7.x86_64.rpm <span style='color:#111;'> 384.73KB </span>","children":null,"spread":false},{"title":"nss-softokn-freebl-3.79.0-4.el7_9.x86_64.rpm <span style='color:#111;'> 337.16KB </span>","children":null,"spread":false},{"title":"nss-softokn-freebl-3.79.0-4.el7_9.i686.rpm <span style='color:#111;'> 325.24KB </span>","children":null,"spread":false},{"title":"libstdc++-4.8.5-44.el7.i686.rpm <span style='color:#111;'> 318.91KB </span>","children":null,"spread":false},{"title":"fontconfig-2.13.0-4.3.el7.x86_64.rpm <span style='color:#111;'> 254.41KB </span>","children":null,"spread":false},{"title":"CGAL-4.7-1.rhel7.1.x86_64.rpm <span style='color:#111;'> 253.73KB </span>","children":null,"spread":false},{"title":"ogdi41-4.1.0-2.rhel7.x86_64.rpm <span style='color:#111;'> 218.45KB </span>","children":null,"spread":false},{"title":"perl-Pod-Simple-3.28-4.el7.noarch.rpm <span style='color:#111;'> 216.03KB </span>","children":null,"spread":false},{"title":"libxcb-1.13-1.el7.x86_64.rpm <span style='color:#111;'> 213.77KB </span>","children":null,"spread":false},{"title":"mpfr-3.1.1-4.el7.x86_64.rpm <span style='color:#111;'> 203.43KB </span>","children":null,"spread":false},{"title":"pcre2-10.23-2.el7.x86_64.rpm <span style='color:#111;'> 201.34KB </span>","children":null,"spread":false},{"title":"mesa-libGLU-9.0.0-4.el7.x86_64.rpm <span style='color:#111;'> 196.17KB </span>","children":null,"spread":false},{"title":"libtiff-4.0.3-35.el7.x86_64.rpm <span style='color:#111;'> 172.04KB </span>","children":null,"spread":false},{"title":"libwebp-0.3.0-10.el7_9.x86_64.rpm <span style='color:#111;'> 170.27KB </span>","children":null,"spread":false},{"title":"boost-serialization-1.53.0-28.el7.x86_64.rpm <span style='color:#111;'> 169.41KB </span>","children":null,"spread":false},{"title":"mesa-libGL-18.3.4-12.el7_9.x86_64.rpm <span style='color:#111;'> 165.83KB </span>","children":null,"spread":false},{"title":"libX11-common-1.6.7-4.el7_9.noarch.rpm <span style='color:#111;'> 164.39KB </span>","children":null,"spread":false},{"title":"openjpeg2-2.3.1-3.el7_7.x86_64.rpm <span style='color:#111;'> 152.93KB </span>","children":null,"spread":false},{"title":"jasper-libs-1.900.1-33.el7.x86_64.rpm <span style='color:#111;'> 150.44KB </span>","children":null,"spread":false},{"title":"lcms2-2.6-3.el7.x86_64.rpm <span style='color:#111;'> 150.42KB </span>","children":null,"spread":false},{"title":"libjpeg-turbo-1.2.90-8.el7.x86_64.rpm <span style='color:#111;'> 134.52KB </span>","children":null,"spread":false},{"title":"nspr-4.34.0-3.1.el7_9.x86_64.rpm <span style='color:#111;'> 127.79KB </span>","children":null,"spread":false},{"title":"libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64.rpm <span style='color:#111;'> 124.66KB </span>","children":null,"spread":false},{"title":"perl-podlators-2.5.1-3.el7.noarch.rpm <span style='color:#111;'> 111.64KB </span>","children":null,"spread":false},{"title":"libgcc-4.8.5-44.el7.i686.rpm <span style='color:#111;'> 110.58KB </span>","children":null,"spread":false},{"title":"libgeotiff16-1.6.0-6.rhel7.x86_64.rpm <span style='color:#111;'> 94.32KB </span>","children":null,"spread":false},{"title":"libglvnd-1.0.1-0.8.git5baa1e5.el7.x86_64.rpm <span style='color:#111;'> 89.45KB </span>","children":null,"spread":false},{"title":"libtirpc-0.2.4-0.16.el7.x86_64.rpm <span style='color:#111;'> 89.25KB </span>","children":null,"spread":false},{"title":"perl-Pod-Perldoc-3.20-4.el7.noarch.rpm <span style='color:#111;'> 86.68KB </span>","children":null,"spread":false},{"title":"openjpeg-libs-1.5.1-18.el7.x86_64.rpm <span style='color:#111;'> 86.06KB </span>","children":null,"spread":false},{"title":"perl-PathTools-3.40-5.el7.x86_64.rpm <span style='color:#111;'> 82.49KB </span>","children":null,"spread":false},{"title":"nss-util-3.79.0-1.el7_9.x86_64.rpm <span style='color:#111;'> 79.58KB </span>","children":null,"spread":false},{"title":"perl-Storable-2.45-3.el7.x86_64.rpm <span style='color:#111;'> 77.04KB </span>","children":null,"spread":false},{"title":"perl-Filter-1.49-3.el7.x86_64.rpm <span style='color:#111;'> 76.40KB </span>","children":null,"spread":false},{"title":"libspatialite43-devel-4.3.0a-15.rhel7.x86_64.rpm <span style='color:#111;'> 72.84KB </span>","children":null,"spread":false},{"title":"libICE-1.0.9-9.el7.x86_64.rpm <span style='color:#111;'> 66.13KB </span>","children":null,"spread":false},{"title":"dejavu-fonts-common-2.33-6.el7.noarch.rpm <span style='color:#111;'> 64.25KB </span>","children":null,"spread":false},{"title":"boost-thread-1.53.0-28.el7.x86_64.rpm <span style='color:#111;'> 57.54KB </span>","children":null,"spread":false},{"title":"perl-File-Temp-0.23.01-3.el7.noarch.rpm <span style='color:#111;'> 56.33KB </span>","children":null,"spread":false},{"title":"perl-Getopt-Long-2.40-3.el7.noarch.rpm <span style='color:#111;'> 55.84KB </span>","children":null,"spread":false},{"title":"boost-date-time-1.53.0-28.el7.x86_64.rpm <span style='color:#111;'> 51.93KB </span>","children":null,"spread":false},{"title":"perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm <span style='color:#111;'> 51.82KB </span>","children":null,"spread":false},{"title":"perl-threads-1.87-4.el7.x86_64.rpm <span style='color:#111;'> 49.21KB </span>","children":null,"spread":false},{"title":"perl-Socket-2.010-5.el7.x86_64.rpm <span style='color:#111;'> 48.70KB </span>","children":null,"spread":false},{"title":"jbigkit-libs-2.0-11.el7.x86_64.rpm <span style='color:#111;'> 46.45KB </span>","children":null,"spread":false},{"title":"mesa-libglapi-18.3.4-12.el7_9.x86_64.rpm <span style='color:#111;'> 45.86KB </span>","children":null,"spread":false},{"title":"perl-Time-HiRes-1.9725-3.el7.x86_64.rpm <span style='color:#111;'> 45.22KB </span>","children":null,"spread":false},{"title":"perl-macros-5.16.3-299.el7_9.x86_64.rpm <span style='color:#111;'> 44.26KB </span>","children":null,"spread":false},{"title":"giflib-4.1.6-9.el7.x86_64.rpm <span style='color:#111;'> 40.00KB </span>","children":null,"spread":false},{"title":"boost-system-1.53.0-28.el7.x86_64.rpm <span style='color:#111;'> 39.78KB </span>","children":null,"spread":false},{"title":"libSM-1.2.2-2.el7.x86_64.rpm <span style='color:#111;'> 39.22KB </span>","children":null,"spread":false},{"title":"perl-threads-shared-1.43-6.el7.x86_64.rpm <span style='color:#111;'> 38.93KB </span>","children":null,"spread":false},{"title":"libXext-1.3.3-3.el7.x86_64.rpm <span style='color:#111;'> 38.64KB </span>","children":null,"spread":false},{"title":"perl-HTTP-Tiny-0.033-3.el7.noarch.rpm <span style='color:#111;'> 38.37KB </span>","children":null,"spread":false},{"title":"perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm <span style='color:#111;'> 35.95KB </span>","children":null,"spread":false},{"title":"libXau-1.0.8-2.1.el7.x86_64.rpm <span style='color:#111;'> 29.09KB </span>","children":null,"spread":false},{"title":"libgeotiff16-devel-1.6.0-6.rhel7.x86_64.rpm <span style='color:#111;'> 28.91KB </span>","children":null,"spread":false},{"title":"perl-Exporter-5.68-3.el7.noarch.rpm <span style='color:#111;'> 28.41KB </span>","children":null,"spread":false},{"title":"perl-Pod-Usage-1.63-3.el7.noarch.rpm <span style='color:#111;'> 26.79KB </span>","children":null,"spread":false},{"title":"perl-File-Path-2.09-2.el7.noarch.rpm <span style='color:#111;'> 26.45KB </span>","children":null,"spread":false},{"title":"perl-Time-Local-1.2300-2.el7.noarch.rpm <span style='color:#111;'> 24.21KB </span>","children":null,"spread":false},{"title":"libXdamage-1.1.4-4.1.el7.x86_64.rpm <span style='color:#111;'> 20.43KB </span>","children":null,"spread":false},{"title":"perl-Carp-1.26-244.el7.noarch.rpm <span style='color:#111;'> 19.21KB </span>","children":null,"spread":false},{"title":"perl-constant-1.27-2.el7.noarch.rpm <span style='color:#111;'> 18.79KB </span>","children":null,"spread":false},{"title":"libXfixes-5.0.3-1.el7.x86_64.rpm <span style='color:#111;'> 18.25KB </span>","children":null,"spread":false},{"title":"libXxf86vm-1.1.4-1.el7.x86_64.rpm <span style='color:#111;'> 17.55KB </span>","children":null,"spread":false},{"title":"SFCGAL-1.3.1-2.rhel7.x86_64.rpm <span style='color:#111;'> 14.45KB </span>","children":null,"spread":false},{"title":"perl-Text-ParseWords-3.29-4.el7.noarch.rpm <span style='color:#111;'> 13.73KB </span>","children":null,"spread":false},{"title":"perl-parent-0.225-244.el7.noarch.rpm <span style='color:#111;'> 12.30KB </span>","children":null,"spread":false},{"title":"fontpackages-filesystem-1.44-8.el7.noarch.rpm <span style='color:#111;'> 9.88KB </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]
评论信息
其他资源
- LPDDR4 JESD spec
- [BUPT]计算机系统基础课程全部实验+ PPT 整合包 （计算机学院 - 大二上）.zip
- git+repo+gerrit代码服务器搭建
- 《软件工程》课程设计学生选课系统
- 2021巨控GRM110无线通讯模块使用手册.pdf
- STsong-light字体.ttf
- OpenCV级联分类器训练与使用教程与代码
- pangolin pro破解版
- Finite Fields
- HandBrake视频转换（VS2010编译通过）
- java基于socket聊天室源代码.rar
- 手机端Web项目开发
- Progmobbaru-源码
- 机械工程设计分析和MATLAB应用（第二版）
- gcc-gnat-4.8.5-36.el7.x86_64.rpm
- the_linux_command_line.pdf
- 浙江理工大学2017-2019年历年研究生入学考试试卷，代码：723.pdf
- mysql-5.7.17.msi安装版
- word，excel，ppt完美转换PDF（解决各种疑难文档）
- 各种插值方法
- W3Cschool5.0最新版chm格式
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明