coldfusion: connecting with postgres as datasource

to setup postgres as coldfusion datasource:

1. download jdbc* driver and place into coldfusion's java lib directory
    (/opt/coldfusionmx/lib or <coldfusion path>/lib)

2. restart cf

3. use dsn details below
    Field Description 
    JDBC URL - jdbc:postgresql://<pgsqlDbHost>/<databaseName> 
    Driver Class - org.postgresql.Driver 
    Driver Name (Optional) (The name of the driver  )
    Username (ColdFusion user account on the database server)
    Password (Password for the user account on the database server )

4. configure postgres to accept tcp/ip connections because java uses tcp/ip connections

    edit postgresql.conf

        set hba_file = '/usr/local/pgsql/data/pg_hba.conf'
        set listen_address = 'localhost,192.168.1.12,etc'

    edit pg_hba.conf, add

        host    all             all     192.168.1.12/32         trust
        host    all             all     192.168.1.13/32         trust

    etc

* using jdbc3