Install Postgresql 11.1 on Fedora 29/28, CentOS/RHEL/SL 7.5/6.10 - Comment Page: 4

This is guide, howto install PostgreSQL 11.1 database server on Fedora 29/28/27, CentOS/Red Hat (RHEL)/Scientific Linux (SL) 7.5/6.10. This guide uses PostgreSQL own YUM repos, which are always up-to-date and stable releases are available instantly. You can use this guide to install any Postgresql versions, like 12, 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25. [inttf_post_ad1] Note: If you are upgrading PostgresSQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. 1. Install PostgreSQL 11.1 Database Server on Fedora 29/28/27, CentOS/Red Hat (RHEL)/Scientific Linux (SL) 7.5/6.10 1.1 Change root user su - ## OR ## sudo...

72 comments on “Install Postgresql 11.1 on Fedora 29/28, CentOS/RHEL/SL 7.5/6.10 - Comment Page: 4

1 2 3 4
    1. What are the ownership and permissions of /var/lib/pgsql supposed to be? I am following the install procedure for postgresql on 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?

    2. 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.

    3. Thanks for the tutorial Postgres installation works for me.

    4. Much appreciated walk through — the most recent and accurate I have found.

1 2 3 4

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.