Quick database setup for evaluations

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

You can use the following steps to install PostgreSQL and create the databases you need to evaluate Jive. You need to create Core, Activity Engine, and Analytics databases. Use the full database instructions to install your production databases, as described in the Database configuration and best practices section.

  1. Browse Yum.postgres.org (http://yum.postgresql.org/repopackages.php) 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 configure 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