PostgreSQL Quick Start Installation Guide

Download the latest release of PostgreSQL 8 (Note: Postgres 8.3.0 is not recommended).
- For UNIX: Download the source from http://www.postgresql.org/ftp/source/.
- For Windows: Download the installer from http://www.postgresql.org/ftp/binary/.
Install it.
- For UNIX: Build and install it as described here: http://www.postgresql.org/docs/8.2/static/install-short.html.
  - Another way to install PostgreSQL is via a package installer such as yum on Fedora. Depending on how you installed PostgreSQL, you may have to configure its authentication mechanisms for the rest of the following commands to work. One quick way to get PostgreSQL up and running is to edit its data/pg_hba.conf file such that it trusts all users on the box in which it is installed. You do this by having lines like the following in that file:
    local all all trust host all all 127.0.0.1/32 trust
    You may also want to change the PostgreSQL user's password; as root execute:
    passwd postgres
- For Windows: Install it as described here: http://pginstaller.projects.postgresql.org/,
Start PostgreSQL:
- For UNIX:
```
service postgresql start
```
  You may find that you have to initialize the database if this is the very first time you are starting a newly installed PostgreSQL. If the above start command fails, try this first and then execute the start command afterwards:
```
service postgresql initdb
```
- For Windows:
```
net start pgsql-8.2
```

Create a PostgreSQL role named rhqadmin with password rhqadmin:

cd <postgres-install-dir>
createuser -h 127.0.0.1 -p 5432 -U postgres -S -D -R rhqadmin

Create a PostgreSQL database named rhq, specifying the rhqadmin role as the owner:

cd <postgres-install-dir>
createdb -h 127.0.0.1 -p 5432 -U postgres -O rhqadmin rhq

If you are going to use this PostgreSQL installation for more than just demo purposes or simple development, go to the PostgreSQL Preparation page for more advanced settings you'll need to prepare this PostgreSQL for production use with RHQ.