Setup SWiM (1 - Initialise Database)

Welcome to SWiM! This installer will help you to set up your database for use with SWiM. Please proceed to each of the steps and follow the given instructions carefully.

1. Setup and Start Postgres Database

SWiM currently uses PostgreSQL version 7.4 or higher as database.

  1. download a package appropriate for your platform from postgresql.org, install it, and start postgres
  2. setup a user (referred to in the following as "super user") that is allowed to create new databases and users; you can do this on the command line as follows (for a user "root"): 
       createuser -a -d -P root
    under Unix, you first need to su to the postgres user.
  3. setup database to accept TCP/IP connections: find the configuration file postgresql.conf and …
    • PostgreSQL 7.4: and set the option tcpip_socket to true.
    • PostgreSQL 8.x: TCP/IP connections from localhost work by default; for others, modify the listen_addresses setting, e.g. listen_addresses = '*' (from anywhere).
  4. setup database to accept password-based authentication; find the configuration file pg_hba.conf and add the following line to the top of the file: 
     host    all         all         127.0.0.1         255.255.255.255   md5
    instead of 127.0.0.1/255.255.255.255 you might want to use a different IP address and netmask to allow connections from different hosts.
  5. restart database

2. Setup of SWiM Tables

In the following form, enter the hostname, port, superuser name and superuser password as configured above. If you are finished, click on "Create Tables". This will create a new database named "ikewiki" and all required tables for the system to work.