If Not True Then False

Install PostgreSQL 10.1 on Fedora 27/26, CentOS/RHEL/SL 7.4/6.9 - Comment Page: 4

This is guide, howto install PostgreSQL 10.1 (currently 10.1) database server on Fedora 27/26/25, CentOS/Red Hat (RHEL)/Scientific Linux (SL) 7.4/6.9. This guide uses PostgreSQL own YUM repos, which are always up-to-date and stable releases are available instantly. Note: If you are upgrading PostgresSQL (from earlier version), then make sure that you backup (dump and copy) your database and...


Leave a Comment

Your email address will not be published. Required fields are marked *

Input your comment.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Input your name.


What are the ownership and permissions of /var/lib/pgsql supposed to be? I am following the install procedure for postgresql on https://www.if-not-true-then-false.com/2012/install-postgresql-on-fedora-centos-red-hat-rhel/ and am at step 2.1 for fedora 24

su – postgres -c /usr/pgsql-9.5/bin/initdb

which fails with “authentication failure”

Changing to

su -c ‘/usr/pgsql-9.4/bin/initdb’ postgres

fails with “su: failed to execute /var/lib/pgsql: Permission denied”

the file permissions and ownership are

sudo ls -alt /var/lib/pgsql
drwx——. 4 postgres postgres 4096 Oct 5 11:08 .

Do I have a file permissions/ownership problem or something else?

reply Reply

This guide was extremely helpful installing 9.4. I imagine installing 9.5 on Fedora 24 and above would be similar. Can we get a guide on how to handle migration from 9.4 to 9.5?

It’d be much appreciated.

reply Reply