How to Install PostgreSQL 10 on CentOS/RHEL 7/6 and Fedora 27/28

Windows Articles

How to install the Owncloud desktop client Ubuntu 20.04?

In this post, You will learn how to install the Owncloud desktop client on Ubuntu 20.04. Many users and...

How to finish a task and force to close a program in Windows 10

Hello! We use numerous applications in Windows 10 on a daily basis. However, these programs can fail and crash. That is, it...

How to install Android on a USB key

Hi! Android is a very versatile mobile operating system because it is based on Linux kernel and other open-source software, it can...

Microsoft releases emergency update.

Security is one of the fundamental issues for Microsoft in Windows 10. In fact, since it was launched, the company has changed...

How to remove Windows 10 network credentials

Hi! Every time you access a website using Windows 10, a lot happens. In fact, the system will store the credentials to...
Mel Khamlichi
Mel Khamlichihttp://www.osradar.com
Founder of Osradar, from Amsterdam Netherlands

PostgreSQL is an open source object-relational, highly scalable, SQL compliant database management system. PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database; and it is also available for Microsoft Windows and Linux (supplied in most distributions).

. This article will help you to  install PostgreSQL on CentOS, RHEL and Fedora Systems.

Add PostgreSQL Yum Repository

The first step is to install PostgreSQL repository in your system, Use one of below commands as per your system architecture and operating system.

CentOS/ 7 ###

rpm -Uvh https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

CentOS/ 6 ###

rpm -Uvh https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm

Fedora 27 ###

rpm -Uvh https://download.postgresql.org/pub/repos/yum/10/fedora/fedora-27-x86_64/pgdg-fedora10-10-4.noarch.rpm

Fedora 28 ###

rpm -Uvh https://download.postgresql.org/pub/repos/yum/10/fedora/fedora-28-x86_64/pgdg-fedora10-10-4.noarch.rpm

Installing PostgreSQL Server

After enabling PostgreSQL yum repository in your system use following command to install PostgreSQL 10 on your system with yum package manager.

yum install postgresql10-server postgresql10

Initializing PGDATA

After installing PostgreSQL server, It’s required to initialize it before using the first time. To initialize database use below command.  /usr/pgsql-10/bin/postgresql-10-setup initdb

[root@iptables-server ~]# /usr/pgsql-10/bin/postgresql-10-setup initdb
Initializing database ... OK

 

Above command will  initialize PostgreSQL first time. PGDATA environment variable contains the path of the data directory.

PostgreSQL data directory Path is : /var/lib/pgsql/10/data/

[root@iptables-server ~]# ls /var/lib/pgsql/10/data/ -altr
total 52
drwx------. 4 postgres postgres 51 Jul 15 17:33 ..
-rw-------. 1 postgres postgres 3 Jul 15 17:33 PG_VERSION
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_twophase
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_tblspc
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_stat_tmp
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_stat
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_snapshots
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_serial
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_replslot
drwx------. 4 postgres postgres 36 Jul 15 17:33 pg_multixact
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_dynshmem
drwx------. 2 postgres postgres 6 Jul 15 17:33 pg_commit_ts
-rw-------. 1 postgres postgres 22775 Jul 15 17:33 postgresql.conf
-rw-------. 1 postgres postgres 88 Jul 15 17:33 postgresql.auto.conf
-rw-------. 1 postgres postgres 1636 Jul 15 17:33 pg_ident.conf
-rw-------. 1 postgres postgres 4269 Jul 15 17:33 pg_hba.conf
drwx------. 2 postgres postgres 18 Jul 15 17:33 pg_xact
drwx------. 3 postgres postgres 60 Jul 15 17:33 pg_wal
drwx------. 2 postgres postgres 18 Jul 15 17:33 pg_subtrans
drwx------. 2 postgres postgres 18 Jul 15 17:33 pg_notify
drwx------. 2 postgres postgres 4096 Jul 15 17:33 global
drwx------. 5 postgres postgres 41 Jul 15 17:33 base
drwx------. 4 postgres postgres 68 Jul 15 17:33 pg_logical
drwx------. 2 postgres postgres 6 Jul 15 17:33 log

Start / Enable  PostgreSQL Server

To start PostgreSQL service using the following command as per your operating systems. Also, enable PostgreSQL service to autostart on system boot.

For CentOS/RHEL 7 and Fedora

systemctl start postgresql-10
systemctl enable postgresql-10

For CentOS/RHEL 6

service postgresql-10 start
chkconfig postgresql-10 on

 

Check and Verify PostgreSQL Installation

After  the  above steps, your setup of  Postgresql 10 server is ready , Let’s log in to verify that installation completed successfully.

su - postgres

Use psql command to access PostgreSQL prompt with admin privileges.

[root@iptables-server ~]# su - postgres
-bash-4.2$ psql
psql (10.4)
Type "help" for help.

postgres=#

You may create password for user postgres

postgres=#\ password postgres

Congratulation  you  PostgreSQL installation  Server is completed

Please share  .

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to install the Owncloud desktop client Ubuntu 20.04?

In this post, You will learn how to install the Owncloud desktop client on Ubuntu 20.04. Many users and...

How to finish a task and force to close a program in Windows 10

Hello! We use numerous applications in Windows 10 on a daily basis. However, these programs can fail and crash. That is, it...

How to install Android on a USB key

Hi! Android is a very versatile mobile operating system because it is based on Linux kernel and other open-source software, it can...

Microsoft releases emergency update.

Security is one of the fundamental issues for Microsoft in Windows 10. In fact, since it was launched, the company has changed...

How to remove Windows 10 network credentials

Hi! Every time you access a website using Windows 10, a lot happens. In fact, the system will store the credentials to...
x