Thursday, 19 December 2019

How to Install PostgreSQL 12 on CentOS/RHEL/OEL 7




This article will help you to install PostgreSQL 12 on CentOS/RHEL/OEL 7 system.

1. Configure Yum Repository

# rpm -Uvh https://yum.postgresql.org/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

2. Install PostgreSQL 12 on CentOS

# yum install postgresql12-server

3. Initialize PGDATA

# /usr/pgsql-12/bin/postgresql-12-setup initdb

PostgreSQL 12 default data directory location is /var/lib/pgsql/12/data

4. Enable PostgreSQL Server on reboot

# systemctl enable postgresql-12.service

5. Start PostgreSQL Server

# systemctl start postgresql-12.service

6. Verify PostgreSQL Installation

# su - postgres -c "psql"

psql (12.0)
Type "help" for help.


postgres=# 

You may create a password for user Postgres for security purposes.


postgres=# \password postgres


Thanks!!!!!!!!!! Enjoy Programming!!! :)
Referecnce:
https://tecadmin.net/install-postgresql-11-on-centos/

No comments:

Post a Comment

Thanks for your valuable comments.

Elasticsearch: Copy Index Structure