tag:help.appveyor.com,2012-11-13:/discussions/problems/11031-postgresql-10-service-not-starting
AppVeyor: Discussion
2018-08-25T02:26:07Z
tag:help.appveyor.com,2012-11-13:Comment/44475803
2018-01-09T23:49:23Z
2018-01-10T00:10:19Z
PostgreSQL 10 service not starting
<div><p>This build <a href="https://ci.appveyor.com/project/cpcloud/ibis/build/1.0.934/job/a33pu89g0670loel">https://ci.appveyor.com/project/cpcloud/ibis/build/1.0.934/job/a33p...</a> shows a connection refused error when trying to run a command with psql. Here's my yaml file:</p>
<pre>
<code>build: off
platform:
- x64
environment:
PGUSER: "postgres"
PGPASSWORD: "Password12!"
PGPORT: 5432
PGHOST: "localhost"
IBIS_TEST_DOWNLOAD_DIRECTORY: "%USERPROFILE%"
IBIS_TEST_DOWNLOAD_BASE_URL: "https://storage.googleapis.com/ibis-ci-data"
IBIS_TEST_DOWNLOAD_NAME: "ibis-testing-data.tar.gz"
IBIS_TEST_DATA_DIRECTORY: "%USERPROFILE%\\ibis-testing-data"
IBIS_TEST_POSTGRES_USER: "%PGUSER%"
IBIS_TEST_POSTGRES_PASSWORD: "%PGPASSWORD%"
IBIS_TEST_POSTGRES_PORT: "%PGPORT%"
IBIS_TEST_POSTGRES_HOST: "%PGHOST%"
IBIS_TEST_POSTGRES_DATABASE: "ibis_testing"
IBIS_TEST_SQLITE_DATABASE: "%USERPROFILE%\\ibis_testing.db"
CONDA: "C:\\Miniconda36-x64\\Scripts\\conda"
ACTIVATE: "C:\\Miniconda36-x64\\Scripts\\activate"
matrix:
- PYTHON_VERSION: "2.7"
- PYTHON_VERSION: "3.4"
- PYTHON_VERSION: "3.5"
- PYTHON_VERSION: "3.6"
services:
- postgresql10
test_script:
- "\"C:\\Program Files\\PostgreSQL\\10\\bin\\psql\" --version"
- "\"C:\\Program Files\\PostgreSQL\\10\\bin\\psql\" -c \"SELECT 1\""
- "%CONDA% --version"
- "%CONDA% config --set always_yes true"
- "%CONDA% install conda=4.3.22 --channel conda-forge"
- "%CONDA% create --name \"ibis_%PYTHON_VERSION%\" python=%PYTHON_VERSION% --channel conda-forge"
- "%ACTIVATE% \"ibis_%PYTHON_VERSION%\""
- "%CONDA% install pytables"
- "pip install -e .\"[sqlite, postgres, visualization, pandas, csv, hdf5]\""
- "pip install flake8 mock pytest click \"pbs==0.110\""
- "flake8"
- "python testing\\datamgr.py download"
- "python testing\\datamgr.py sqlite"
- "python testing\\datamgr.py postgres"
- "pytest --tb=short -m \"not impala and not hdfs\" ibis"</code>
</pre>
<p>I was able to fix this by running <code>net start postgresql-x64-10</code> in my <code>test_script</code> section. This seems like a bug. I was under the impression that if I declare <code>postgresql10</code> in <code>services</code> then this service is automatically started before the command in <code>test_script</code> are run.</p></div>
cpcloud
tag:help.appveyor.com,2012-11-13:Comment/44475803
2018-01-10T06:24:42Z
2018-01-10T06:24:42Z
PostgreSQL 10 service not starting
<div><p>Thank you for the finding! Please use <code>services: postgresql101</code> (<code>101</code> instead of <code>10</code>). <a href="https://github.com/appveyor/website/pull/406">Fixing documentation</a> now.</p></div>
Ilya Finkelshteyn