Database installation (PostgreSQL example)
Quick alternative for steps below:
/opt/cachalot/system/install.sh pgsql_inst
To install PostgreSQL 7.3.4 do the following:
- cd /tmp
- tar xzf /tmp/postgresql-base-7.3.4.tar.gz
- cdpostgresql-7.3.4
- ./configure --prefix=/opt/pgsql
- gmake install
- useradd -g cachalot postgres
- mkdir /opt/pgsql/data
- chown postgres /opt/pgsql/data
- chmod 770 /opt/pgsql/data
- touch /var/opt/postgresql
- chown postgres /var/opt/postgresql
- su - postgres
- /opt/pgsql/bin/initdb -D /opt/pgsql/data
- /opt/cachalot/bin/postgres.sh start
Quick alternative for steps below:
/opt/cachalot/system/install.sh pgsql_db
Do the following for creating the database:
- su - postgres
- /opt/pgsql/bin/createdb cachalot
- /opt/pgsql/bin/psql -f /opt/cachalot/system/database/create_general.pgsql.sql cachalot
- /opt/pgsql/bin/psql -f /opt/cachalot/system/database/create_operations.pgsql.sql cachalot
- /opt/pgsql/bin/psql -f /opt/cachalot/system/database/create_permissions.pgsql.sql cachalot
Quick alternative for steps below:
/opt/cachalot/system/install.sh pgsql_jdbc
Install JDBC driver:
unzip -d /opt/cachalot /tmp/cachalot-jdbc-pgsql.zip
If you have installed Tomcat not using
cachalot-tomcat.zip, then add JDBC driver to your Tomcat:
ln -s /opt/cachalot/external/jdbc/pg73jdbc2ee.jar /opt/cachalot/external/tomcat/shared/lib