diff --git a/databases/ip4r/Makefile b/databases/ip4r/Makefile
index 81b3b5f0f548..67b736973da2 100644
--- a/databases/ip4r/Makefile
+++ b/databases/ip4r/Makefile
@@ -1,21 +1,20 @@
 PORTNAME=	ip4r
-PORTVERSION=	2.4.1
-PORTREVISION=	1
+PORTVERSION=	2.4.2
 CATEGORIES=	databases net
 
 MAINTAINER=	axel.rau@chaos1.de
 COMMENT=	IP address and IP range index types for PostgreSQL
 WWW=		https://github.com/RhodiumToad/ip4r
 
 LICENSE=	PostgreSQL
 
 USES=		gmake pgsql
 USE_GITHUB=	yes
 GH_ACCOUNT=	RhodiumToad
 
 post-install:
 	@${MKDIR} ${STAGEDIR}${PREFIX}/include/postgresql/server/extension/ip4r
 	${INSTALL_DATA} ${WRKSRC}/src/ipr.h ${STAGEDIR}${PREFIX}/include/postgresql/server/extension/ip4r
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/ip4r.so
 
 .include <bsd.port.mk>
diff --git a/databases/ip4r/distinfo b/databases/ip4r/distinfo
index b8ba548807f0..2dc6ba9c1398 100644
--- a/databases/ip4r/distinfo
+++ b/databases/ip4r/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1564818466
-SHA256 (RhodiumToad-ip4r-2.4.1_GH0.tar.gz) = 78b9f0c1ae45c22182768fe892a32d533c82281035e10914111400bf6301c726
-SIZE (RhodiumToad-ip4r-2.4.1_GH0.tar.gz) = 128212
+TIMESTAMP = 1700337516
+SHA256 (RhodiumToad-ip4r-2.4.2_GH0.tar.gz) = 0f7b1f159974f49a47842a8ab6751aecca1ed1142b6d5e38d81b064b2ead1b4b
+SIZE (RhodiumToad-ip4r-2.4.2_GH0.tar.gz) = 132976
diff --git a/databases/ip4r/pkg-plist b/databases/ip4r/pkg-plist
index ee252fae530c..e092302e532b 100644
--- a/databases/ip4r/pkg-plist
+++ b/databases/ip4r/pkg-plist
@@ -1,11 +1,8 @@
 include/postgresql/server/extension/ip4r/ipr.h
 lib/postgresql/ip4r.so
 share/doc/postgresql/extension/README.ip4r
 share/postgresql/extension/ip4r--2.0--2.1.sql
 share/postgresql/extension/ip4r--2.1--2.2.sql
 share/postgresql/extension/ip4r--2.2--2.4.sql
 share/postgresql/extension/ip4r--2.4.sql
-share/postgresql/extension/ip4r--unpackaged1--2.0.sql
-share/postgresql/extension/ip4r--unpackaged2.0--2.0.sql
-share/postgresql/extension/ip4r--unpackaged2.1--2.1.sql
 share/postgresql/extension/ip4r.control