Re: Pgpool-II latest package? - Mailing list pgsql-pkg-debian

>> Especially interesting would be getting the testsuite to run at
>> package build time; currently it's disabled since upstream cdb49d3.
>> (I never checked back to see if that problem has been resolved since
>> then.)
>> 
>> The packaging repo is there: https://salsa.debian.org/postgresql/pgpool2
> 
> Ok. let me see.

I git cloned the repo and ran src/test/regression/regress.sh on my
Ubuntu 20 laptop. It took about 40 minutes.

I believe you already know but to run the test, you need PostgreSQL
server and client software (psql, pgbench, pg_ctl etc.), and some
extra tools like ssh, memcached, OpenSSL, JDBC driver, Perl and Ruby.
$ ./configure --with-openssl --with-memcached=/usr
$ cd src/sql
$ make install (in my case PostgreSQL is installed under /usr/local/pgsql/ with my account).
$ cd ../..
$ cd src/test/regression
$ ./regress.sh 
creating pgpool-II temporary installation ...
moving pgpool_setup to temporary installation path ...
moving watchdog_setup to temporary installation path ...
using pgpool-II at /home/t-ishii/work/Pgpool-II/current/Salsa.debian.org/pgpool2/src/test/regression/temp/installed
*************************
REGRESSION MODE          : install
PGPOOL-II                :
/home/t-ishii/work/Pgpool-II/current/Salsa.debian.org/pgpool2/src/test/regression/temp/installed
PostgreSQL bin           : /usr/local/pgsql/bin
PostgreSQL Major version : 13
pgbench                  : /usr/local/pgsql/bin/pgbench
PostgreSQL jdbc          : /usr/local/pgsql/share/postgresql-9.2-1003.jdbc4.jar
*************************
testing 001.load_balance...ok.
testing 002.native_replication...ok.
testing 003.failover...ok.
testing 004.watchdog...�ok.
testing 005.jdbc...ok.
testing 006.memqcache...ok.
testing 007.memqcache-memcached...ok.
testing 008.dbredirect...ok.
testing 009.sql_comments...ok.
testing 010.rewrite_timestamp...ok.
testing 011.watchdog_quorum_failover...�ok.
testing 012.watchdog_failover_when_quorum_exists...�ok.
testing 013.watchdog_failover_require_consensus...�ok.
testing 014.watchdog_test_quorum_bypass...�ok.
testing 015.watchdog_master_and_backend_fail...�ok.
testing 016.node_0_is_not_primary...ok.
testing 017.node_0_is_down...ok.
testing 018.detach_primary...ok.
testing 019.log_client_messages...ok.
testing 020.allow_clear_text_frontend_auth...ok.
testing 021.pool_passwd_auth...ok.
testing 022.pool_passwd_alternative_auth...ok.
testing 023.ssl_connection...ok.
testing 024.cert_auth...ok.
testing 025.enable_shared_relcache...ok.
testing 026.temp_table...ok.
testing 027.auto_failback...ok.
testing 028.watchdog_enable_consensus_with_half_votes...������������������������������ok.
testing 031.connection_life_time...ok.
testing 050.bug58...ok.
testing 051.bug60...ok.
testing 052.do_query...ok.
testing 053.insert_lock_hangs...ok.
testing 054.postgres_fdw...ok.
testing 055.backend_all_down...ok.
testing 056.bug63...ok.
testing 057.bug61...ok.
testing 058.bug68...ok.
testing 059.bug92...ok.
testing 060.memory_leak...ok.
testing 061.cancel_query...ok.
testing 062.select_error_hangs...ok.
testing 063.tables_with_space...ok.
testing 064.bug153...ok.
testing 065.bug152...ok.
testing 066.bug230...ok.
testing 067.bug231...ok.
testing 068.memqcache_bug...ok.
testing 069.memory_leak_extended...ok.
testing 070.memory_leak_extended_memqcache...ok.
testing 071.execute_and_deallocate...ok.
testing 072.meqcache_bug2...ok.
testing 073.pg_terminate_backend...ok.
out of 53 ok:53 failed:0 timeout:0
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp