From: "Igor Zornik" Subject: Re: [UPDATE] net/miniflux 2.2.13 -> 2.2.14 To: "OpenBSD ports" Cc: "Stuart Henderson" , "Daniel Jakots" Date: Sat, 08 Nov 2025 09:29:24 +0100 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" > 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