diff --git a/databases/pg_textsearch/Makefile b/databases/pg_textsearch/Makefile
index 865c86741d7b..664fea95bafc 100644
--- a/databases/pg_textsearch/Makefile
+++ b/databases/pg_textsearch/Makefile
@@ -1,19 +1,19 @@
 PORTNAME=	pg_textsearch
-PORTVERSION=	0.4.1
+PORTVERSION=	0.4.2
 DISTVERSIONPREFIX=	v
 CATEGORIES=	databases
 
 MAINTAINER=	kbowling@FreeBSD.org
 COMMENT=	PostgreSQL extension for BM25 full-text search
 WWW=		https://github.com/timescale/pg_textsearch
 
 LICENSE=	PostgreSQL
 
 USES=		gmake pgsql:17-18
 
 WANT_PGSQL=	server
 USE_GITHUB=	yes
 GH_ACCOUNT=	timescale
 GH_PROJECT=	pg_textsearch
 
 .include <bsd.port.mk>
diff --git a/databases/pg_textsearch/distinfo b/databases/pg_textsearch/distinfo
index d7fbc8e105ce..53ab59408501 100644
--- a/databases/pg_textsearch/distinfo
+++ b/databases/pg_textsearch/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1769140644
-SHA256 (timescale-pg_textsearch-v0.4.1_GH0.tar.gz) = 14d05590fdd27805c6dfcfe897045f6ecf3d2b5081cf45cd6cb53c32d3082419
-SIZE (timescale-pg_textsearch-v0.4.1_GH0.tar.gz) = 6784962
+TIMESTAMP = 1769971132
+SHA256 (timescale-pg_textsearch-v0.4.2_GH0.tar.gz) = 85f753fe5ad4d62057551334fedf5637cb3283ad516b4f1fd247b48049757048
+SIZE (timescale-pg_textsearch-v0.4.2_GH0.tar.gz) = 6788486
diff --git a/databases/pg_textsearch/pkg-plist b/databases/pg_textsearch/pkg-plist
index 0531aa3ac1d6..3641255928c3 100644
--- a/databases/pg_textsearch/pkg-plist
+++ b/databases/pg_textsearch/pkg-plist
@@ -1,12 +1,13 @@
 lib/postgresql/pg_textsearch.so
 share/postgresql/extension/pg_textsearch--0.0.1--0.0.2.sql
 share/postgresql/extension/pg_textsearch--0.0.2--0.0.3.sql
 share/postgresql/extension/pg_textsearch--0.0.3--0.0.4.sql
 share/postgresql/extension/pg_textsearch--0.0.4--0.0.5.sql
 share/postgresql/extension/pg_textsearch--0.0.5--0.1.0.sql
 share/postgresql/extension/pg_textsearch--0.1.0--0.2.0.sql
 share/postgresql/extension/pg_textsearch--0.2.0--0.3.0.sql
 share/postgresql/extension/pg_textsearch--0.3.0--0.4.0.sql
 share/postgresql/extension/pg_textsearch--0.4.0--0.4.1.sql
-share/postgresql/extension/pg_textsearch--0.4.1.sql
+share/postgresql/extension/pg_textsearch--0.4.0--0.4.2.sql
+share/postgresql/extension/pg_textsearch--0.4.2.sql
 share/postgresql/extension/pg_textsearch.control