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 -i 1.2 Exclude...

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

    5. Minor typo in the most recent guide (11.1)

      Modify PostgreSQL /var/lib/pgsql/10/data/pg_hba.conf (host-based authentication) file:

      should be

      Modify PostgreSQL /var/lib/pgsql/11/data/pg_hba.conf (host-based authentication) file:

      • Hi Mart van de Ven,

        Thanks, I updated guide!

    6. add
      `host all all xx.xx.xx.xx/xx md5`
      into /var/lib/pgsql/11/data/pg_hba.conf will cause systemd not able to start postgre service6

      • Hi,

        This is only example use real ip/subnet, of course not just xx.xx.xx.xx/xx.

    7. On Fedora 29 /usr/pgsql-11/bin/postgresql-11-setup initdb =

      /usr/bin/postgresql-setup –initdb

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.