Configuring PostgreSQL

Make sure you switch to the Unix account which may administer your PostgreSQL database. Quite often this user is called 'postgres'. Alternatively you can use a PostgreSQL account with rights to create new users and databases.

First of all, create a database user with a name of your choice. This account will be used to do all modifications on database tables of the hypertext system. We recommend the name 'htsys'.

createuser -A -D -P htsys

Secondly, create a database with a name of your choice and allow access for the previously created user. The easiest way would be to choose the same name as for the user.

createdb htsys

Next, create all necessary tables by running the following command.

psql -U <username> -W -d <databasename> -f create_htsys_pg.sql

The username and databasename are the names of the just created user and database, e.g. htsys. It will only create the tables for the hypertext system. If you would like to create the initial collections in the hypertext system run the following command as well.

psql -U <username> -W -d <databasename> -f insert_htsys_pg.sql

The collections are called hyperroot and rootcollection. You do not have to create those collections, if you rather like to use the sample catalogue. Its installation is described in section 4.5.2.

Depending on the user authentication method you will also have to create some more tables by running the following command.

psql -U <username> -W -d <databasename> -f create_user_group_pg.sql

It creates a simple user and group database. You will not need these tables if you employ a ldap server. If you are unsure about the authentication method, create these tables. The command will also create the user 'mmc' with the password 'catalog'.

You should create these tables I you plan to install the sample catalogue, since it requires a user named 'mmc', unless you have the possibility to create such a user on your own ldap server.