diff --git a/databases/pgagroal/Makefile b/databases/pgagroal/Makefile
index cee37e863bbb..6a54bd454db5 100644
--- a/databases/pgagroal/Makefile
+++ b/databases/pgagroal/Makefile
@@ -1,50 +1,52 @@
 PORTNAME=	pgagroal
-DISTVERSION=	1.6.0
+DISTVERSION=	2.0.0
 CATEGORIES=	databases
 MASTER_SITES=	https://github.com/agroal/${PORTNAME}/releases/download/${DISTVERSION}/
 
 MAINTAINER=	bofh@FreeBSD.org
 COMMENT=	High-performance protocol-native connection pool for PostgreSQL
 WWW=		https://agroal.github.io/pgagroal/
 
 LICENSE=	BSD3CLAUSE
 
 BROKEN_armv7=	wants long to be a 64 bit type
 BROKEN_i386=	wants long to be a 64 bit type
 
 BUILD_DEPENDS=	rst2man:textproc/py-docutils
 LIB_DEPENDS=	libcjson.so:devel/libcjson \
-		libev.so:devel/libev
+		libev.so:devel/libev \
+		liblz4.so:archivers/liblz4 \
+		libzstd.so:archivers/zstd
 
 USES=		cmake ssl
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgagroal
 
 SUB_LIST=	PGAGROAL_RUNDIR="${PGAGROAL_RUNDIR}"
 
 USERS=		pgagroal
 GROUPS=		pgagroal
 
 PLIST_SUB+=	PGAGROAL_GROUP="${GROUPS}" \
 		PGAGROAL_LOGDIR="${PGAGROAL_LOGDIR}" \
 		PGAGROAL_RUNDIR="${PGAGROAL_RUNDIR}" \
 		PGAGROAL_USER="${USERS}"  \
 		PORTVERSION="${DISTVERSION}"
 
 PGAGROAL_GROUP?=	pgagroal
 PGAGROAL_USER?=		pgagroal
 
 PGAGROAL_RUNDIR?=	/var/run/pgagroal
 PGAGROAL_LOGDIR?=	/var/log/pgagroal
 
 post-patch:
 	@${MV} ${WRKSRC}/doc/etc/pgagroal.conf \
 		${WRKSRC}/doc/etc/pgagroal.conf.sample
 	@${MV} ${WRKSRC}/doc/etc/pgagroal_hba.conf \
 		${WRKSRC}/doc/etc/pgagroal_hba.conf.sample
 
 post-install:
 	@${MKDIR} ${STAGEDIR}${PGAGROAL_RUNDIR} \
 		${STAGEDIR}${PGAGROAL_LOGDIR}
 
 .include <bsd.port.mk>
diff --git a/databases/pgagroal/distinfo b/databases/pgagroal/distinfo
index e648dc86990c..94c5be12dd55 100644
--- a/databases/pgagroal/distinfo
+++ b/databases/pgagroal/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1742818820
-SHA256 (pgagroal-1.6.0.tar.gz) = 8fe5ae7e45580ee54e9e77a88f79b796896803f2216533900f593095dd53a2ec
-SIZE (pgagroal-1.6.0.tar.gz) = 313170
+TIMESTAMP = 1775914193
+SHA256 (pgagroal-2.0.0.tar.gz) = 42c80fc54d719208e1b3ca5bc52265b0e3b5be2e729c313acaec26f72ac990da
+SIZE (pgagroal-2.0.0.tar.gz) = 484892
diff --git a/databases/pgagroal/files/patch-doc_CMakeLists.txt b/databases/pgagroal/files/patch-doc_CMakeLists.txt
index c032b626a434..95b0057f37f4 100644
--- a/databases/pgagroal/files/patch-doc_CMakeLists.txt
+++ b/databases/pgagroal/files/patch-doc_CMakeLists.txt
@@ -1,13 +1,13 @@
---- doc/CMakeLists.txt.orig	2025-03-20 12:40:33 UTC
+--- doc/CMakeLists.txt.orig	2026-01-21 14:02:51 UTC
 +++ doc/CMakeLists.txt
