Postgres fails to connect after version change

Bart Koelman's Avatar

Bart Koelman

06 Sep, 2021 02:12 PM

The PR at https://github.com/json-api-dotnet/JsonApiDotNetCore/pull/1072 updates our cibuild to use the newest pre-installed version of postgres. This works on Linux. But on windows, our tests are no longer able to connect. See logs at https://ci.appveyor.com/project/json-api-dotnet/jsonapidotnetcore/builds/40659267/job/t9qu54y5p7qvdhpf.

Am I doing something wrong?

  1. Support Staff 1 Posted by Feodor Fitsner on 06 Sep, 2021 09:59 PM

    Feodor Fitsner's Avatar

    Postgre 13 is not yet implemented in a build agent, so start the service during the build with:

    init:
    - net start postgresql-x64-13
    
  2. 2 Posted by Bart Koelman on 07 Sep, 2021 07:11 AM

    Bart Koelman's Avatar

    Thanks, I'll give that a try.

    Is what you suggested a temporary workaround? I'm asking because I received an email from AppVeyor titled "Visual Studio 2019 image update on September 4, 2021", which lists "PostgreSQL 10.18, 11.13, 12.8, 13.4" in the What's New section. Because of that email, I created my PR to update versions.

  3. Support Staff 3 Posted by Feodor Fitsner on 07 Sep, 2021 02:22 PM

    Feodor Fitsner's Avatar

    PostgreSQL 13.4 is installed on VS 2019 workers, however, build agent is not yet updated to "understand" postgresql134 in services section.

  4. Support Staff 4 Posted by Feodor Fitsner on 13 Sep, 2021 12:32 AM

    Feodor Fitsner's Avatar

    An updated version of build agent has been deployed which allows starting Postgres 13 with:

    services:
    - postgresql13
    
  5. 5 Posted by Bart Koelman on 16 Sep, 2021 10:57 AM

    Bart Koelman's Avatar

    Works great, thanks!

    You may want to update the list at https://www.appveyor.com/docs/services-databases/#postgresql.

  6. Support Staff 6 Posted by Feodor Fitsner on 16 Sep, 2021 05:15 PM

    Feodor Fitsner's Avatar

    Sure, done.

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