---

resources:

- name: postgresql

type: git

source:

uri: https://github.com/postgrespro/postgres_cluster

branch: ci

jobs:

- name: runtests

public: true

serial: true

plan:

- get: postgresql

- task: runtests

file: postgresql/build.yml

pkill -9 postgres

rm -rf tmp_install

make install

ulimit -c unlimited

./tmp_install/bin/initdb -D ./tmp_install/data1

cat <<-CONF >> ./tmp_install/data1/pg_hba.conf

cat <<-CONF >> ./tmp_install/data1/postgresql.conf

./tmp_install/bin/pg_ctl -w -D ./tmp_install/data1 -l logfile start

createdb -h localhost

pgbench -i -h localhost

./tmp_install/bin/initdb -D ./tmp_install/data2

cat <<-CONF >> ./tmp_install/data2/pg_hba.conf

cat <<-CONF >> ./tmp_install/data2/postgresql.conf

./tmp_install/bin/pg_ctl -w -D ./tmp_install/data2 -l logfile2 start

createdb -h localhost -p 5433

./tmp_install/bin/pg_dump -s | psql -p 5433

psql -c $'CREATE PUBLICATION mypub FOR TABLE pgbench_accounts, pgbench_branches, pgbench_history, pgbench_tellers;'

psql -c $'CREATE SUBSCRIPTION mysub CONNECTION \'dbname=stas host=127.0.0.1\' PUBLICATION mypub;' -p 5433