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

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: 1

1 2 3 4
    1. thank you very much for sharing instructions on how to install postgresql 9.2

    2. Awesome write-up. Got me up and running quickly. Thanks.

    3. Works without a hitch! I am using Scientific Linux 6.3. Thanks.

    4. Thanks for the instructions. Worked perfectly on Centos 6.3 Server.

    5. Works fine on Centos. Thanks a lot. Your Webpage is awesome.

    6. Great guide. I just had to add this command `export PATH=/usr/pgsql-9.2/bin:$PATH` before firing up `createdb test`. I am using CentOS 6.3

    7. Great site, and this latest for postgresql good as usual. But would be a big help to get pgadmin3 latest to run with 9.2: other distros (ubuntu via .deb) have got 1.16 running, but my Fedora 17 won’t upgrade to this – yum will still only install 1.14 which is not compatible with 9.2

      Your assistance appreciated!


      • Hi Bogo,

        Nice to hear that you get PostgreSQL up and running. :)

        Personally I use just psql client, but looks like pgadmin3 1.16 found also from PostgreSQL own repos, try following to install latest pgadmin3 1.16:

        yum install pgadmin3_92
    8. Thanks, JR – that worked great. Many thanks.

      • Excellent! You are welcome! :)

    9. Fantastic & easy write-up… helped to get the DB UP quickly.
      Thanks Bro..

    10. I am using Fedora 17, but in the step 3.4 “Test Remote Connection” –> psql: could not translate host name “dbserver_name_or_ip_address” to address: Name or service not known.
      help me please.

      • Hi jonax,

        You have to replace dbserver_name_or_ip_address with your own ip address or hostname.

    11. Hi,

      Tried to follow your guide but when i got to “createdb” it says createdb command not found. But i see postgresql running in the service.

      Tried to do a simple “psql” and it says command not found too :(

      • Hi Rude,

        Could you first run following command:


        And post output of following commands:

        rpm -qa postgresql\*
        locate postgresql psql createdb
    12. Oh thx found it :) Didn’t have locate on the distrib. Kind of new to Centos :) Thank you

    13. Very nice guide.

      Have you ever installed PGADMIN3_92 in RHEL5 X86_64.
      I tried and got this:

      Error: Missing Dependency: is needed by package wxGTK-2.8.12-1.el5.i386 (postgresql)
      Error: Missing Dependency: is needed by package pgadmin3_92-1.16.1-1.rhel5.i386 (postgresql)
      Error: Missing Dependency: is needed by package wxGTK-2.8.12-1.el5.i386 (postgresql)

    14. I get [FAILED] when trying to start psql either via /etc/init.d or service postgresql-9.2 start.

      I also tried:

      ‘/usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/9.2/data -l logfile start’

      after su’ing to postgres & that worked but if I then CTRL-d back to root, postgres stops (I ended up just leaving it running in one terminal).

      Any help appreciated…

    15. In fact, after running:

      ‘usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/9.2/data -l logfile start’

      it is not running because when I try to ‘createdb test, I get:

      ‘could not connect to database template1: could not connect to server: No such file or directory
      Is the server running locally and accepting
      connections on Unix domain socket “/tmp/.s.PGSQL.5432”?’

      I forgot to mention this is on 64-bit CentOS 6.3…

1 2 3 4

Leave a Reply to JR Cancel 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.