Version 8

    Running TCK against a locally installed PostgreSQL


    The default postgresql profile defined in j2eetck-mods will create an installation which runs against a PostgreSQL database installed in QA labs. To be able to run locally PostgreSQL needs to be installed and some modifications have to be made to both the PostgreSQL configuration and j2eetck-mods.


    Installing PostgreSQL on Fedora

    As root perform the following:

    1. yum install postgresql-server

    2. /etc/init.d/postgresql initdb


    Configuring PostgreSQL

    Login as user postgres.


    Modifying the installation

    Modify /var/lib/pgsql/data/pg_hba.conf to allow for localhost connections with password only.



    # "local" is for Unix domain socket connections only
    local   all         all                               trust
    # IPv4 local connections:
    host    all         all          md5
    # IPv6 local connections:
    host    all         all         ::1/128               md5


    Modify /var/lib/pgsql/data/postgresql.conf to specify system resources. The pgbench program can be used to tune the database for optimal performance.


    Setup cts1 database

    Create the 'cts1' user


    > createdb -P cts1

    Enter password for new role: cts1
    Enter it again: cts1
    Shall the new role be a superuser? (y/n) n
    Shall the new role be allowed to create databases? (y/n) n
    Shall the new role be allowed to create more new roles? (y/n) n


    Create the 'cts1' database


    > createdb -EUTF8 -O cts1 cts1


    Install the plpgsql language into the  'cts1' database


    > createlang plpgsql cts1


    Configuring j2eetck-mods

    In j2eetck-mods/bin/ts-jboss-postgresql.jte set the postgresql.server property to localhost.


    In j2eetck-mods/jboss-db/jboss-postgresql/deploy/postgres-ds.xml replace the hostname in the url with localhost.


    A new PostgreSQL JDBC driver can replace the one in j2eetck-mods/lib/postgresql.