Quick Database Setup for Evaluations

You can use the quick database setup procedure for evaluations and other "light" installations.

1. Browse Yum.postgres.org to find a postgreSQL 9.0 or higher package to use for your Jive evaluation.
2. Download the appropriate rpm for your operating system to congfigure the proper yum repository:

   For example, type wget http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/pgdg-centos91-9.1-4.noarch.rpm

3. Install the yum repository through RPM:

   For example, type rpm -ivh pgdg-centos91-9.1-4.noarch.rpm

4. Install PostgreSQL

   For example, type yum -y install postgresql91-server

5. Initialize the database:

   For example, type /etc/init.d/postgresql-9.1 initdb

6. Change the pg_hba.conf. For example, type:

   cat <<EOF > /var/lib/pgsql/9.1/data/pg_hba.conf  
   local all all ident  
   host all all <application server IP address>/32 md5  
   EOF  

7. Start the server:

   For example, type /etc/init.d/postgresql-9.1 start

8. Set up the databases and users. For example, type:

   cat <<EOF | su - postgres -c psql  
   create user core with password 'core';  
   create database core owner core encoding 'UTF-8';  
   create user eae with password 'eae';  
   create database eae owner eae encoding 'UTF-8';  
   create user analytics with password 'analytics';  
   create database analytics owner analytics encoding 'UTF-8';  
   EOF