PG -156: replace query placeholders with actual arguments for prepared statements #728
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: postgresql-14-build | |
| on: | |
| pull_request: | |
| push: | |
| branches: | |
| - main | |
| tags: | |
| - '[0-9]+.[0-9]+.[0-9]+*' | |
| jobs: | |
| build: | |
| name: pg-14-build-test | |
| runs-on: ubuntu-22.04 | |
| timeout-minutes: 30 | |
| steps: | |
| - name: Clone postgres repository | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: 'postgres/postgres' | |
| ref: 'REL_14_STABLE' | |
| - name: Install dependencies | |
| run: | | |
| sudo apt-get update | |
| sudo apt purge postgresql-client-common postgresql-common \ | |
| postgresql postgresql* | |
| sudo apt-get install -y libreadline6-dev systemtap-sdt-dev \ | |
| zlib1g-dev libssl-dev libpam0g-dev bison flex \ | |
| libipc-run-perl -y docbook-xsl docbook-xsl libxml2 libxml2-utils \ | |
| libxml2-dev libxslt-dev xsltproc libkrb5-dev libldap2-dev \ | |
| libsystemd-dev gettext tcl-dev libperl-dev pkg-config clang-11 \ | |
| llvm-11 llvm-11-dev libselinux1-dev python3-dev \ | |
| uuid-dev liblz4-dev | |
| sudo rm -rf /var/lib/postgresql /var/log/postgresql /etc/postgresql \ | |
| /usr/lib/postgresql /usr/include/postgresql /usr/share/postgresql \ | |
| /etc/postgresql | |
| sudo rm -f /usr/bin/pg_config | |
| sudo /usr/bin/perl -MCPAN -e 'install IPC::Run' | |
| sudo /usr/bin/perl -MCPAN -e 'install Text::Trim' | |
| - name: Create pgsql dir | |
| run: mkdir -p /opt/pgsql | |
| - name: Build postgres | |
| run: | | |
| export PATH="/opt/pgsql/bin:$PATH" | |
| ./configure '--build=x86_64-linux-gnu' '--prefix=/usr' \ | |
| '--includedir=${prefix}/include' '--mandir=${prefix}/share/man' \ | |
| '--infodir=${prefix}/share/info' '--sysconfdir=/etc' \ | |
| '--localstatedir=/var' '--libdir=${prefix}/lib/x86_64-linux-gnu' \ | |
| '--libexecdir=${prefix}/lib/x86_64-linux-gnu' '--with-icu' \ | |
| '--with-tcl' '--with-perl' '--with-python' '--with-pam' \ | |
| '--with-openssl' '--with-libxml' '--with-libxslt' '--with-ldap' \ | |
| 'PYTHON=/usr/bin/python3' '--mandir=/usr/share/postgresql/14/man' \ | |
| '--docdir=/usr/share/doc/postgresql-doc-14' '--with-pgport=5432' \ | |
| '--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share' \ | |
| '--datadir=/usr/share/postgresql/14' '--with-uuid=e2fs' \ | |
| '--bindir=/usr/lib/postgresql/14/bin' '--enable-tap-tests' \ | |
| '--libdir=/usr/lib/x86_64-linux-gnu' '--enable-debug' \ | |
| '--libexecdir=/usr/lib/postgresql' '--with-gnu-ld' \ | |
| '--includedir=/usr/include/postgresql' '--enable-dtrace' \ | |
| '--enable-nls' '--enable-thread-safety' '--disable-rpath' \ | |
| '--with-system-tzdata=/usr/share/zoneinfo' '--with-llvm' \ | |
| 'LLVM_CONFIG=/usr/bin/llvm-config-11' 'CLANG=/usr/bin/clang-11' \ | |
| '--with-systemd' '--with-selinux' 'MKDIR_P=/bin/mkdir -p' \ | |
| 'PROVE=/usr/bin/prove' 'TAR=/bin/tar' 'XSLTPROC=xsltproc --nonet' \ | |
| 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' \ | |
| 'build_alias=x86_64-linux-gnu' '--with-gssapi' \ | |
| 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2' \ | |
| 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer' \ | |
| 'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security' | |
| make world | |
| sudo make install-world | |
| - name: Start postgresql cluster | |
| run: | | |
| export PATH="/usr/lib/postgresql/14/bin:$PATH" | |
| sudo cp /usr/lib/postgresql/14/bin/pg_config /usr/bin | |
| initdb -D /opt/pgsql/data | |
| pg_ctl -D /opt/pgsql/data -l logfile start | |
| - name: Clone pg_stat_monitor repository | |
| uses: actions/checkout@v4 | |
| with: | |
| path: 'src/pg_stat_monitor' | |
| - name: Build pg_stat_monitor | |
| run: | | |
| make USE_PGXS=1 | |
| sudo make USE_PGXS=1 install | |
| working-directory: src/pg_stat_monitor | |
| - name: Configure and Restart Server | |
| run: | | |
| export PATH="/usr/lib/postgresql/14/bin:$PATH" | |
| pg_ctl -D /opt/pgsql/data -l logfile stop | |
| echo "shared_preload_libraries = 'pg_stat_monitor'" >> \ | |
| /opt/pgsql/data/postgresql.conf | |
| echo "compute_query_id = regress" >> /opt/pgsql/data/postgresql.conf | |
| pg_ctl -D /opt/pgsql/data -l logfile start | |
| working-directory: src/pg_stat_monitor | |
| - name: Start pg_stat_monitor_tests | |
| run: | | |
| make installcheck | |
| working-directory: src/pg_stat_monitor/ | |
| - name: Change dir permissions on fail | |
| if: ${{ failure() }} | |
| run: | | |
| sudo chmod -R ugo+rwx t | |
| sudo chmod -R ugo+rwx tmp_check | |
| exit 2 # regenerate error so that we can upload files in next step | |
| working-directory: src/pg_stat_monitor | |
| - name: Upload logs on fail | |
| if: ${{ failure() }} | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: Regressions diff and postgresql log | |
| path: | | |
| src/pg_stat_monitor/regression.diffs | |
| src/pg_stat_monitor/regression.out | |
| src/pg_stat_monitor/logfile | |
| src/pg_stat_monitor/t/results/ | |
| src/pg_stat_monitor/tmp_check/log/ | |
| !src/pg_stat_monitor/tmp_check/**/archives/* | |
| !src/pg_stat_monitor/tmp_check/**/backup/* | |
| !src/pg_stat_monitor/tmp_check/**/pgdata/* | |
| !src/pg_stat_monitor/tmp_check/**/archives/ | |
| !src/pg_stat_monitor/tmp_check/**/backup/ | |
| !src/pg_stat_monitor/tmp_check/**/pgdata/ | |
| if-no-files-found: warn | |
| retention-days: 3 | |
| - name: Start Server installcheck-world tests | |
| run: make installcheck-world | |
| - name: Report on installcheck-world test suites fail | |
| uses: actions/upload-artifact@v4 | |
| if: ${{ failure() }} | |
| with: | |
| name: Regressions output files of failed testsuite, and pg log | |
| path: | | |
| **/regression.diffs | |
| **/regression.out | |
| src/pg_stat_monitor/logfile | |
| retention-days: 3 |