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 grant_privileges_postgresql.sql file from the installation package to grant the necessary privileges to termwebuser.
   
   
4. Connect as the new user before creating TermWeb tables. This is important, in order for the new user to also be owner of every table.
   
   
5. Execute the termweb_postgresql.sql file from the installation package to create the database tables.
   • Select Select termweb database and click on on SQL icon  icon to open an SQL execution window.
   • Copy paste termweb_postgresql.sql content and execute query.
     
   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

...