[PATCH v2 4/4] Test postgresql support in Travis CI

[Daniel Axtens]

Use the most recent version of postgres (9.6) because we need a
more recent version than the default to show up the broken
bundle behaviour.

This should prevent us from causing any further regressions.

Signed-off-by: Daniel Axtens <dja at axtens.net>

---

v2: MySQL has already been moved to the root user
---
 .travis.yml | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/.travis.yml b/.travis.yml
index 1f898f3733b5..f19fe4f3fa35 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -1,5 +1,6 @@
 language: python
 
+dist: trusty
 sudo: false
 
 python:
@@ -7,17 +8,24 @@ python:
   - 3.4
   - 3.5
 
+addons:
+  postgresql: "9.6"
+
 services:
   - mysql
+  - postgresql
 
 env:
+  matrix:
+    - PW_TEST_DB_TYPE=postgres PW_TEST_DB_USER=postgres
+    - PW_TEST_DB_TYPE=mysql PW_TEST_DB_USER=root
   global:
-    - PW_TEST_DB_USER=root
     - PW_TEST_DB_PASS=""
     - PW_SKIP_BROWSER_TESTS=yes
 
 before_script:
   - mysql -e 'create database patchwork character set utf8;'
+  - psql -c "create database patchwork with ENCODING = 'UTF8';" -U postgres
 
 install:
   - pip install tox-travis
-- 
2.11.0