Table of Contents

This page describes the steps used to set up the Npgsql build server.

If you're upgrading the TeamCity version, see "Give agent service start/stop permissions" below.

Install all supported versions of the Postgresql backend

At the time of writing, this means 9.1, 9.2, 9.3, 9.4, 9.5. They are configured on ports 5491, 5492, 5493, 5494, 5495.

For SSPI/GSS tests, you need to set up a user with the same name as the user that will be running the tests (i.e. teamcity_agent). You must also add the following lines at the top of each PG's pg_hba.conf to set up SSPI/GSS for that user:

host    all             teamcity_agent  127.0.0.1/32            sspi  include_realm=0
host    all             teamcity_agent  ::1/128                 sspi  include_realm=0

See this page on SSPI.

Install a TeamCity-dedicated Postgresql cluster

TeamCity itself requires an SQL database, but we don't want it to run in the same environment as that used for the unit tests. So choosing the latest stable Postgresql version (9.6 at time of writing), we create a new Postgresql cluster: initdb -U postgres -W c:\dev\TeamcityPostgresData

Next we set up a Windows service that starts up the new cluster: pg_ctl register -N postgresql-9.6-teamcity -U teamcity -P <password> -D c:\dev\TeamcityPostgresData

Finally, create a a user and database and point TeamCity to it.

Install .NET SDKs for all supported .NET versions

While installing the SDK for .NET 4.0, I had this problem: http://support.microsoft.com/kb/2717426

Give agent service start/stop permissions

When upgrading TeamCity, the agent needs to be able to stop and start the Windows service. This is how you can grant a normal user specific permissions on specific services:

Update build status back in github

  • Download the plugin from https://github.com/jonnyzzz/TeamCity.GitHub, get the ZIP
  • Drop the ZIP in the TeamCity content dir's plugins subdir
  • Add the Build Feature "Report change status to GitHub". Configure everything appropriately, and be sure the user you set up has push access to the repository!

Install assorted dev utilities

  • GitVersion (with Chocolatey)
  • WiX toolset (v3.10.1 at time of writing)

Install WiX

WiX 3.10 has a dependency on .NET Framework 3.5, but there's some issue blocking its installation on Windows Server 2012 R2 (at least on Azure). A good workaround is to simply install via Powershell (Add-WindowsFeature NET-Framework-Core), see https://msdn.microsoft.com/en-us/library/dn169001(v=nav.70).aspx#InstallNET35.

Note that ICE validation is disabled because apparently it requires an interactive account or admin privileges, which doesn't work in continuous integration.

Edit this page