psql ODBC CI - #121
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: MSBuild | |
| run-name: psql ODBC CI - ${{ github.event.head_commit.message }} | |
| on: | |
| push: | |
| branches: [ "main" ] | |
| tags: | |
| - 'REL-*' | |
| - '!REL-*-mimalloc' | |
| pull_request: | |
| branches: [ "main" ] | |
| env: | |
| # Path to the solution file relative to the root of the project. | |
| SOLUTION_FILE_PATH: . | |
| # Configuration type to build. | |
| # You can convert this to a build matrix if you need coverage of multiple configuration types. | |
| # https://docs.github.com/actions/learn-github-actions/managing-complex-workflows#using-a-build-matrix | |
| BUILD_CONFIGURATION: Release | |
| # Workflow versions. Increment these when you make changes to a build step in the workflow and | |
| # you want the step to run, but the corresponding cache is causing the step to be skipped. | |
| WORKFLOW_VERSION_POSTGRESQL: '1' # for build steps related to the 'cachePostgres' cache | |
| # Software versions. | |
| POSTGRESQL_SOURCE_TAG: 'REL_17_BETA3' | |
| POSTGRESQL_PACKAGE_FILEID: '1259019' | |
| OPENSSL_VERSION: '3.3.1' | |
| PKGCONFIGLITE_VERSION: '0.28-1' | |
| WINFLEXBISON_VERSION: '2.5.24' | |
| DIFFUTILS_VERSION: '2.8.7-1' | |
| permissions: | |
| contents: read | |
| jobs: | |
| build_and_test: | |
| runs-on: windows-latest | |
| steps: | |
| - name: Cache Postgres build output | |
| uses: actions/cache@v4 | |
| id: cachePostgres | |
| with: | |
| path: | | |
| d:\postgresql | |
| d:\postgresql86 | |
| key: postgresql-${{env.POSTGRESQL_SOURCE_TAG}}_openssl-${{env.OPENSSL_VERSION}}_pkgconfiglite-${{env.PKGCONFIGLITE_VERSION}}_winflexbison-${{env.WINFLEXBISON_VERSION}}_workflow-${{env.WORKFLOW_VERSION_POSTGRESQL}} | |
| - name: Cache Postgres source | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: actions/cache@v4 | |
| id: cachePostgresSource | |
| with: | |
| path: postgres | |
| key: postgres-source-${{env.POSTGRESQL_SOURCE_TAG}} | |
| - name: Get Postgres source | |
| uses: actions/checkout@v4 | |
| if: ${{steps.cachePostgresSource.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| with: | |
| repository: "postgres/postgres.git" | |
| ref: ${{env.POSTGRESQL_SOURCE_TAG}} | |
| path: postgres | |
| - name: 'get meson' | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| run: | | |
| python -m pip install meson | |
| python -m pip install ninja | |
| - name: Cache GNU diffutils for Test on PostgreSQL for Windows | |
| uses: actions/cache@v4 | |
| id: cacheDiffutilsZip | |
| with: | |
| path: C:\OTHERBIN\diffutils | |
| key: diff_utils-${{env.DIFFUTILS_VERSION}} | |
| env: | |
| SEGMENT_DOWNLOAD_TIMEOUT_MINS: 1 | |
| - name: Cache PostgreSQL installer | |
| uses: actions/cache@v4 | |
| id: cachePostgresInstaller | |
| with: | |
| path: C:\OTHERBIN\postgresql_install.exe | |
| key: postgresql_installer-${{env.POSTGRESQL_PACKAGE_FILEID}} | |
| - name: Cache pkgconfiglite for Compile using msvc and meson | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: actions/cache@v4 | |
| id: cachePkgConfigLiteZip | |
| with: | |
| path: C:\OTHERBIN\pkgconfiglite | |
| key: pkg-config-lite-${{env.PKGCONFIGLITE_VERSION}}-win32 | |
| env: | |
| SEGMENT_DOWNLOAD_TIMEOUT_MINS: 1 | |
| - name: Cache OpenSSL | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: actions/cache@v4 | |
| id: cacheOpenSSL | |
| with: | |
| path: C:\OTHERBIN\openssl64 | |
| key: OpenSSL-${{env.OPENSSL_VERSION}} | |
| - name: Cache winflexbison for Compile using msvc | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: actions/cache@v4 | |
| id: cacheWinFlexBisonZip | |
| with: | |
| path: C:\OTHERBIN\winflexbison | |
| key: winflexbison-${{env.WINFLEXBISON_VERSION}} | |
| env: | |
| SEGMENT_DOWNLOAD_TIMEOUT_MINS: 1 | |
| - name: Download GNU diffutils for Test on PostgreSQL for Windows | |
| if: ${{steps.cacheDiffutilsZip.outputs.cache-hit != 'true'}} | |
| uses: suisei-cn/[email protected] | |
| id: downloadDiffutilsZip | |
| with: | |
| retry-times: 5 | |
| url: https://zenlayer.dl.sourceforge.net/project/gnuwin32/diffutils/${{env.DIFFUTILS_VERSION}}/diffutils-${{env.DIFFUTILS_VERSION}}-bin.zip | |
| filename: diffutils-bin.zip | |
| - name: Download openssl source | |
| if: ${{steps.cacheOpenSSL.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: suisei-cn/[email protected] | |
| id: downloadOpenSSL | |
| with: | |
| retry-times: 5 | |
| url: https://www.openssl.org/source/openssl-${{env.OPENSSL_VERSION}}.tar.gz | |
| filename: openssl-${{ env.OPENSSL_VERSION }}.tar.gz | |
| - name: Configure OpenSSL | |
| if: success() | |
| run: | | |
| tar xzvf openssl-${{ env.OPENSSL_VERSION }}.tar.gz | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| perl Configure VC-WIN64A no-asm --prefix=C:\OTHERBIN\openssl64 no-ssl3 no-comp | |
| - name: setup msvc 64 | |
| uses: TheMrMilchmann/setup-msvc-dev@v3 | |
| with: | |
| arch: x64 | |
| - name: build openssl 64 | |
| run: | | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| nmake | |
| - name: install openssl 64 | |
| run: | | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| mkdir c:\OTHERBIN\openssl64 | |
| nmake install | |
| - name: Create openssl64 pkgconfig File | |
| shell: cmd | |
| run: | | |
| mkdir \c:\OTHERBIN\openssl64\lib\pkgconfig | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo prefix=${pcfiledir}/../.. | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo exec_prefix=${prefix} | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo libdir=${prefix}/lib | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo includedir=${prefix}/include | |
| >> c:\OTHERBIN\openssl64lib\pkgconfig\openssl.pc echo. | |
| >> c:\OTHERBIN\openssl64lib\pkgconfig\openssl.pc echo Name: openssl | |
| >> c:\OTHERBIN\openssl64lib\pkgconfig\openssl.pc echo Description: openssl encryption library | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo Version: ${{ env.OPENSSL_VERSION }} | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo Libs: -L${libdir} -lcrypto -lssl | |
| >> c:\OTHERBIN\openssl64\lib\pkgconfig\openssl.pc echo Cflags: -I${includedir} | |
| - name: setup msvc 86 | |
| uses: TheMrMilchmann/setup-msvc-dev@v3 | |
| with: | |
| arch: x86 | |
| - name: configure openssl 32 | |
| run: | | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| nmake clean | |
| perl Configure VC-WIN32 no-asm --prefix=C:\OTHERBIN\openssl32 no-ssl3 no-comp | |
| - name: build openssl 32 | |
| run: | | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| nmake | |
| - name: install openssl 32 | |
| run: | | |
| cd openssl-${{ env.OPENSSL_VERSION }} | |
| mkdir c:\OTHERBIN\openssl32 | |
| nmake install | |
| - name: Create openssl32 pkgconfig File | |
| shell: cmd | |
| run: | | |
| mkdir \c:\OTHERBIN\openssl32\lib\pkgconfig | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo prefix=${pcfiledir}/../.. | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo exec_prefix=${prefix} | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo libdir=${prefix}/lib | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo includedir=${prefix}/include | |
| >> c:\OTHERBIN\openssl32lib\pkgconfig\openssl.pc echo. | |
| >> c:\OTHERBIN\openssl32lib\pkgconfig\openssl.pc echo Name: openssl | |
| >> c:\OTHERBIN\openssl32lib\pkgconfig\openssl.pc echo Description: openssl encryption library | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo Version: ${{ env.OPENSSL_VERSION }} | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo Libs: -L${libdir} -lcrypto -lssl | |
| >> c:\OTHERBIN\openssl32\lib\pkgconfig\openssl.pc echo Cflags: -I${includedir} | |
| - name: Download pkgconfiglite for Compile using msvc and meson | |
| if: ${{steps.cachePkgConfigLiteZip.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: suisei-cn/[email protected] | |
| id: downloadPkgConfigLiteZip | |
| with: | |
| retry-times: 5 | |
| url: http://downloads.sourceforge.net/project/pkgconfiglite/${{env.PKGCONFIGLITE_VERSION}}/pkg-config-lite-${{env.PKGCONFIGLITE_VERSION}}_bin-win32.zip | |
| filename: pkg-config-lite_bin-win32.zip | |
| - name: Download winflexbison for Compile using msvc | |
| if: ${{steps.cacheWinFlexBisonZip.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: suisei-cn/[email protected] | |
| id: downloadWinFlexBisonZip | |
| with: | |
| retry-times: 5 | |
| url: https://sourceforge.net/projects/winflexbison/files/win_flex_bison-${{env.WINFLEXBISON_VERSION}}.zip | |
| filename: win_flex_bison.zip | |
| - name: Download postgresql install from EDB | |
| uses: suisei-cn/[email protected] | |
| if: ${{steps.cachePostgresInstaller.outputs.cache-hit != 'true'}} | |
| id: downloadPostgresInstaller | |
| with: | |
| retry-times: 5 | |
| url: https://sbp.enterprisedb.com/getfile.jsp?fileid=${{env.POSTGRESQL_PACKAGE_FILEID}} | |
| target: c:\OTHERBIN | |
| filename: postgresql_install.exe | |
| - name: Extract Diffutils for Test on PostgreSQL for Windows | |
| if: ${{steps.cacheDiffutilsZip.outputs.cache-hit != 'true'}} | |
| shell: cmd | |
| run: | | |
| rem MKDIR creates any intermediate directories in the path, if needed. | |
| mkdir "C:\OTHERBIN\diffutils" | |
| rem 7z is provided by Github Actions | |
| 7z x diffutils-bin.zip -o"C:\OTHERBIN\diffutils" | |
| - name: Add Diffutils bin directory to the PATH for Test on PostgreSQL for Windows | |
| shell: cmd | |
| run: | | |
| rem - man7.org/linux/man-pages/man1/printf.1.html | |
| printf "C:\\OTHERBIN\\diffutils\\bin" >> %GITHUB_PATH% | |
| - name: Extract pkgconfiglite for Compile using msvc and meson | |
| if: ${{steps.cachePkgConfigLiteZip.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| shell: cmd | |
| run: | | |
| rem MKDIR creates any intermediate directories in the path, if needed. | |
| mkdir "C:\OTHERBIN\pkgconfiglite" | |
| rem 7z is provided by Github Actions | |
| 7z x pkg-config-lite_bin-win32.zip -o"C:\OTHERBIN\pkgconfiglite" | |
| - name: Add pkgconfiglite bin directory to the PATH for Compile using msvc and meson | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| shell: cmd | |
| run: | | |
| rem - man7.org/linux/man-pages/man1/printf.1.html | |
| printf "C:\\OTHERBIN\\pkgconfiglite\\pkg-config-lite-%PKGCONFIGLITE_VERSION%\\bin" >> %GITHUB_PATH% | |
| # Choco Install winflexbison | |
| # BUT the "crazy-max/ghaction-chocolatey@v2" "install pkgconfiglite" file download often times-out | |
| - name: Extract winflexbison for Compile using msvc | |
| if: ${{steps.cacheWinFlexBisonZip.outputs.cache-hit != 'true' && steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| shell: cmd | |
| run: | | |
| rem MKDIR creates any intermediate directories in the path, if needed. | |
| mkdir "C:\OTHERBIN\winflexbison" | |
| rem 7z is provided by Github Actions | |
| 7z x win_flex_bison.zip -o"C:\OTHERBIN\winflexbison" | |
| - name: Add the winflexbison directory to the PATH for Compile using msvc | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| shell: cmd | |
| run: | | |
| rem - man7.org/linux/man-pages/man1/printf.1.html | |
| printf "C:\OTHERBIN\\winflexbison" >> %GITHUB_PATH% | |
| - name: 'setup msvc x86' | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: TheMrMilchmann/setup-msvc-dev@v3 | |
| with: | |
| arch: x86 | |
| - name: 'build postgresx86' | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| working-directory: postgres | |
| run: | | |
| meson setup --wipe buildx86 -Dssl=openssl -Dextra_lib_dirs=c:\OTHERBIN\openssl32\lib -Dextra_include_dirs=c:\OTHERBIN\openssl32\include --prefix=d:\postgresql86 | |
| cd buildx86 | |
| ninja -v | |
| ninja -v install | |
| cp c:\OTHERBIN\openssl32\*.dll d:\postgresql86\bin | |
| - name: 'setup msvc x64' | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| uses: TheMrMilchmann/setup-msvc-dev@v3 | |
| with: | |
| arch: x64 | |
| - name : 'build postgres x64' | |
| if: ${{steps.cachePostgres.outputs.cache-hit != 'true'}} | |
| working-directory: postgres | |
| run: | | |
| meson setup build -Dssl=openssl -Dextra_lib_dirs=c:\OTHERBIN\openssl64\lib -Dextra_include_dirs=c:\OTHERBIN\openssl64\include --prefix=d:\postgresql | |
| cd build | |
| ninja | |
| ninja install | |
| cp c:\OTHERBIN\openssl64\*.dll d:\postgresql\bin | |
| - name: install postgresql binary | |
| shell: cmd | |
| run: | | |
| echo on | |
| C:\OTHERBIN\postgresql_install.exe --mode unattended --unattendedmodeui none --superpassword password --enable-components server | |
| - name: start postgresql | |
| shell: cmd | |
| run: | | |
| echo on | |
| sc config "postgresql-x64-14" start= auto | |
| - name: get psqlodbc | |
| uses: actions/checkout@v4 | |
| with: | |
| path: psqlodbc | |
| submodules: true | |
| - name: 'setup msvc for psqlodbc' | |
| uses: TheMrMilchmann/setup-msvc-dev@v3 | |
| with: | |
| arch: x86 | |
| - name: build psqlodbc standard | |
| shell: powershell | |
| working-directory: psqlodbc | |
| run: | | |
| copy .github\workflows\configuration.xml winbuild | |
| winbuild\BuildAll.ps1 | |
| installer\buildInstallers.ps1 | |
| env: | |
| PSQLODBC_OBJBASE: ${{ github.workspace }}\psqlodbc\winbuild\standard | |
| - name: test psqlodbc standard | |
| shell: powershell | |
| working-directory: psqlodbc | |
| run: | | |
| winbuild\regress.ps1 -DsnInfo "SERVER=localhost|DATABASE=contrib_regression|PORT=5432|UID=postgres|PWD=password" | |
| standard\test_x86\RegisterRegdsn.exe uninstall_driver postgres_devw | |
| standard\test_x64\RegisterRegdsn.exe uninstall_driver postgres_devw | |
| env: | |
| PSQLODBC_OBJBASE: ${{ github.workspace }}\psqlodbc\winbuild\standard | |
| - name: build psqlodbc mimalloc | |
| shell: powershell | |
| working-directory: psqlodbc | |
| run: | | |
| copy .github\workflows\configuration.xml winbuild | |
| winbuild\BuildAll.ps1 -UseMimalloc | |
| installer\buildInstallers.ps1 | |
| env: | |
| PSQLODBC_OBJBASE: ${{ github.workspace }}\psqlodbc\winbuild\mimalloc | |
| - name: test psqlodbc mimalloc | |
| shell: powershell | |
| working-directory: psqlodbc | |
| run: | | |
| winbuild\regress.ps1 -DsnInfo "SERVER=localhost|DATABASE=contrib_regression|PORT=5432|UID=postgres|PWD=password" -ExpectMimalloc | |
| mimalloc\test_x86\RegisterRegdsn.exe uninstall_driver postgres_devw | |
| mimalloc\test_x64\RegisterRegdsn.exe uninstall_driver postgres_devw | |
| env: | |
| PSQLODBC_OBJBASE: ${{ github.workspace }}\psqlodbc\winbuild\mimalloc | |
| - name: Upload standard x64 merge module | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC Standard x64 Merge Module | |
| path: psqlodbc/winbuild/standard/installer/x64/*.msm | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload standard x64 installer package | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC Standard x64 Installer | |
| path: psqlodbc/winbuild/standard/installer/x64/*.msi | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload standard x86 merge module | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC Standard x86 Merge Module | |
| path: psqlodbc/winbuild/standard/installer/x86/*.msm | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload standard x86 installer package | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC Standard x86 Installer | |
| path: psqlodbc/winbuild/standard/installer/x86/*.msi | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload standard x64 setup | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC Standard x64 Setup | |
| path: psqlodbc/winbuild/standard/installer/psqlodbc-setup/bin/Release/psqlodbc-setup.exe | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload mimalloc x64 merge module | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC mimalloc x64 Merge Module | |
| path: psqlodbc/winbuild/mimalloc/installer/x64/*.msm | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload mimalloc x64 installer package | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC mimalloc x64 Installer | |
| path: psqlodbc/winbuild/mimalloc/installer/x64/*.msi | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload mimalloc x86 merge module | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC mimalloc x86 Merge Module | |
| path: psqlodbc/winbuild/mimalloc/installer/x86/*.msm | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload mimalloc x86 installer package | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC mimalloc x86 Installer | |
| path: psqlodbc/winbuild/mimalloc/installer/x86/*.msi | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Upload mimalloc x64 setup | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: psqlODBC mimalloc x64 Setup | |
| path: psqlodbc/winbuild/mimalloc/installer/psqlodbc-setup/bin/Release/psqlodbc-setup.exe | |
| retention-days: 5 | |
| if-no-files-found: error | |
| - name: Create mimalloc Release | |
| if: startsWith(github.ref, 'refs/tags/REL-') | |
| uses: ncipollo/[email protected] | |
| id: create_mimalloc_release | |
| with: | |
| tag: ${{github.ref_name}}-mimalloc | |
| commit: ${{github.sha}} | |
| body: A build of ${{github.ref_name}} that uses the mimalloc allocator for improved performance. | |
| makeLatest: false | |
| draft: false | |
| prerelease: false | |
| token: ${{secrets.RELEASE_TOKEN}} | |
| artifacts: "psqlodbc/winbuild/mimalloc/installer/x64/*.ms?,psqlodbc/winbuild/mimalloc/installer/x86/*.ms?,psqlodbc/winbuild/mimalloc/installer/psqlodbc-setup/bin/Release/psqlodbc-setup.exe" | |
| - name: Create Standard Release | |
| if: startsWith(github.ref, 'refs/tags/REL-') | |
| uses: ncipollo/[email protected] | |
| id: create_standard_release | |
| with: | |
| makeLatest: true | |
| draft: false | |
| prerelease: false | |
| token: ${{secrets.RELEASE_TOKEN}} | |
| artifacts: "psqlodbc/winbuild/standard/installer/x64/*.ms?,psqlodbc/winbuild/standard/installer/x86/*.ms?,psqlodbc/winbuild/standard/installer/psqlodbc-setup/bin/Release/psqlodbc-setup.exe" |