(021) 29427411 ext. 12

    Sometime we face situation to install postgresql in server environment without internet connection. Bellow is step – by – step to manually install postgresql locally.

    Download following files from here:

    • postgresql94-9.4.5-1PGDG.rhel6.x86_64.rpm
    • postgresql94-contrib-9.4.5-1PGDG.rhel6.x86_64.
    • postgresql94-libs-9.4.5-1PGDG.rhel6.x86_64.rpm
    • postgresql94-server-9.4.5-1PGDG.rhel6.x86_64.rpm

    Installation Steps:

    # rpm -ivh postgresql94-libs-9.4.5-1PGDG.rhel6.x86_64.rpm 
    warning: postgresql94-libs-9.4.5-1PGDG.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:postgresql94-libs-9.4.5-1PGDG.rhe################################# [100%]
    # rpm -ivh postgresql94-9.4.5-1PGDG.rhel6.x86_64.rpm 
    warning: postgresql94-9.4.5-1PGDG.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:postgresql94-9.4.5-1PGDG.rhel6   ################################# [100%]
    
    # rpm -ivh postgresql94-server-9.4.5-1PGDG.rhel6.x86_64.rpm 
    warning: postgresql94-server-9.4.5-1PGDG.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:postgresql94-server-9.4.5-1PGDG.r################################# [100%]
    
    service postgresql-9.4 initdb
    Initializing database:                                     [  OK  ]
    
    # chkconfig postgresql-9.4 on
    # service postgresql-9.4 start
    Starting postgresql-9.4 (via systemctl):                   [  OK  ]
    
    # su - postgres
    $ psql
    psql
    psql (9.2.13, server 9.4.5)
    WARNING: psql version 9.2, server version 9.4.
             Some psql features might not work.
    Type "help" for help.
    
    postgres=# create database testdb;
    CREATE DATABASE

    No Comment

    You can post first response comment.

    Leave A Comment

    Please enter your name. Please enter an valid email address. Please enter a message.