Home → Problems →

Postgresql 12

• Edit

w.n.bates

26 Nov, 2019 05:09 PM

We'd like to start using Postgresql 12 but it looks like the highest version on your VM's is still just V10?
I don't seem to be able to use Chocolatey to install it as it can't find the command line tools despite using chocolatey's refreshenv command and a couple of other different approaches.
Any plans to support the current version of Postgresql?
Any tips on how I can start using it now?

1. Support Staff 1 Posted by Feodor Fitsner on 27 Nov, 2019 12:03 AM

   

   I've created a new issue to install PostgreSQL 12 during the next update: https://github.com/appveyor/ci/issues/3223

   You can use the following PS snippet to install PostgreSQL 12 during the build:

   Write-Host "Downloading PostgreSQL 12.1..."
   $exePath = "$env:TEMP\postgresql-12.1-1-windows-x64.exe"
   (New-Object Net.WebClient).DownloadFile('https://get.enterprisedb.com/postgresql/postgresql-12.1-1-windows-x64.exe', $exePath)
   
   Write-Host "Installing..."
   cmd /c start /wait $exePath --mode unattended --install_runtimes 0 --superpassword Password12!
   
   Write-Host "PostgreSQL 12.1 installed" -ForegroundColor Green
   

   Takes around 2 mins to install.

   • Edit

2. 2 Posted by w.n.bates on 27 Nov, 2019 07:41 AM

   

   This doesn't work either. Appears to be the same problem. The shell can't find the command line tools e.g. psql

   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 27 Nov, 2019 05:13 PM

   

   To have psql in PATH just add this line to the end of the script:

   $env:path = "C:\Program Files\PostgreSQL\12\bin;$env:path"
   

   • Edit

4. 4 Posted by Michael Pendon on 18 Jan, 2020 12:49 PM

   

   Verified and this is working! Thanks

   Reminder: Remove the service PostgreSql in the AppVeyor.

   Write-Host "Temporary solution to install PostgreSql 12.1 (as recommended by Feodor Fitsner): https://help.appveyor.com/discussions/problems/25522-postgresql-12"
   Write-Host "Downloading PostgreSql 12.1..." -ForegroundColor Yellow
   $exePath = "$env:TEMP\postgresql-12.1-1-windows-x64.exe"
   (New-Object Net.WebClient).DownloadFile('https://get.enterprisedb.com/postgresql/postgresql-12.1-1-windows-x64.exe', $exePath)
   Write-Host "Installing PostgreSql 12.1..." -ForegroundColor Yellow
   cmd /c start /wait $exePath --mode unattended --install_runtimes 0 --superpassword Password12!
   Write-Host "PostgreSql 12.1 installed" -ForegroundColor Green
   $env:path = "C:\Program Files\PostgreSQL\12\bin;$env:path"
   

   • Edit