Added how to create encrypted tables to github.io docs #122
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: postgresql-16-src-make-ssl11 | |
| on: [pull_request, workflow_dispatch] | |
| jobs: | |
| build: | |
| name: pg-16-src-make-test-ssl11 | |
| runs-on: ubuntu-20.04 | |
| steps: | |
| - name: Remove old postgres | |
| run: | | |
| sudo apt purge postgresql-client-common postgresql-common \ | |
| postgresql postgresql* | |
| 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 | |
| - name: Install dependencies | |
| run: | | |
| sudo apt-get update | |
| 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 \ | |
| libselinux1-dev python3-dev libhttp-server-simple-perl\ | |
| uuid-dev liblz4-dev libcurl4-openssl-dev | |
| sudo /usr/bin/perl -MCPAN -e 'install IPC::RUN' | |
| sudo /usr/bin/perl -MCPAN -e 'install Text::Trim' | |
| wget -O- https://apt.releases.hashicorp.com/gpg | sudo gpg --dearmor -o /usr/share/keyrings/hashicorp-archive-keyring.gpg | |
| echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/hashicorp-archive-keyring.gpg] https://apt.releases.hashicorp.com $(lsb_release -cs) main" | sudo tee /etc/apt/sources.list.d/hashicorp.list | |
| sudo apt update && sudo apt install -y vault | |
| - name: Clone postgres repository | |
| uses: actions/checkout@v2 | |
| with: | |
| repository: 'postgres/postgres' | |
| ref: 'a81e5516fa4bc53e332cb35eefe231147c0e1749' | |
| path: 'src' | |
| - name: Clone pg_tde repository | |
| uses: actions/checkout@v2 | |
| with: | |
| path: 'src/contrib/pg_tde' | |
| - name: Create pgsql dir | |
| run: mkdir -p /opt/pgsql | |
| - name: Build postgres | |
| run: | | |
| ./configure --with-openssl --enable-tap-tests=no --enable-cassert | |
| make -j | |
| sudo make install | |
| working-directory: src | |
| - name: Build pg_tde | |
| run: | | |
| ./configure | |
| make -j | |
| sudo make install | |
| working-directory: src/contrib/pg_tde | |
| - name: Start postgresql cluster with pg_tde | |
| run: | | |
| export PATH="/usr/local/pgsql/bin:$PATH" | |
| sudo cp /usr/local/pgsql/bin/pg_config /usr/bin | |
| initdb -D /opt/pgsql/data | |
| echo "shared_preload_libraries = 'pg_tde'" >> \ | |
| /opt/pgsql/data/postgresql.conf | |
| pg_ctl -D /opt/pgsql/data -l logfile start | |
| - name: Test pg_tde | |
| run: | | |
| TV=$(mktemp) | |
| { exec >$TV; vault server -dev; } & | |
| sleep 10 | |
| export ROOT_TOKEN=$(cat $TV | grep "Root Token" | cut -d ":" -f 2 | xargs echo -n) | |
| echo "Root token: $ROOT_TOKEN" | |
| make installcheck | |
| working-directory: src/contrib/pg_tde | |
| - name: Report on test fail | |
| uses: actions/upload-artifact@v2 | |
| if: ${{ failure() }} | |
| with: | |
| name: Regressions diff and postgresql log | |
| path: | | |
| src/contrib/pg_tde/regression.diffs | |
| logfile | |
| retention-days: 3 | |
| - name: Report on test fail 2 | |
| if: ${{ failure() }} | |
| run: | | |
| cat src/contrib/pg_tde/regression.diffs |