diff --git a/databases/pgpool-II-37/Makefile b/databases/pgpool-II-37/Makefile
index 73f067304d35..2ba082eb0213 100644
--- a/databases/pgpool-II-37/Makefile
+++ b/databases/pgpool-II-37/Makefile
@@ -1,41 +1,45 @@
 PORTNAME=	pgpool-II
-PORTVERSION=	3.7.22
+PORTVERSION=	3.7.23
 CATEGORIES=	databases
 MASTER_SITES=	http://www.pgpool.net/mediawiki/images/
 PKGNAMESUFFIX=	37
 
 MAINTAINER=	tz@FreeBSD.org
 COMMENT=	Connection pool server for PostgreSQL
 
 LICENSE=	MIT
 LICENSE_FILE=	${WRKSRC}/COPYING
 
+DEPRECATED=	Upstream EOL reaches on 2022-11 use pgpool-II-43
+EXPIRATION_DATE=	2022-12-30
+
 USES=		gmake libtool pgsql:9.6+
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgpool
 
 GNU_CONFIGURE=	yes
-PORTSCOUT=	limit:^3.7.[0-9]*
 
 CONFLICTS=	pgpool-II
 
+PORTSCOUT=	limit:^3.7.[0-9]*
+
 PORTDOCS=	*
 
-OPTIONS_DEFINE=	DOCS SSL
+OPTIONS_DEFINE=		DOCS SSL
 OPTIONS_DEFAULT=	SSL
 
-SSL_CONFIGURE_WITH=	openssl
 SSL_USES=		ssl
+SSL_CONFIGURE_WITH=	openssl
 
 post-install:
 	@${MKDIR} ${STAGEDIR}/var/run/pgpool
 	${INSTALL_LIB} ${WRKSRC}/src/libs/pcp/.libs/libpcp.so.1.0.0 ${STAGEDIR}${PREFIX}/lib
 
 post-install-DOCS-on:
 	@${MKDIR} ${STAGEDIR}${DOCSDIR}
 	cd ${WRKSRC} && ${COPYTREE_SHARE} doc ${STAGEDIR}${DOCSDIR} "-not -name Makefile.\*"
 .for f in AUTHORS ChangeLog NEWS TODO
 	${INSTALL_DATA} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR}
 .endfor
 
 .include <bsd.port.mk>
diff --git a/databases/pgpool-II-37/distinfo b/databases/pgpool-II-37/distinfo
index a4e5585d78f8..f04983f18279 100644
--- a/databases/pgpool-II-37/distinfo
+++ b/databases/pgpool-II-37/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1640293928
-SHA256 (pgpool-II-3.7.22.tar.gz) = 8a72085a9b61bc68b13b70f7e85eab189c196b87f3f1f20099da2c85a297dffd
-SIZE (pgpool-II-3.7.22.tar.gz) = 3472889
+TIMESTAMP = 1648031684
+SHA256 (pgpool-II-3.7.23.tar.gz) = 3d0e87a8445ca85b5a52d3d3aeba645d1b4926500217d04177f5e5ebf71ca51b
+SIZE (pgpool-II-3.7.23.tar.gz) = 3485872
diff --git a/databases/pgpool-II-37/files/pgpool.in b/databases/pgpool-II-37/files/pgpool.in
index ca1b4d136fe0..ba398ac82068 100644
--- a/databases/pgpool-II-37/files/pgpool.in
+++ b/databases/pgpool-II-37/files/pgpool.in
@@ -1,38 +1,41 @@
 #!/bin/sh
 
 # PROVIDE: pgpool
 # REQUIRE: LOGIN
 # KEYWORD: shutdown
 #
 # Add the following lines to /etc/rc.conf.local or /etc/rc.conf
 # to enable this service:
 #
-# pgpool_enable (bool):		Set to NO by default.
+# pgpool_enable (bool):		    Set to NO by default.
 #				Set it to YES to enable pgpool.
-# pgpool_conf (file):		Set location of your config.
+# pgpool_conf (file):		    Set location of your config.
 #				Default is "%%PREFIX%%/etc/pgpool.conf"
-# pgpool_user (uid):		User ID to run as (default nobody)
+# pgpool_user (uid):		    User ID to run as (default nobody)
+# pgpool_flags (string):        Flags pass to the program
+#				Default is ""
 # pgpool_stop_mode (string): 	Shutdown mode
-#       			Default is "smart"
-#       			Possibilities are "smart", "fast", or "immediate"
+#      			Default is "smart"
+#      			Possibilities are "smart", "fast", or "immediate"
 #
 
 . /etc/rc.subr
 
 name=pgpool
 rcvar=pgpool_enable
 
 load_rc_config $name
 
 : ${pgpool_enable="NO"}
 : ${pgpool_conf="%%PREFIX%%/etc/pgpool.conf"}
 : ${pgpool_user="nobody"}
+: ${pgpool_flags=""}
 : ${pgpool_stop_mode="smart"}
 
 command="%%PREFIX%%/bin/pgpool"
-command_args="-f ${pgpool_conf}"
+command_args="-f ${pgpool_conf} ${pgpool_flags}"
 stop_cmd="${command} -m ${pgpool_stop_mode} ${command_args} stop"
 
 required_files="${pgpool_conf}"
 
 run_rc_command "$1"