Database Configuration

• PostgreSQL Installation
• PostgreSQL Configuration
• Database Connection Parameters

This document describes how to configure PostgreSQL for Miniflux.

Database Installation ¶

The first step is to install PostgreSQL with your package manager.

For example, on Debian it’s as simple as typing this command:

sudo apt install postgresql postgresql-contrib

Database Configuration ¶

Older versions of Miniflux required the HSTORE extension for PostgreSQL. This is no longer the case since version 2.0.27.

There is a SQL migration in Miniflux 2.2.14 to remove HSTORE extension from the database.

If you are seeing this Postgres error: Error: pq: must be owner of extension hstore, you can fix it by running the following SQL command as a superuser for the Miniflux database:

DROP EXTENSION hstore;

This error means you initially created the hstore extension as a different database user than the one you are currently using for Miniflux.

Database Connection Parameters ¶

Miniflux uses the Golang library pq to communicate with PostgreSQL. The list of connection parameters are available on this page.

The default value for DATABASE_URL is user=postgres password=postgres dbname=miniflux2 sslmode=disable.

You could also use the URL format postgres://postgres:postgres@localhost/miniflux2?sslmode=disable.