Table of Contents
By default, Kanboard use Sqlite to store its data but it’s also possible to use Postgresql.
pdo_pgsql
installed (Debian/Ubuntu:
apt-get install php5-pgsql
)pgsql
:CREATE DATABASE kanboard;
The file config.php
should contain those values:
<?php
// We choose to use Postgresql instead of Sqlite
define('DB_DRIVER', 'postgres');
// Postgresql parameters
define('DB_USERNAME', 'REPLACE_ME');
define('DB_PASSWORD', 'REPLACE_ME');
define('DB_HOSTNAME', 'REPLACE_ME');
define('DB_NAME', 'kanboard');
Note: You can also rename the template file config.default.php
to
config.php
.
For the first time, Kanboard will run one by one each database migration and this process can take some time according to your configuration.
To avoid any issues or potential timeouts, you can initialize the database directly by importing the SQL schema:
psql -U postgres my_database < app/Schema/Sql/postgres.sql
The file app/Schema/Sql/postgres.sql
is a SQL dump that represents the
last version of the database.