install postgresql11 on centos7

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=#