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.
   • Right click on PostgreSQL server and select Disconnect server
   • Right click on PostgreSQL server and select Properties
   • Write termwebuser as username
   • Doubleclick on PostgreSQL server to connect (might need to do it twice, due to wrong password)
   • Write the password termwebpwd in order to connect with the new user
     
     
5. 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.

...