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'll need to create Core, Activity Engine, and Analytics databases. Use the full database instructions to install your production databases.

  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  
  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';