install postgresql11 on centos7

柔情只为你懂 2021-11-23 03:12 179阅读 0赞

## 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 **postgres**with 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=#

转载于:https://www.cnblogs.com/studyNT/p/11178994.html