summaryrefslogtreecommitdiff
path: root/docs/postgresql-configuration.markdown
diff options
context:
space:
mode:
Diffstat (limited to 'docs/postgresql-configuration.markdown')
-rw-r--r--docs/postgresql-configuration.markdown38
1 files changed, 38 insertions, 0 deletions
diff --git a/docs/postgresql-configuration.markdown b/docs/postgresql-configuration.markdown
new file mode 100644
index 00000000..04c6c2e7
--- /dev/null
+++ b/docs/postgresql-configuration.markdown
@@ -0,0 +1,38 @@
+Postgresql configuration
+========================
+
+By default, Kanboard use Sqlite to store its data but it's also possible to use Postgresql.
+
+Requirements
+------------
+
+- A Postgresql server already installed and configured
+- The PHP extension `pdo_pgsql` installed (Debian/Ubuntu: `apt-get install php5-pgsql`)
+
+Configuration
+-------------
+
+### Create an empty database with the command `pgsql`:
+
+```sql
+CREATE DATABASE kanboard;
+```
+
+### Create a config file
+
+Inside our config file write those lines:
+
+```php
+<?php
+
+// We choose to use Postgresql instead of Sqlite
+define('DB_DRIVER', 'postgres');
+
+// Mysql parameters
+define('DB_USERNAME', 'REPLACE_ME');
+define('DB_PASSWORD', 'REPLACE_ME');
+define('DB_HOSTNAME', 'REPLACE_ME');
+define('DB_NAME', 'kanboard');
+```
+
+Now, you are ready to use Postgresql.