PostgreSQL 10 service not starting

cpcloud's Avatar

cpcloud

09 Jan, 2018 11:49 PM

This build https://ci.appveyor.com/project/cpcloud/ibis/build/1.0.934/job/a33p... shows a connection refused error when trying to run a command with psql. Here's my yaml file:

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"

I was able to fix this by running net start postgresql-x64-10 in my test_script section. This seems like a bug. I was under the impression that if I declare postgresql10 in services then this service is automatically started before the command in test_script are run.

  1. Support Staff 1 Posted by Ilya Finkelshte... on 10 Jan, 2018 06:24 AM

    Ilya Finkelshteyn's Avatar

    Thank you for the finding! Please use services: postgresql101 (101 instead of 10). Fixing documentation now.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

 

18 Aug, 2018 11:54 AM
18 Aug, 2018 12:13 AM
17 Aug, 2018 06:02 PM
17 Aug, 2018 04:26 PM
17 Aug, 2018 04:04 PM
17 Aug, 2018 06:31 AM