Select Page

How to install and setup PostgreSQL on Fedora Core 15

  1. Open a new Terminal Window and then install the latest PostgreSQL Server
    sudo yum install postgresql-server
  2. Now we need to initialize the Database Cluster
    sudo service postgresql initdb
  3. Now start the server
    service postgresql start
  4. Now login with the postgres user
    sudo su -l postgres

    This user automatically gets created when the PostgresSQL server gets installed

  5. Now we create a new PostgreSQL user
    createuser --no-superuser --no-createdb --no-createrole --pwprompt testUser

    When prompted for a password just enter any password you prefer

  6. Create a new Database and assign it to the newly created user
    createdb --owner testUser Database
  7. In order to allow connections from servers to this server edit the pg_hba.conf file
    vi /var/lib/pgsql/data/pg_hba.conf
  8. Reload the postgreSQL server so that all changes can take effect
    service postgresql reload

Last Updated On April 07, 2018

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.