Page Comparison

These instructions will help you connect TermWeb to a Microsoft SQL Server 2012 database.

1. Create and Configure the

...

PostgreSQL Database

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 termwebuser. Select 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.

...