Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgpool-hackers-owner+archive@lists.postgresql.org>)
	id 1v0xAB-002rch-PS
	for pgpool-hackers@arkaria.postgresql.org; Tue, 23 Sep 2025 07:10:11 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgpool-hackers-owner+archive@lists.postgresql.org>)
	id 1v0xAA-004FWw-GM
	for pgpool-hackers@arkaria.postgresql.org; Tue, 23 Sep 2025 07:10:10 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ishii@postgresql.org>)
	id 1v0xAA-004FWp-Az
	for pgpool-hackers@lists.postgresql.org; Tue, 23 Sep 2025 07:10:10 +0000
Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <ishii@postgresql.org>)
	id 1v0xA5-002Kjq-31
	for pgpool-hackers@lists.postgresql.org;
	Tue, 23 Sep 2025 07:10:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type:
	Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender
	:Reply-To:Content-ID:Content-Description;
	bh=NZnIpN+fs7hZuOoJRpPMiqQ7+637NYzOgnW006fRH9g=; b=TQUT5LRVE06W/t3FNeJtpBE/kT
	PxdXUNdgZXQLebQZE4QcUYJdLasSIaZ0tYauQbODeEmY3UJj00HQsNX+T/+Xmzy6c8YWpQME1nOag
	/2TT2BaC28+ZCCYFhnBs6X8QDWqCOAF99/FY1nq+A6Etf53zR0015sl7r/TXpe9tB1/a+BHiaruGE
	MRCA6cx0DLDjldMqjFgWSKxSdeph8+n7BUWo/YZ+8zL7eUT4k8UMThG5OoqkA3CG2S+C+Oa//HXR7
	wM+OVZafah/2942jKdTKLq1h4CS1Fg4CRx0KHOMO8DEV59TtrobcpiujMGnjs4VI3wzNAQrr7oq1V
	03JrjYHw==;
Received: from [2409:11:4120:300:a1c5:4059:5370:e483] (helo=localhost)
	by meldrar.postgresql.org with esmtpsa  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <ishii@postgresql.org>)
	id 1v0xA4-0051Ks-1h;
	Tue, 23 Sep 2025 07:10:07 +0000
Date: Tue, 23 Sep 2025 16:09:54 +0900 (JST)
Message-Id: <20250923.160954.387455642442466805.ishii@postgresql.org>
To: liujy@highgo.com
Cc: pgpool-hackers@lists.postgresql.org
Subject: Re: pg_enc
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: <7f18c30b.237.1997555ca11.Coremail.liujy@highgo.com>
References: <7f18c30b.237.1997555ca11.Coremail.liujy@highgo.com>
X-Mailer: Mew version 6.8 on Emacs 29.3
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for
 2409:11:4120:300:a1c5:4059:5370:e483 (failed)
List-Id: <pgpool-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgpool-hackers@lists.postgresql.org>
List-Owner: <mailto:pgpool-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgpool-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/20250923.160954.387455642442466805.ishii%40postgresql.org>
Precedence: bulk

> attatch is the patch for this issue, please help review it.

Thanks. I will look into to the patch.  In the mean time I discarded
the pending message previously sent.

> issue link is https://github.com/pgpool/pgpool2/issues/129
> 
> 
> 
> 
> I have verified it, the result as below:
> 
> [root@test1 bin]# ./pg_enc -p -P
> 
> db password: 
> 
> encryption key: 

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp