Skip to content

Configure database manually on Linux

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

Setup Canvus database and user

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

sudo -u postgres psql
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;
\q

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.

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