How to install and setup PostgreSQL on Fedora Core 15

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
```