PostgreSQL for testing purposes

mzabani's Avatar


27 Aug, 2014 06:07 PM

Hi everyone,

I've just started using AppVeyor, and it looks great! However, we have some specific tests that we run against a PostgreSQL database (because they are complex PostgreSQL-specific queries). Are there any plans to support PostgreSQL?

Thank you in advance,

  1. Support Staff 1 Posted by Feodor Fitsner on 27 Aug, 2014 10:38 PM

    Feodor Fitsner's Avatar

    Hi Marcelo,

    Are you looking for supporting the latest PostgreSQL version from here: ?

  2. 2 Posted by mzabani on 28 Aug, 2014 11:08 AM

    mzabani's Avatar

    Sorry if I don't understand the basics of this, it is my first time working with CI (and therefore with AppVeyor). Are you suggesting that there is a way to install this on AppVeyor's machines so that my tests can run? Or should I open my PostgreSQL server and have my tests' connection string set to that one?

    Thank you again.

  3. Support Staff 3 Posted by Feodor Fitsner on 28 Aug, 2014 02:27 PM

    Feodor Fitsner's Avatar

    I dont think installing PostgreSQL during the build is a good idea. I meant we can pre-install it to build worker image.


  4. 4 Posted by mzabani on 28 Aug, 2014 06:31 PM

    mzabani's Avatar

    Oh, good. We are indeed looking for PostgreSQL 9.3, which can be found in the link you provided. How would it work for our tests if you provided it to us the way you're saying (through a build worker image). I can see SQL Server services and how they would be used, but it seem that you're suggesting a different approach, right?

  5. Support Staff 5 Posted by Feodor Fitsner on 28 Aug, 2014 10:28 PM

    Feodor Fitsner's Avatar

    I'm looking into the same approach as for SQL Server, i.e. officially support PostgreSQL (and maybe MySQL) in services. Will add an item into TODO list.

  6. 6 Posted by mzabani on 29 Aug, 2014 01:25 PM

    mzabani's Avatar

    Sounds great! Are there any estimates for when this will be available?

    Thank you again,

  7. Support Staff 7 Posted by Feodor Fitsner on 31 Aug, 2014 05:44 PM

    Feodor Fitsner's Avatar

    OK, both PostgreSQL and MySQL have been added to build workers:

    Enable their services on Environment tab of project settings on in appveyor.yml:

      - mysql
      - postgresql
  8. 8 Posted by mzabani on 01 Sep, 2014 03:07 PM

    mzabani's Avatar

    Thank you very much for such a quick feature implementation!

  9. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:47 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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