Miniflux 2.0rc1 need Postgres Superuser

[miniflux]

Miniflux 2.0rc1 need Postgres Superuser

[fguillot]

Until a better solution is found, you could give the superuser permission temporarily, run the migrations and drop the privilege after.

[helmut72]

I've done the migration with user postgres, then changed the database variable to my Miniflux user, but that failed. Will try it with my Miniflux user.

[e477]

A simple workaround is to run CREATE EXTENSION hstore; as the postgres superuser on the freshly created miniflux database. With the extension already present, running the migrations should work as a normal user without additional privileges.

[helmut72]

Ok, thank you. This will work:

sudo -u postgres psql <<END
CREATE USER miniflux_user WITH PASSWORD 'miniflux_password';
CREATE DATABASE miniflux_db WITH OWNER miniflux_user TEMPLATE template0 ENCODING 'UTF8';
END
sudo -u postgres psql -d miniflux_db -c 'create extension hstore;'

[neur0manc]

Another workaround:

1. ALTER USER miniflux WITH SUPERUSER;
2. Start miniflux -migrate
3. ALTER USER miniflux WITH NOSUPERUSER;