Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXwLo-0002ej-1p for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 06 Oct 2021 02:08:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mXwLn-00080W-0T for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 06 Oct 2021 02:08:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXwLm-00080O-RV for pgsql-pkg-debian@lists.postgresql.org; Wed, 06 Oct 2021 02:08:06 +0000 Received: from mx0a-0050f201.pphosted.com ([148.163.145.86]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXwLj-0000fZ-CN for pgsql-pkg-debian@lists.postgresql.org; Wed, 06 Oct 2021 02:08:06 +0000 Received: from pps.filterd (m0203369.ppops.net [127.0.0.1]) by mx0b-0050f201.pphosted.com (8.16.1.2/8.16.1.2) with ESMTP id 1961piIk017347 for ; Wed, 6 Oct 2021 11:07:58 +0900 Received: from sraihe.sra.co.jp (sraihe.sra.co.jp [221.255.117.38]) by mx0b-0050f201.pphosted.com (PPS) with ESMTP id 3bg40x1jph-1 for ; Wed, 06 Oct 2021 11:07:58 +0900 Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraihe.sra.co.jp (Postfix) with ESMTP id 78F572A6863 for ; Wed, 6 Oct 2021 11:07:57 +0900 (JST) Received: from sranhm.sra.co.jp (osspc47 [133.137.174.164]) by srascb.sra.co.jp (Postfix) with ESMTP id 4DC57580229 for ; Wed, 6 Oct 2021 11:07:57 +0900 (JST) Received: from localhost (sraihb-hub.sra.co.jp [133.137.8.6]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by sranhm.sra.co.jp (Postfix) with ESMTPSA id D1ED034142E; Wed, 6 Oct 2021 11:07:56 +0900 (JST) Date: Wed, 06 Oct 2021 11:07:53 +0900 (JST) Message-Id: <20211006.110753.320255471302982342.t-ishii@sranhm.sra.co.jp> To: myon@debian.org Cc: pgsql-pkg-debian@lists.postgresql.org Subject: Re: Pgpool-II latest package? From: Tatsuo Ishii In-Reply-To: <20211006.085601.435275642930093614.t-ishii@sranhm.sra.co.jp> References: <20211005.095126.19963258967193453.t-ishii@sranhm.sra.co.jp> <20211006.085601.435275642930093614.t-ishii@sranhm.sra.co.jp> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Proofpoint-GUID: GvV_j6zjxXCLot5kiOWdcR4SQvfcIft4 X-Proofpoint-ORIG-GUID: GvV_j6zjxXCLot5kiOWdcR4SQvfcIft4 X-Proofpoint-Virus-Version: vendor=nai engine=6300 definitions=10128 signatures=668683 X-Proofpoint-Spam-Details: rule=spam_low_notspam policy=spam_low score=0 suspectscore=0 spamscore=0 malwarescore=0 phishscore=0 adultscore=0 mlxlogscore=999 bulkscore=0 lowpriorityscore=0 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2109230001 definitions=main-2110060012 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >> 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