Configure database manually on Windows

This section describes how to manually configure PostgreSQL database for Canvus Connect server in Windows.

Setup Canvus database and user

Create the database and user for Canvus server. For example:

Open a command prompt and navigate to C:\Program Files\PostgreSQL\13\bin.
Run this command to log into PostgreSQL as the postgres admin user: psql -U postgres
Run these psql commands:
```
CREATE USER "<DB user>" PASSWORD '<DB user password>';
CREATE DATABASE "<DB name>" OWNER "<DB user>";
GRANT ALL ON DATABASE "<DB name>" TO "<DB user>";
ALTER DATABASE "<DB name>" SET synchronous_commit=OFF;
```
Where:
- \<DB_user> is the database user.
- \<DB_user_password> is the password for the database user.
- \<DB_name> is the database name. For example, canvus
The database tables are created when you start the Canvus server for the first time.

Tip

It\'s best to quote your strings when creating the database as unquoted strings in PostgreSQL are converted to lower-case (see PSQL bug report) which may cause issues later.

Identify server database

You must provide the server with details about the database and database user you set up in database-setup-windows.

In the [sql] section of the configuration file, you must specify at least databasename, username and password.

Info

server-configuration-database