Page Comparison

...

1. Create a database for TermWeb to store data in (e.g. termweb). 
   
   • Open pgAdmin and right click on Databases and select New Database
     Name: termweb
     Encoding: UTF8
     Template: template0
     Collation: C
     Character Type: C
     
     
2. Create a database login role (user) which TermWeb will connect as (e.g. termwebuser), with permissions for the database.
   • Create a new login role (right click on Login Roles and select New Login Role) and name it termwebuser. Select password: termwebpwd.
   • Set login role as database owner (right click on termweb database and select Properties). Select termwebuser as owner.
     
     
3. Execute the termweb_postgresql.sql file from the installation package to create the database tables.
   • Select termweb database and click on SQL icon to open an SQL execution window.
   • Copy paste termweb_postgresql.sql content and execute query.
     
     
4. Execute the grant_privileges_postgresql.sql file from the installation package to grant the necessary privileges to termwebuser.

2. Copy the PostgreSQL JDBC Driver to Tomcat

1. Download the PostgreSQL driver (v9.4) from PostgreSQL official site.
2. Add the PostgreSQL driver jar (postgresql-9.4.1208.jre6.jar) to <tomcat-install>/lib/ directory.

...