[PATCH v2 1/3] travis: test against postgresql 10 and 11

[Daniel Axtens]

> The above has started failing in recent days [1], likely coinciding
> with the full release of 11 [2]. I've tried but I can't figure out how
> to work around this issue easily. Any chance you could take a look,
> Daniel (either one :))?

Ergh, it seems travis is doing something *really* weird. If I apt-get
remove --purge postgres{,-client}-9.{2,3,4,5,6} and then install
postgres{-client,}-11, I get:

...
Setting up postgresql-common (195.pgdg14.04+1) ...
PostgreSQL 9.2 is not installed!
invoke-rc.d: initscript postgresql, action "start" failed.
dpkg: error processing package postgresql-common (--configure):
 subprocess installed post-installation script returned error exit status 31
dpkg: dependency problems prevent configuration of postgresql-11:
 postgresql-11 depends on postgresql-common (>= 194~); however:
  Package postgresql-common is not configured yet.

195.pgdg14.04+1 is the new version, unpacked over 188...

(See https://travis-ci.org/daxtens/patchwork/jobs/447406512 )

I can get a bit further if I also purge postgresql{-client,}-common
(suggesting very much that Travis is monkeying with it) but then the
server seems to ignore PGPORT and I fail on the next step.

(See https://travis-ci.org/daxtens/patchwork/jobs/447409745 )

Stephen: I'd say we can just disable this until it gets fixed if you
want. You have my blessing to merge that without further ado if you'd
like.

Regards,
Daniel


>
> Stephen
>
> [1] https://travis-ci.org/getpatchwork/patchwork/jobs/446606222
> [2] https://www.postgresql.org/about/news/1894/
>
>> +
>> +
>>  before_script:
>> -  - mysql -e 'create database patchwork character set utf8;'
>> -  - psql -c "create database patchwork with ENCODING = 'UTF8';" -U postgres
>> +  - if [[ $PW_TEST_DB_TYPE == mysql ]]; then mysql -e 'create database patchwork character set utf8;'; fi
>> +  - if [[ $PW_TEST_DB_TYPE == postgres ]]; then psql -c "create database patchwork with ENCODING = 'UTF8';" -U $PW_TEST_DB_USER; fi
>>  
>>  install:
>>    - pip install tox-travis
>>  
>>  script:
>> +  - >
>> +    if [[ $PW_TEST_DB_TYPE == mysql ]];
>> +    then
>> +      mysql -e 'SELECT VERSION(), CURRENT_USER();' -u $PW_TEST_DB_USER patchwork;
>> +    else
>> +      psql -c "SELECT VERSION(), CURRENT_USER, current_database()" -U $PW_TEST_DB_USER patchwork;
>> +    fi
>>    - tox
>>    - tox -e coverage
>>  
>
>
> _______________________________________________
> Patchwork mailing list
> Patchwork at lists.ozlabs.org
> https://lists.ozlabs.org/listinfo/patchwork