tag:help.appveyor.com,2012-11-13:/discussions/questions/60488-postgresql-versionAppVeyor: Discussion 2022-11-30T12:17:53Ztag:help.appveyor.com,2012-11-13:Comment/566906422022-11-09T18:09:19Z2022-11-09T18:09:19ZPostgreSQL version<div><p>Working on the update!</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/566906422022-11-11T16:32:48Z2022-11-11T16:32:48ZPostgreSQL version<div><p>The latest versions of PostgreSQL 14 and 15 have been added to "Visual Studio 2022" image. Other versions bumped.<br>
<a href="https://www.appveyor.com/updates/2022/11/11/">https://www.appveyor.com/updates/2022/11/11/</a></p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/566906422022-11-12T10:21:29Z2022-11-12T10:21:30ZPostgreSQL version<div><p>Thanks for the update. I'm trying to use PostgreSQL v15 on the updated Visual Studio 2022 image, but I can't access it from unit tests:<br></p>
<pre>
<code>[00:15:21] Starting test execution, please wait...
[00:15:21] A total of 1 test files matched the specified pattern.
[00:15:34] [xUnit.net 00:00:09.28] NoEntityFrameworkTests.WorkItemTests.Can_delete_WorkItem [FAIL]
[00:15:34] Failed NoEntityFrameworkTests.WorkItemTests.Can_delete_WorkItem [5 s]
[00:15:34] Error Message:
[00:15:34] Npgsql.NpgsqlException : Failed to connect to 127.0.0.1:5432
[00:15:34] ---- System.Net.Sockets.SocketException : No connection could be made because the target machine actively refused it.</code>
</pre>
My PR is at <a href="https://github.com/json-api-dotnet/JsonApiDotNetCore/pull/1215/files">https://github.com/json-api-dotnet/JsonApiDotNetCore/pull/1215/files</a> and build output at <a href="https://ci.appveyor.com/project/json-api-dotnet/jsonapidotnetcore/builds/45360825/job/gav7djejbfutf0xs">https://ci.appveyor.com/project/json-api-dotnet/jsonapidotnetcore/b...</a>, in case it helps.</div>Bart Koelmantag:help.appveyor.com,2012-11-13:Comment/566906422022-11-14T02:34:03Z2022-11-14T02:34:03ZPostgreSQL version<div><p>AppVeyor Build Agent does not yet support PostgreSQL 15. You have to explicitly start its service somewhere before tests:</p>
<pre>
<code>install:
- net start postgresql-x64-15</code>
</pre></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/566906422022-11-15T07:21:34Z2022-11-15T07:21:38ZPostgreSQL version<div><p>It's working great now, thanks for your help!</p></div>Bart Koelmantag:help.appveyor.com,2012-11-13:Comment/566906422022-11-30T10:09:36Z2022-11-30T10:09:37ZPostgreSQL version<div><p>This worked 16 days ago (with the added <code>net start</code> command), but I noticed it started failing again at least 4 days from now. We didn't make any changes. Any idea what's causing the failure?</p></div>Bart Koelmantag:help.appveyor.com,2012-11-13:Comment/566906422022-11-30T12:17:50Z2022-11-30T12:17:53ZPostgreSQL version<div><p>Please ignore my last message, it's working again. I suspect we experienced timeouts due to busy servers.</p></div>Bart Koelman