diff options
author | Frédéric Guillot <fred@kanboard.net> | 2018-04-06 10:54:58 -0700 |
---|---|---|
committer | Frédéric Guillot <fred@kanboard.net> | 2018-04-06 10:54:58 -0700 |
commit | 0b306fa60ad84ea077111e0ff7b59208ba7bc8a3 (patch) | |
tree | 5d8941b5950ede2db8ca3fba0213792db0f07a50 /doc/en_US/postgresql-configuration.markdown | |
parent | ac11220a1aa7ae30b8827d9bbf221888d3edd0a7 (diff) |
Move documentation to https://docs.kanboard.org/
Diffstat (limited to 'doc/en_US/postgresql-configuration.markdown')
-rw-r--r-- | doc/en_US/postgresql-configuration.markdown | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/doc/en_US/postgresql-configuration.markdown b/doc/en_US/postgresql-configuration.markdown deleted file mode 100644 index bab15313..00000000 --- a/doc/en_US/postgresql-configuration.markdown +++ /dev/null @@ -1,50 +0,0 @@ -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. |