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.confAnd add
[...] host jira jira 127.0.0.1/32 md5 [...]