diff --git a/databases/pguri/Makefile b/databases/pguri/Makefile
index 555425b8f11e..d904ae126c48 100644
--- a/databases/pguri/Makefile
+++ b/databases/pguri/Makefile
@@ -1,27 +1,26 @@
 PORTNAME=	pguri
-PORTVERSION=	1.20151224
-PORTREVISION=	3
+PORTVERSION=	1.20251029
 CATEGORIES=	databases
 
 MAINTAINER=	tz@FreeBSD.org
 COMMENT=	URI datatype for PostgreSQL
 WWW=		https://github.com/petere/pguri
 
 BUILD_DEPENDS=	uriparser>=0.8.0:net/uriparser
 RUN_DEPENDS=	uriparser>=0.8.0:net/uriparser
 
 USES=		gmake pgsql pkgconfig
 LLD_UNSAFE=	yes
 
 USE_GITHUB=	yes
 GH_ACCOUNT=	petere
 
 PLIST_FILES=	lib/postgresql/uri.so share/postgresql/extension/uri--0.sql \
 		share/postgresql/extension/uri--1.sql \
 		share/postgresql/extension/uri--0--1.sql \
 		share/postgresql/extension/uri.control
 
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/uri.so
 
 .include <bsd.port.mk>
diff --git a/databases/pguri/distinfo b/databases/pguri/distinfo
index 21550865a501..8d6dd5bedea3 100644
--- a/databases/pguri/distinfo
+++ b/databases/pguri/distinfo
@@ -1,2 +1,3 @@
-SHA256 (petere-pguri-1.20151224_GH0.tar.gz) = 259dd485e901b2363342eacbc2b867783cc0da0f12d4bddc1040d0a46fe58c1b
-SIZE (petere-pguri-1.20151224_GH0.tar.gz) = 9345
+TIMESTAMP = 1762092107
+SHA256 (petere-pguri-1.20251029_GH0.tar.gz) = 4a47e8faccb2747b98a783341e9fbfccd1eecfda4a95030547145274c5d708fb
+SIZE (petere-pguri-1.20251029_GH0.tar.gz) = 9635
diff --git a/databases/pguri/files/patch-uri.c b/databases/pguri/files/patch-uri.c
deleted file mode 100644
index 10a95328056d..000000000000
--- a/databases/pguri/files/patch-uri.c
+++ /dev/null
@@ -1,29 +0,0 @@
---- uri.c.orig	2024-06-13 16:34:21 UTC
-+++ uri.c
-@@ -149,7 +149,7 @@ uri_host_inet(PG_FUNCTION_ARGS)
- 		char *tmp = palloc(16);
- 		snprintf(tmp, 16, "%u.%u.%u.%u", data[0], data[1], data[2], data[3]);
- 		uriFreeUriMembersA(&uri);
--		PG_RETURN_INET_P(DirectFunctionCall1(inet_in, CStringGetDatum(tmp)));
-+		PG_RETURN_INET_P((inet *) (DirectFunctionCall1(inet_in, CStringGetDatum(tmp))));
- 	}
- 	else if (uri.hostData.ip6)
- 	{
-@@ -161,7 +161,7 @@ uri_host_inet(PG_FUNCTION_ARGS)
- 				 data[8], data[9], data[10], data[11],
- 				 data[12], data[13], data[14], data[15]);
- 		uriFreeUriMembersA(&uri);
--		PG_RETURN_INET_P(DirectFunctionCall1(inet_in, CStringGetDatum(tmp)));
-+		PG_RETURN_INET_P((inet *) (DirectFunctionCall1(inet_in, CStringGetDatum(tmp))));
- 	}
- 	else
- 	{
-@@ -299,7 +299,7 @@ uri_path_array(PG_FUNCTION_ARGS)
- 	uriFreeUriMembersA(&uri);
- 
- 	if (astate)
--		PG_RETURN_ARRAYTYPE_P(makeArrayResult(astate, CurrentMemoryContext));
-+		PG_RETURN_ARRAYTYPE_P((Pointer)(makeArrayResult(astate, CurrentMemoryContext)));
- 	else
- 		PG_RETURN_ARRAYTYPE_P(construct_empty_array(TEXTOID));
- }