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.
-
Browse Yum.postgres.org repopackages.php to find a postgreSQL 9.0 or higher package to use for your Jive evaluation.
-
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 -
Install the yum repository through RPM.
For example, type
rpm -ivh pgdg-centos91-9.1-4.noarch.rpm -
Install PostgreSQL.
For example, type
yum -y install postgresql91-server -
Initialize the database.
For example, type
/etc/init.d/postgresql-9.1 initdb -
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 -
Start the server.
For example, type
/etc/init.d/postgresql-9.1 start -
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