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
     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.
   • If you named the database something else than termweb, first edit the file and enter the database name in the first statementSelect termweb database and click on SQL icon to open an SQL execution window.
   • In SQL Server Management Studio, navigate to File > Open > File and select the file.
   • Right-click and select Execute, or just press F5 to run the script.
     
     

...