[#15] Get extra files #13
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: CI | |
| # on: | |
| # push: | |
| # branches: | |
| # - main | |
| # - actions | |
| # pull_request: | |
| # branches: | |
| # - main | |
| # jobs: | |
| # test-postgresql-13: | |
| # runs-on: ubuntu-latest | |
| # steps: | |
| # - uses: actions/checkout@v4 | |
| # - name: Update system | |
| # run: sudo apt-get update -y | |
| # - name: Install dependencies | |
| # run: sudo apt-get install -y --no-install-recommends git gcc cmake make wget build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev libxml2-utils xsltproc ccache pkg-config check | |
| # - name: Test PostgreSQL 13 | |
| # run: | | |
| # set -e | |
| # install_postgresql() { | |
| # version=${1:-13} | |
| # git_repo="https://github.com/postgres/postgres.git" | |
| # cd /tmp | |
| # git clone --branch "REL_${version}_STABLE" --single-branch --depth 1 "$git_repo" | |
| # cd /tmp/postgres | |
| # ./configure --prefix=/usr/local/pgsql | |
| # make | |
| # sudo make install | |
| # sudo -u postgres /usr/local/pgsql/bin/initdb -D /tmp/pgsql-${version} | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile start | |
| # export PATH=/usr/local/pgsql/bin:$PATH | |
| # export LD_LIBRARY_PATH=/usr/local/pgsql/lib | |
| # } | |
| # config_postgresql(){ | |
| # version=${1:-13} | |
| # sudo -u postgres sed -i 's/^#\s*password_encryption\s*=\s*\(md5\|scram-sha-256\)/password_encryption = scram-sha-256/' /tmp/pgsql-${version}/postgresql.conf | |
| # sudo -u postgres sed -i '/^host/d' /tmp/pgsql-${version}/pg_hba.conf | |
| # sudo -u postgres bash -c "cat <<EOF >> /tmp/pgsql-${version}/pg_hba.conf | |
| # host postgres repl 127.0.0.1/32 scram-sha-256 | |
| # host postgres repl ::1/128 scram-sha-256 | |
| # host replication repl 127.0.0.1/32 scram-sha-256 | |
| # host replication repl ::1/128 scram-sha-256 | |
| # EOF" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile restart | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE ROLE repl WITH LOGIN REPLICATION PASSWORD 'secretpassword';" | |
| # } | |
| # install_pgmoneta_ext() { | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/ | |
| # mkdir build | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/ | |
| # cmake .. | |
| # make | |
| # sudo make install | |
| # } | |
| # create_pgmoneta_ext(){ | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP EXTENSION IF EXISTS pgmoneta_ext;" | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE EXTENSION pgmoneta_ext;" | |
| # } | |
| # test_pgmoneta_ext(){ | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/test | |
| # export PGPASSWORD='secretpassword' | |
| # ./pgmoneta_ext_test | |
| # unset PGPASSWORD | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP ROLE repl;" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile stop | |
| # } | |
| # echo "******************* START PostgreSQL 13 ******************" | |
| # install_postgresql 13 | |
| # config_postgresql 13 | |
| # install_pgmoneta_ext | |
| # create_pgmoneta_ext | |
| # test_pgmoneta_ext | |
| # echo "******************* PostgreSQL 13 Success ******************" | |
| # test-postgresql-14: | |
| # runs-on: ubuntu-latest | |
| # steps: | |
| # - uses: actions/checkout@v4 | |
| # - name: Update system | |
| # run: sudo apt-get update -y | |
| # - name: Install dependencies | |
| # run: sudo apt-get install -y --no-install-recommends git gcc cmake make wget build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev libxml2-utils xsltproc ccache pkg-config check | |
| # - name: Test PostgreSQL 14 | |
| # run: | | |
| # set -e | |
| # install_postgresql() { | |
| # version=${1:-13} | |
| # git_repo="https://github.com/postgres/postgres.git" | |
| # cd /tmp | |
| # git clone --branch "REL_${version}_STABLE" --single-branch --depth 1 "$git_repo" | |
| # cd /tmp/postgres | |
| # ./configure --prefix=/usr/local/pgsql | |
| # make | |
| # sudo make install | |
| # sudo -u postgres /usr/local/pgsql/bin/initdb -D /tmp/pgsql-${version} | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile start | |
| # export PATH=/usr/local/pgsql/bin:$PATH | |
| # export LD_LIBRARY_PATH=/usr/local/pgsql/lib | |
| # } | |
| # config_postgresql(){ | |
| # version=${1:-13} | |
| # sudo -u postgres sed -i 's/^#\s*password_encryption\s*=\s*\(md5\|scram-sha-256\)/password_encryption = scram-sha-256/' /tmp/pgsql-${version}/postgresql.conf | |
| # sudo -u postgres sed -i '/^host/d' /tmp/pgsql-${version}/pg_hba.conf | |
| # sudo -u postgres bash -c "cat <<EOF >> /tmp/pgsql-${version}/pg_hba.conf | |
| # host postgres repl 127.0.0.1/32 scram-sha-256 | |
| # host postgres repl ::1/128 scram-sha-256 | |
| # host replication repl 127.0.0.1/32 scram-sha-256 | |
| # host replication repl ::1/128 scram-sha-256 | |
| # EOF" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile restart | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE ROLE repl WITH LOGIN REPLICATION PASSWORD 'secretpassword';" | |
| # } | |
| # install_pgmoneta_ext() { | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/ | |
| # mkdir build | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/ | |
| # cmake .. | |
| # make | |
| # sudo make install | |
| # } | |
| # create_pgmoneta_ext(){ | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP EXTENSION IF EXISTS pgmoneta_ext;" | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE EXTENSION pgmoneta_ext;" | |
| # } | |
| # test_pgmoneta_ext(){ | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/test | |
| # export PGPASSWORD='secretpassword' | |
| # ./pgmoneta_ext_test | |
| # unset PGPASSWORD | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP ROLE repl;" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile stop | |
| # } | |
| # echo "******************* START PostgreSQL 14 ******************" | |
| # install_postgresql 14 | |
| # config_postgresql 14 | |
| # install_pgmoneta_ext | |
| # create_pgmoneta_ext | |
| # test_pgmoneta_ext | |
| # echo "******************* PostgreSQL 14 Success ******************" | |
| # test-postgresql-15: | |
| # runs-on: ubuntu-latest | |
| # steps: | |
| # - uses: actions/checkout@v4 | |
| # - name: Update system | |
| # run: sudo apt-get update -y | |
| # - name: Install dependencies | |
| # run: sudo apt-get install -y --no-install-recommends git gcc cmake make wget build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev libxml2-utils xsltproc ccache pkg-config check | |
| # - name: Test PostgreSQL 15 | |
| # run: | | |
| # set -e | |
| # install_postgresql() { | |
| # version=${1:-13} | |
| # git_repo="https://github.com/postgres/postgres.git" | |
| # cd /tmp | |
| # git clone --branch "REL_${version}_STABLE" --single-branch --depth 1 "$git_repo" | |
| # cd /tmp/postgres | |
| # ./configure --prefix=/usr/local/pgsql | |
| # make | |
| # sudo make install | |
| # sudo -u postgres /usr/local/pgsql/bin/initdb -D /tmp/pgsql-${version} | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile start | |
| # export PATH=/usr/local/pgsql/bin:$PATH | |
| # export LD_LIBRARY_PATH=/usr/local/pgsql/lib | |
| # } | |
| # config_postgresql(){ | |
| # version=${1:-13} | |
| # sudo -u postgres sed -i 's/^#\s*password_encryption\s*=\s*\(md5\|scram-sha-256\)/password_encryption = scram-sha-256/' /tmp/pgsql-${version}/postgresql.conf | |
| # sudo -u postgres sed -i '/^host/d' /tmp/pgsql-${version}/pg_hba.conf | |
| # sudo -u postgres bash -c "cat <<EOF >> /tmp/pgsql-${version}/pg_hba.conf | |
| # host postgres repl 127.0.0.1/32 scram-sha-256 | |
| # host postgres repl ::1/128 scram-sha-256 | |
| # host replication repl 127.0.0.1/32 scram-sha-256 | |
| # host replication repl ::1/128 scram-sha-256 | |
| # EOF" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile restart | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE ROLE repl WITH LOGIN REPLICATION PASSWORD 'secretpassword';" | |
| # } | |
| # install_pgmoneta_ext() { | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/ | |
| # mkdir build | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/ | |
| # cmake .. | |
| # make | |
| # sudo make install | |
| # } | |
| # create_pgmoneta_ext(){ | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP EXTENSION IF EXISTS pgmoneta_ext;" | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE EXTENSION pgmoneta_ext;" | |
| # } | |
| # test_pgmoneta_ext(){ | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/test | |
| # export PGPASSWORD='secretpassword' | |
| # ./pgmoneta_ext_test | |
| # unset PGPASSWORD | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP ROLE repl;" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile stop | |
| # } | |
| # echo "******************* START PostgreSQL 15 ******************" | |
| # install_postgresql 15 | |
| # config_postgresql 15 | |
| # install_pgmoneta_ext | |
| # create_pgmoneta_ext | |
| # test_pgmoneta_ext | |
| # echo "******************* PostgreSQL 15 Success ******************" | |
| # test-postgresql-16: | |
| # runs-on: ubuntu-latest | |
| # steps: | |
| # - uses: actions/checkout@v4 | |
| # - name: Update system | |
| # run: sudo apt-get update -y | |
| # - name: Install dependencies | |
| # run: sudo apt-get install -y --no-install-recommends git gcc cmake make wget build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev libxml2-utils xsltproc ccache pkg-config check | |
| # - name: Test PostgreSQL 16 | |
| # run: | | |
| # set -e | |
| # install_postgresql() { | |
| # version=${1:-13} | |
| # git_repo="https://github.com/postgres/postgres.git" | |
| # cd /tmp | |
| # git clone --branch "REL_${version}_STABLE" --single-branch --depth 1 "$git_repo" | |
| # cd /tmp/postgres | |
| # ./configure --prefix=/usr/local/pgsql | |
| # make | |
| # sudo make install | |
| # sudo -u postgres /usr/local/pgsql/bin/initdb -D /tmp/pgsql-${version} | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile start | |
| # export PATH=/usr/local/pgsql/bin:$PATH | |
| # export LD_LIBRARY_PATH=/usr/local/pgsql/lib | |
| # } | |
| # config_postgresql(){ | |
| # version=${1:-13} | |
| # sudo -u postgres sed -i 's/^#\s*password_encryption\s*=\s*\(md5\|scram-sha-256\)/password_encryption = scram-sha-256/' /tmp/pgsql-${version}/postgresql.conf | |
| # sudo -u postgres sed -i '/^host/d' /tmp/pgsql-${version}/pg_hba.conf | |
| # sudo -u postgres bash -c "cat <<EOF >> /tmp/pgsql-${version}/pg_hba.conf | |
| # host postgres repl 127.0.0.1/32 scram-sha-256 | |
| # host postgres repl ::1/128 scram-sha-256 | |
| # host replication repl 127.0.0.1/32 scram-sha-256 | |
| # host replication repl ::1/128 scram-sha-256 | |
| # EOF" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile restart | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE ROLE repl WITH LOGIN REPLICATION PASSWORD 'secretpassword';" | |
| # } | |
| # install_pgmoneta_ext() { | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/ | |
| # mkdir build | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/ | |
| # cmake .. | |
| # make | |
| # sudo make install | |
| # } | |
| # create_pgmoneta_ext(){ | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP EXTENSION IF EXISTS pgmoneta_ext;" | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE EXTENSION pgmoneta_ext;" | |
| # } | |
| # test_pgmoneta_ext(){ | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/test | |
| # export PGPASSWORD='secretpassword' | |
| # ./pgmoneta_ext_test | |
| # unset PGPASSWORD | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP ROLE repl;" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile stop | |
| # } | |
| # echo "******************* START PostgreSQL 16 ******************" | |
| # install_postgresql 16 | |
| # config_postgresql 16 | |
| # install_pgmoneta_ext | |
| # create_pgmoneta_ext | |
| # test_pgmoneta_ext | |
| # echo "******************* PostgreSQL 16 Success ******************" | |
| # test-postgresql-17: | |
| # runs-on: ubuntu-latest | |
| # steps: | |
| # - uses: actions/checkout@v4 | |
| # - name: Update system | |
| # run: sudo apt-get update -y | |
| # - name: Install dependencies | |
| # run: sudo apt-get install -y --no-install-recommends git gcc cmake make wget build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev libxml2-utils xsltproc ccache pkg-config check | |
| # - name: Test PostgreSQL 17 | |
| # run: | | |
| # set -e | |
| # install_postgresql() { | |
| # version=${1:-13} | |
| # git_repo="https://github.com/postgres/postgres.git" | |
| # cd /tmp | |
| # git clone --branch "REL_${version}_STABLE" --single-branch --depth 1 "$git_repo" | |
| # cd /tmp/postgres | |
| # ./configure --prefix=/usr/local/pgsql | |
| # make | |
| # sudo make install | |
| # sudo -u postgres /usr/local/pgsql/bin/initdb -D /tmp/pgsql-${version} | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile start | |
| # export PATH=/usr/local/pgsql/bin:$PATH | |
| # export LD_LIBRARY_PATH=/usr/local/pgsql/lib | |
| # } | |
| # config_postgresql(){ | |
| # version=${1:-13} | |
| # sudo -u postgres sed -i 's/^#\s*password_encryption\s*=\s*\(md5\|scram-sha-256\)/password_encryption = scram-sha-256/' /tmp/pgsql-${version}/postgresql.conf | |
| # sudo -u postgres sed -i '/^host/d' /tmp/pgsql-${version}/pg_hba.conf | |
| # sudo -u postgres bash -c "cat <<EOF >> /tmp/pgsql-${version}/pg_hba.conf | |
| # host postgres repl 127.0.0.1/32 scram-sha-256 | |
| # host postgres repl ::1/128 scram-sha-256 | |
| # host replication repl 127.0.0.1/32 scram-sha-256 | |
| # host replication repl ::1/128 scram-sha-256 | |
| # EOF" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile restart | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE ROLE repl WITH LOGIN REPLICATION PASSWORD 'secretpassword';" | |
| # } | |
| # install_pgmoneta_ext() { | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/ | |
| # mkdir build | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/ | |
| # cmake .. | |
| # make | |
| # sudo make install | |
| # } | |
| # create_pgmoneta_ext(){ | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP EXTENSION IF EXISTS pgmoneta_ext;" | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "CREATE EXTENSION pgmoneta_ext;" | |
| # } | |
| # test_pgmoneta_ext(){ | |
| # cd /home/runner/work/pgmoneta_ext/pgmoneta_ext/build/test | |
| # export PGPASSWORD='secretpassword' | |
| # ./pgmoneta_ext_test | |
| # unset PGPASSWORD | |
| # sudo -u postgres /usr/local/pgsql/bin/psql -U postgres -c "DROP ROLE repl;" | |
| # sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /tmp/pgsql-${version} -l /tmp/logfile stop | |
| # } | |
| # echo "******************* START PostgreSQL 17 ******************" | |
| # install_postgresql 17 | |
| # config_postgresql 17 | |
| # install_pgmoneta_ext | |
| # create_pgmoneta_ext | |
| # test_pgmoneta_ext | |
| # echo "******************* PostgreSQL 17 Success ******************" | |