Editing the configuration file

To configure Spectrum 2 to use PostgreSQL database, you have to edit some or more of the following options in database section. Please note that connectionstring overrides everything else (aside from type).

Section Key Type Change to value Description
database type string pqxx Database type - “none”, “mysql”, “sqlite3”, “pqxx”.
database database string Name of the already create empty database Database used to store data.
database server string Database server Database server.
database port string Database port Database port.
database user string PostgreSQL user. PostgreSQL user.
database password string PostgreSQL Password. PostgreSQL Password.
database prefix string   Prefix of tables in database.
database connectionstring string Postgres connection string If you set this, it will ignore all other options above aside from type and prefix. This allows you to set any typical postgres connection string option, separated by spaces (no semicolons).

Creating the database

Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the PostgreSQL database user you use to connect the SQL.

Some examples

Using connectionstring:

[database]
type=pqxx
connectionstring=host=localhost database=spectrum2 user=myuser password=whatever

Using traditional options:

[database]
type=pqxx
server=localhost
database=spectrum2
user=myuser
password=whatever