From 0371acff89b14b9bdcb03e72fd9637e26e6b517c Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sun, 29 Jan 2017 11:07:42 -0500
Subject: Move English documentation to folder en_US

---
 doc/en_US/postgresql-configuration.markdown | 50 +++++++++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 doc/en_US/postgresql-configuration.markdown

(limited to 'doc/en_US/postgresql-configuration.markdown')

diff --git a/doc/en_US/postgresql-configuration.markdown b/doc/en_US/postgresql-configuration.markdown
new file mode 100644
index 00000000..bab15313
--- /dev/null
+++ b/doc/en_US/postgresql-configuration.markdown
@@ -0,0 +1,50 @@
+Postgresql configuration
+========================
+
+By default, Kanboard use Sqlite to store its data but it's also possible to use Postgresql.
+
+Requirements
+------------
+
+- Postgresql >= 9.3
+- 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
+
+The file `config.php` should contain those values:
+
+```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');
+```
+
+Note: You can also rename the template file `config.default.php` to `config.php`.
+
+### Importing SQL dump (alternative method)
+
+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:
+
+```bash
+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.
-- 
cgit v1.2.3