To use a PostgreSQL database for your CollabNet
TeamForge data, install and configure the database
server and set up TeamForge to use it.
Tip: Gather the IP addresses of the machines where you are installing the
TeamForge application and database.
You will need them as you follow the steps on this page.
-
Download and install PostgreSQL on the host that will be your standalone
database server.
(May we suggest these PostgreSQL install instructions.)
-
Configure PostgreSQL to work with your site.
See Set up a PostgreSQL database for instructions.
-
Go to the host where your TeamForge
application is running.
-
Under "Application settings" in the site-options.conf
file, create (or reuse) a HOST_<hostname> token to
specify the machine where the database service will run.
For example:
-
HOST_databox.supervillain.org=database
-
Under "Database tokens," configure the site to use the database
application.
- If you are using a PostgreSQL database, keep the value of the
DATABASE_TYPE variable at the default value,
postgresql.
- If you are using an Oracle database:
- Set the value of the DATABASE_TYPE variable to
oracle.
- Set the value of the DATABASE_PORT variable to
1521.
-
Set values for the other key database variables. (Replace the terms in angle
brackets with any string you want.)
-
DATABASE_NAME=<database_name>
-
DATABASE_USERNAME=<database_user>
-
DATABASE_PASSWORD=<database_password>
Note: The database password must not contain any special characters. Only
alphanumerics will work.
Your database is now ready to manage the work products your users
produce.
Tip:
- Before proceeding, make sure you can manually connect to PostgreSQL using
the settings you have specified for the application. It is easier to
troubleshoot the connection now than in later steps.
- For recommendations on optimizing your PostgreSQL database to fit the
particular requirements of your CollabNet
TeamForge site, see this wiki page.