How Can We Help?
- Open a new Terminal Window and then install the latest PostgreSQL Server
sudo yum install postgresql-server
- Now we need to initialize the Database Cluster
sudo service postgresql initdb
- Now start the server
service postgresql start
- Now login with the postgres user
sudo su -l postgres
This user automatically gets created when the PostgresSQL server gets installed
- 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
- Create a new Database and assign it to the newly created user
createdb --owner testUser Database
- In order to allow connections from servers to this server edit the pg_hba.conf file
vi /var/lib/pgsql/data/pg_hba.conf
- Reload the postgreSQL server so that all changes can take effect
service postgresql reload
