On 2025/11/08 09:29, Igor Zornik wrote:
> 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.

thanks, committed the two, I simplified the pkg_delete command and
replaced the UTF-8 chars in readme.

for future reference, it's easier to deal with a complete diff though
rather than piecing together from separate mails, especially if one
replaces part of the other :)

> > 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.

the www tree is available on cvs. if it goes there at all I'd prefer to
point at the pkg-readme rather than replicate it, but personally I think
the pkg-readme is enough. no objection if someone else wants to add it
though.

> 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