O&K Print Watch Linux – Database

O&K Print Watch for Linux supports SQLite and PostgreSQL for data storage. SQLite is used as the default database.

The database connection configuration is set in the /etc/printwatch/printwatch.conf.

  • Provider — is the name of the database provider, possible values: SQLite, PostgreSQL.

  • ConnectionString — is the string of connection to the database..
    For SQLite it is the path to the database file, for example /opt/printwatch/pw.db/
    For PostgreSQL - a string with the parameters of connection with the database server, for example host=192.168.0.3 port=5432 dbname=PRNWATCH user=prnwatch password=prnwatch.

  • SaveJobs — save the contents of printed documents, by default true.

  • LocalJobStorage — saves the contents of documents on disk, not in the database, defaults to true.

  • LocalJobStorageDirectory — the path to the folder on disk where the contents of the documents are saved.

Example configuration for SQLite: 

[Database]
Provider=SQLite
ConnectionString=/opt/printwatch/pw.db
SaveJobs=true
LocalJobStorage=true
LocalJobStorageDirectory=/opt/printwatch/jobs

Example configuration for PostgreSQL: 

[Database]
Provider=PostgreSQL
ConnectionString=host=192.168.0.3 port=5432 dbname=PRNWATCH user=prnwatch password=prnwatch
LocalJobStorage=true
LocalJobStorageDirectory=/opt/printwatch/jobs

After any changes to printwatch.conf, you must restart the printwatch service using the command 

sudo systemctl restart printwatch

Using PostgreSQL as a database server in O&K Print Watch.

Using PostgreSQL and pgBouncer with a large number of clients