For testing purposes, you may have to install and initialize the PostgreSQL database on Linux. The instructions below were tested on Ubuntu Linux 8.04 x86, but if you are using a different Linux distribution, only the package installation instructions will differ for you, and you should be able to figure out how to change them to work with your package manager.
This will install the PostgreSQL 8.2 server, client, associated libraries and other dependencies, and the pgadmin graphical administration utility:
Various dependencies will be auto-selected; postgresql-8.2 is a meta-package, so it is comprised entirely of dependencies. If you need to test with other versions, select their meta-packages instead.
pgadmin3 is not explicitly required for testing, but it makes it much easier to manage PostgreSQL databases and tablespaces.
sudo /etc/init.d/postgresql-8.2 start
sudo su postgres -c psql template1
ALTER USER postgres with PASSWORD 'password';
This will set the postgres user's password to password, which suits our internal testing purposes. Please change this to a secure password for production systems.
sudo passwd postgres
Your server should now be ready to go. Run the Pentaho scripts for creating quartz, hibernate, and sample user data, and commence testing.