On Fri Nov 7, 2025 at 12:17 PM CET, Stuart Henderson wrote:
> On 2025/11/04 17:56, Igor Zornik wrote:
>> while, but now they are active about drooping it. During the migration
>> process you might hit the following error message:
>> 
>> [Migration v119] pq: must be owner of extension hstore
>> 
>> It means the extension was installed with a different user than the
>> one being used the run the migration. It will happen if you installed
>> it as a superuser as the readme instructs. Just remove it manually and
>> proceed with the migration. Something like the following should do the
>> trick:
>> 
>> psql -U postgres miniflux -c 'DROP EXTENSION hstore'
>
> please would you add this info to the pkg-readme for upgrading users?

As Stuart requested, I’m sending a diff just for the package readme
that now includes information regarding the hstore removal.

On Fri Nov 7, 2025 at 2:29 AM CET, Daniel Jakots wrote:
> On Tue, 04 Nov 2025 17:56:26 +0100, "Igor Zornik"
> <mocheryl@mocheryl.org> wrote:
>
>> Hello, ports.
>>
>> New version of miniflux tested on today's amd64 snap. It seems it no
>> longer needs the hstore extension. It hasn't been necessary for a
>> while, but now they are active about drooping it. During the migration
>> process you might hit the following error message:
>>
>> [Migration v119] pq: must be owner of extension hstore
>>
>> It means the extension was installed with a different user than the
>> one being used the run the migration. It will happen if you installed
>> it as a superuser as the readme instructs. Just remove it manually and
>> proceed with the migration. Something like the following should do the
>> trick:
>>
>> psql -U postgres miniflux -c 'DROP EXTENSION hstore'
>>
>> Optionally you might want to remove the postgresql contrib package if
>> that was the only reason you had it installed in the first place:
>>
>> pkg_delete -imVvvvvv postgresql-contrib
>>
>> With the above instructions I've successfully completed the upgrade
>> and haven't noticed any regressions yet. Additional information:
>>
>> https://github.com/miniflux/v2/issues/3759
>> https://miniflux.app/docs/database.html#configuration
>
> Thanks, I think it makes sense to have a current.html entry so users
> don't have to figure out this, doesn't it?

Sorry, but was this question aimed at me? I suppose it would make sense
updating it, but I don’t know if I can do anything about it. I guess
someone with access to that page can include the (reworded) notes from
the updated readme.

Index: pkg/README
===================================================================
RCS file: /cvs/ports/net/miniflux/pkg/README,v
retrieving revision 1.3
diff -u -p -u -p -r1.3 README
--- pkg/README	1 Oct 2024 17:31:31 -0000	1.3
+++ pkg/README	8 Nov 2025 08:00:43 -0000
@@ -5,9 +5,6 @@
 Initial Setup
 =============
 
-The database server will need to have the hstore extension. This means
-installing postgresql-contrib on OpenBSD.
-
 Configure ${SYSCONFDIR}/miniflux.conf to your liking. Create a user and
 database as defined in ${SYSCONFDIR}/miniflux.conf:
 
@@ -21,11 +18,6 @@ Create a database for miniflux that belo
 
 $ createdb -U postgres -O miniflux miniflux
 
-Create the extension hstore as superuser
-
-$ psql -U postgres miniflux -c 'create extension hstore'
-CREATE EXTENSION
-
 Run the database migrations.
 
 # su -s/bin/sh - _miniflux
@@ -36,3 +28,26 @@ Create the initial admin account.
 $ miniflux -c /etc/miniflux.conf -create-admin
 
 Miniflux is now ready to be started via rcctl.
+
+Deprecating hstore
+==================
+
+If you’re performing a migration from a version that required your
+postgresql database to have the hstore extension enabled, you will
+most likely encounter the following error during the procedure:
+
+[Migration v119] pq: must be owner of extension hstore
+
+This generally happens when you’re trying to drop an extension with
+an account that is different than the one that had created it, which
+would be the case if you had installed it following the original
+port’s setup instructions. You need to perform this step manually
+then rerun the in-software update. Here is one way of achieving
+that:
+
+$ psql -U postgres miniflux -c 'DROP EXTENSION hstore'
+
+Optionally you might want to remove the postgresql contrib package
+if that was the only reason you had it installed in the first place:
+
+# pkg_delete -imVvvvvv postgresql-contrib