3.19 release test postgresql status

Postgresql Status (README!)

This is the first Release Test which will be run using postgresql as the standard database for both the harvest and admin databases. The standard release test scripts have been modified to set-up and tear-down postgresql databases and populate the harvest database with the same basic state as in the old derby tests. That is to say, one can start and stop a test with following sequence of commands:

cleanup_all_test.sh
prepare_test_dedup_disabled.sh OR prepare_test_db.sh
install_test.sh
start_test.sh
stop_test.sh
cleanup_all_test.sh

The databases are created with then names

${TESTX_LC}_harvestdb

and

${TESTX_LC}_admindb

where

${TESTX_LC}

is

$TESTX

converted to lowercase. The databases can be inspected on kb-test-adm-001 by

psql -U test -d <database_name>

All other scripts have been moved to the directory bin/quarantine on kb-prod-udv-001. To enable postgresql on any other test:

  1. Copy the relevant "prepare" script to bin
  2. Modify the prepare script to insert the correct database names in the config file
  3. In CVS, move the relevant config file from conf/quarantine to conf
  4. Modify the config file to remove the directory reference to derby and add connection information for postgresql, following exactly what is found in deploy_config_dedup_disabled.xml
  5. If a custom install script is used in the test, copy the installation part for the databases from install_test.sh

Finally note the bin directory on kb-prod-udv-001 is a working copy of a directory in CVS so any changes to it should be committed.