-@@ -66,8 +66,8 @@ add_custom_command(
- #
- # Install configuration and documentation
- #
--install(FILES etc/pgagroal.conf DESTINATION share/doc/pgagroal/etc)
--install(FILES etc/pgagroal_hba.conf DESTINATION share/doc/pgagroal/etc)
-+install(FILES etc/pgagroal.conf.sample DESTINATION etc/pgagroal)
-+install(FILES etc/pgagroal_hba.conf.sample DESTINATION etc/pgagroal)
+@@ -102,8 +102,8 @@ if (RST2MAN_FOUND)
+   #
+   # Install configuration and documentation
+   #
+-  install(FILES etc/pgagroal.conf DESTINATION share/doc/pgagroal/etc)
+-  install(FILES etc/pgagroal_hba.conf DESTINATION share/doc/pgagroal/etc)
++  install(FILES etc/pgagroal.conf.sample DESTINATION etc/pgagroal)
++  install(FILES etc/pgagroal_hba.conf.sample DESTINATION etc/pgagroal)
  
- install(DIRECTORY . DESTINATION share/doc/pgagroal FILES_MATCHING PATTERN "*.md" PATTERN "etc" EXCLUDE PATTERN "images" EXCLUDE PATTERN "man" EXCLUDE)
- install(DIRECTORY images/ DESTINATION share/doc/pgagroal/images FILES_MATCHING PATTERN "*.png")
+   install(DIRECTORY . DESTINATION share/doc/pgagroal FILES_MATCHING PATTERN "*.md" PATTERN "etc" EXCLUDE PATTERN "images" EXCLUDE PATTERN "man" EXCLUDE PATTERN "manual" EXCLUDE)
+   install(DIRECTORY images/ DESTINATION share/doc/pgagroal/images FILES_MATCHING PATTERN "*.png")
diff --git a/databases/pgagroal/files/patch-doc_etc_pgagroal.conf b/databases/pgagroal/files/patch-doc_etc_pgagroal.conf
index aa2bbe98f625..18c02fcfda3b 100644
--- a/databases/pgagroal/files/patch-doc_etc_pgagroal.conf
+++ b/databases/pgagroal/files/patch-doc_etc_pgagroal.conf
@@ -1,20 +1,20 @@
---- doc/etc/pgagroal.conf.orig	2022-05-23 17:17:02 UTC
+--- doc/etc/pgagroal.conf.orig	2026-01-21 14:02:51 UTC
 +++ doc/etc/pgagroal.conf
 @@ -2,14 +2,14 @@ port = 2345
  host = localhost
  port = 2345
  
 -log_type = console
 +log_type = file
  log_level = info
 -log_path = 
 +log_path = /var/log/pgagroal/pgagroal.log
  
  max_connections = 100
  idle_timeout = 600
  validation = off
 -unix_socket_dir = /tmp/
 +unix_socket_dir = /var/run/pgagroal/
+ ev_backend = auto
  
  [primary]
- host = localhost
diff --git a/databases/pgagroal/pkg-plist b/databases/pgagroal/pkg-plist
index 1861fc21297b..7117498379af 100644
--- a/databases/pgagroal/pkg-plist
+++ b/databases/pgagroal/pkg-plist
@@ -1,16 +1,19 @@
 bin/pgagroal
+bin/pgagroal-vault
 bin/pgagroal-admin
 bin/pgagroal-cli
 @sample %%ETCDIR%%/pgagroal.conf.sample
 @sample %%ETCDIR%%/pgagroal_hba.conf.sample
 lib/libpgagroal.so
-lib/libpgagroal.so.1
+lib/libpgagroal.so.2
 lib/libpgagroal.so.%%PORTVERSION%%
 share/man/man1/pgagroal-admin.1.gz
 share/man/man1/pgagroal-cli.1.gz
 share/man/man1/pgagroal.1.gz
 share/man/man5/pgagroal.conf.5.gz
 share/man/man5/pgagroal_databases.conf.5.gz
 share/man/man5/pgagroal_hba.conf.5.gz
+share/man/man1/pgagroal-vault.1.gz
+share/man/man5/pgagroal_vault.conf.5.gz
 @dir(%%PGAGROAL_USER%%,%%PGAGROAL_GROUP%%,) %%PGAGROAL_LOGDIR%%
 @dir(%%PGAGROAL_USER%%,%%PGAGROAL_GROUP%%,) %%PGAGROAL_RUNDIR%%