Service versioning via web UI

Tom's Avatar

Tom

05 Jun, 2017 06:56 PM

Settings->Environment only has a pull down menu for services which default to the current version. If I want to specify a version (in this case, PostgreSQL v 9.3) is there a way to make this change via the Web UI? I know I can export the appveyor.yml and make the change there, but I prefer to do things via the UI.

  1. Support Staff 1 Posted by Feodor Fitsner on 07 Jun, 2017 05:46 PM

    Feodor Fitsner's Avatar

    You can just explicitly start Postgre 9.3 service by putting into Install script section:

    net start postgresql-x64-9.3
    

    or as PowerShell:

    Start-Service postgresql-x64-9.3
    
  2. 2 Posted by Tom on 07 Jun, 2017 06:01 PM

    Tom's Avatar

    Thank you for the reply Feodor! I tried adding the net start line to Environment-> Install Script (CMD). Now I see the error:
    net start postgresql-x64-9.3
    The service name is invalid.

  3. Support Staff 3 Posted by Feodor Fitsner on 07 Jun, 2017 06:25 PM

    Feodor Fitsner's Avatar

    Is it VS 2017 image? There is no PGSQL 9.3 on it.

  4. 4 Posted by Tom on 07 Jun, 2017 06:31 PM

    Tom's Avatar

    yes it is VS 2017. Can I install 9.3 on it?

  5. Support Staff 5 Posted by Feodor Fitsner on 07 Jun, 2017 06:44 PM

    Feodor Fitsner's Avatar

    You can install it during the build with the following script:

    Write-Host "Installing PostgreSQL 9.3..." -ForegroundColor Cyan
    
    Write-Host "Downloading..."
    # http://www.enterprisedb.com/products-services-training/pgdownload#windows
    $exePath = "$($env:USERPROFILE)\postgresql-9.3.10-1-windows-x64.exe"
    (New-Object Net.WebClient).DownloadFile('http://get.enterprisedb.com/postgresql/postgresql-9.3.10-1-windows-x64.exe', $exePath)
    
    Write-Host "Installing..."
    cmd /c start /wait $exePath --mode unattended --superpassword Password12!
    del $exePath
    
    Write-Host "PostgreSQL 9.3 installed" -ForegroundColor Green
    
  6. 6 Posted by Tom on 07 Jun, 2017 07:24 PM

    Tom's Avatar

    This script failed for me. I reverted to VS 2015. I'll have to revisit this at a later time

  7. 7 Posted by Ilya Finkelshte... on 07 Jun, 2017 07:51 PM

    Ilya Finkelshteyn's Avatar

    It is working script. Just tested it.

    Please ensure that you run it as PowerShell, not CMD.

  8. 8 Posted by Tom on 07 Jun, 2017 08:11 PM

    Tom's Avatar

    I already have CMD code I use, I started translating it but just don't have the time right now

  9. 9 Posted by Ilya Finkelshte... on 07 Jun, 2017 08:15 PM

    Ilya Finkelshteyn's Avatar

    you can wrap it into .ps1 file and call powershell <path_to_ps1> from CMD

  10. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:17 AM.

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

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