Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create a database for TermWeb to store data in (e.g. termweb). 
    • Open pgAdmin and right click on Databases and select New Database
      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 termwebuserSelect password: termwebuser.
    • Set login role as database owner and set permissions (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.

2. Copy the SQL Server JDBC Driver to Tomcat

...