centos7 install postgresql

Using stock CentOS repositories

Installing PostgreSQL on CentOS7 can be done two ways:

• From the PostgreSQL repositories
• From the official CentOS repositories

The later will be described in this document

Installation

[root@localhost ~]#yum install -y postgresql postgresql-server postgresql-libs postgresql-contrib 

Initialization

[root@localhost ~]# postgresql-setup initdb

Make sure it starts at boot

[root@localhost ~]# systemctl enable postgresql

Start the service

[root@localhost ~]# systemctl start postgresql

Switch to the service user

[root@localhost ~]# su - postgres

MAke sure you access locally

-bash-4.2$ psql
postgres=#

User and database creation

-bash-4.2$ createuser --interactive --pwprompt jira
-bash-4.2$ createdb --owner=jira jira

Switch to the Jira user

[root@localhost ~]# su - jira
[jira@localhost ~]$ psql --username=jira --password
psql (9.2.10)
Type "help" for help.
jira=#

If you want to access PostgreSQL without being "jira" user, you need to configure

[root@localhost ~]# nano -w /var/lib/pgsql/data/pg_hba.conf

And add

[...]
host   jira jira     127.0.0.1/32     md5
[...]