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.
-
Browse Yum.postgres.org 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