diff --git a/databases/pgactive/Makefile b/databases/pgactive/Makefile
index 03904306546b..2dd8f4543a7b 100644
--- a/databases/pgactive/Makefile
+++ b/databases/pgactive/Makefile
@@ -1,24 +1,25 @@
 PORTNAME=	pgactive
 PORTVERSION=	2.1.7
 DISTVERSIONPREFIX=	v
+PORTREVISION=	1
 CATEGORIES=	databases
 
 MAINTAINER=	vanilla@FreeBSD.org
 COMMENT=	Active-active replication extension for PostgreSQL
 WWW=		http://github.com/aws/pgactive
 
 LICENSE=	APACHE20
 LICENSE_FILE=	${WRKSRC}/LICENSE
 
 USES=		gmake pgsql
 WANT_PGSQL=	client server
 GNU_CONFIGURE=	yes
 USE_GITHUB=	yes
 GH_ACCOUNT=	aws
 
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/pgactive_dump
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/pgactive_init_copy
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgactive.so
 
 .include <bsd.port.mk>
diff --git a/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__archiver.h b/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__archiver.h
new file mode 100644
index 000000000000..8615b213fe96
--- /dev/null
+++ b/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__archiver.h
@@ -0,0 +1,12 @@
+--- src/compat/18/pg_dump/pg_backup_archiver.h.orig	2025-10-24 11:59:50 UTC
++++ src/compat/18/pg_dump/pg_backup_archiver.h
+@@ -464,7 +464,9 @@ extern void InitArchiveFmt_Tar(ArchiveHandle *AH);
+ extern void InitArchiveFmt_Directory(ArchiveHandle *AH);
+ extern void InitArchiveFmt_Tar(ArchiveHandle *AH);
+ 
++#if PG_VERSION_NUM < 180004
+ extern bool isValidTarHeader(char *header);
++#endif
+ 
+ extern void ReconnectToServer(ArchiveHandle *AH, const char *dbname);
+ extern void IssueCommandPerBlob(ArchiveHandle *AH, TocEntry *te,
diff --git a/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__tar.c b/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__tar.c
new file mode 100644
index 000000000000..69c31c4aa5e8
--- /dev/null
+++ b/databases/pgactive/files/patch-src_compat_18_pg__dump_pg__backup__tar.c
@@ -0,0 +1,18 @@
+--- src/compat/18/pg_dump/pg_backup_tar.c.orig	2025-10-24 11:59:50 UTC
++++ src/compat/18/pg_dump/pg_backup_tar.c
+@@ -984,6 +984,7 @@ tarPrintf(TAR_MEMBER *th, const char *fmt,...)
+ 	return (int) cnt;
+ }
+ 
++#if PG_VERSION_NUM < 180004
+ bool
+ isValidTarHeader(char *header)
+ {
+@@ -1008,6 +1009,7 @@ isValidTarHeader(char *header)
+ 
+ 	return false;
+ }
++#endif
+ 
+ /* Given the member, write the TAR header & copy the file */
+ static void