Step 2: Add EPEL repository to CentOS 7
A number of dependencies are on the EPEL repository. Run the following command to install epel repository in your CentOS 7 machine.
sudo yum -y install epel-release
Step 3: Install PostGIS on CentOS 7
After the installation of PostgreSQL and adding EPEL repository, proceed to install PostGIS from the PostgreSQL added. The repository was added using command like below.
sudo yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
Then install PostGIS on CentOS 7 by running the command below.
sudo yum install postgis25_11
This will install PostGIS v2.5 for PostgreSQL 11. The version installed can be checked with:
$ rpm -qi postgis25_11
Name : postgis25_11
Version : 2.5.1
Release : 4.rhel7
Architecture: x86_64
Install Date: Wed 20 Feb 2019 10:37:35 PM CET
Group : Applications/Databases
Size : 32649231
License : GPLv2+
Signature : DSA/SHA1, Wed 02 Jan 2019 12:45:12 PM CET, Key ID 1f16d2e1442df0f8
Source RPM : postgis25_11-2.5.1-4.rhel7.src.rpm
Build Date : Wed 02 Jan 2019 12:44:54 PM CET
Build Host : koji-centos7-x86-64-pgbuild
Relocations : (not relocatable)
Vendor : PostgreSQL Global Development Group
URL : http://www.postgis.net/
Summary : Geographic Information Systems Extensions to PostgreSQL
Description :
PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server,
allowing it to be used as a backend spatial database for geographic information
systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
follows the OpenGIS "Simple Features Specification for SQL" and has been
certified as compliant with the "Types and Functions" profile.
Step 4: Enable PostGIS Spatial features
You need to activate PostGIS features on a database before you can store spacial data. The example below will show you how to create a database and activate the Spacial features.
1.Switch to postgres user.
sudo -i -u postgres
2.Create test user/database.
-bash-4.2$ createuser test_user
-bash-4.2$ createdb test_db -O test_user
3.Connect to the test database:
n this article, we are going to show you how to install PostgreSQL 11 (Postgres) database on CentOS 7 or RHEL 7.
Step 1: Add PostgreSQL YUM Repository
– Add PostgreSQL yum repository
# rpm -Uvh https://yum.postgresql.org/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
Step 2: Install PostgreSQL
# sudo yum install postgresql11-server
– Now that the database packages have been installed, Initialize the database by running the following command:
# sudo /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ... OK
– Use the below commands to start, enable the PostgreSQL 11 and check its status
# sudo systemctl start postgresql-11.service # sudo systemctl enable postgresql-11.service # sudo systemctl status postgresql-11.service
Step 3: Connect to PostgreSQL
– After installing PostgreSQL 11 database server, by default PostgreSQL, will create a system account user named postgreswith role postgres.
– To connect to the PostgreSQL database server, use the following commands:
~# su -l postgres ~$ psql psql (11.1 )) Type "help" for help. postgres=#