Home → Suggestions →

PostgreSQL for testing purposes

• Edit

mzabani

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,
Marcelo.

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

   

   Hi Marcelo,

   Are you looking for supporting the latest PostgreSQL version from here: http://www.enterprisedb.com/products-services-training/pgdownload#w... ?

   • Edit

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

   

   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.

   • Edit

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

   

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

   -Feodor

   • Edit

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

   

   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?

   • Edit

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

   

   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.

   • Edit

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

   

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

   Thank you again,
   Marcleo.

   • Edit

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

   

   OK, both PostgreSQL and MySQL have been added to build workers: http://www.appveyor.com/docs/services-databases#mysql

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

   services:
     - mysql
     - postgresql
   

   • Edit

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

   

   Thank you very much for such a quick feature implementation!

   • Edit

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