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

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

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

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

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

      Reply
    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

      Reply
    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!

      Best
      Bogo

      Reply
      • 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
        
        Reply
    8. Thanks, JR – that worked great. Many thanks.

      Reply
      • Excellent! You are welcome! :)

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

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

      Reply
      • Hi jonax,

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

        Reply
    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 :(

      Reply
      • Hi Rude,

        Could you first run following command:

        
        updatedb
        

        And post output of following commands:

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

      Reply
    13. Very nice guide.

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

      Error: Missing Dependency: libSDL-1.2.so.0 is needed by package wxGTK-2.8.12-1.el5.i386 (postgresql)
      Error: Missing Dependency: libpq.so.5 is needed by package pgadmin3_92-1.16.1-1.rhel5.i386 (postgresql)
      Error: Missing Dependency: libgstinterfaces-0.10.so.0 is needed by package wxGTK-2.8.12-1.el5.i386 (postgresql)

      Reply
    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…

      Reply
    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…

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

Close