MinifluxΒΆ

  1. Get miniflux-windows-amd64 from releases, rename it to miniflux.exe.

  2. PostgreSQL (test on v14).

Create database [1]:

initdb --locale=C --username=miniflux --pgdata=miniflux
postgres -D miniflux
# Keep this terminial window

Configrate database [2]:

  1. Find and run pgAdmin4.exe.

  2. Servers β†’ Context-menu β†’ Register β†’ Server β†’ Tab General:

Name `miniflux_server`
  1. Tab Connection:

host name `localhost`
Maintenance database `miniflux`
Username `miniflux`
  1. Servers β†’ miniflux_server β†’ Context-menu of Databases β†’ Create β†’ Database β†’ Tab General:

Database `miniflux`
  1. Tab Definition:

Encoding `None`

Create miniflux.conf [3]:

DATABASE_URL=user=miniflux password=secret dbname=miniflux sslmode=disable
RUN_MIGRATIONS=1
POLLING_FREQUENCY=60
CREATE_ADMIN=1
ADMIN_USERNAME=<admin_username>
ADMIN_PASSWORD=<admin_password>
DEBUG=on
WORKER_POOL_SIZE=10
PORT=8070
# Open a new terminial window
miniflux -config-file miniflux.conf

How to autorun when Windows 10 startup?

  1. Create start_miniflux.bat. Maybe need administrator permissions to run it:

@echo off

start postgres.exe -D miniflux_db
timeout 5
start miniflux.exe -config-file miniflux.conf

pause
  1. I don’t want to use Windows Task Scheduler, and I don’t try NSSM. So create start_miniflux.vbs:

Set WshShell = CreateObject("WScript.Shell")
  WshShell.Run chr(34) & "start_service.bat" & Chr(34), 0
Set WshShell = Nothing
  1. Create shortcut of start_miniflux.

  2. Put the shortcut into C:\Users\User\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup\.

cd /etc/apt/sources.list.d
sudo touch miniflux.list
echo "deb [trusted=yes] https://repo.miniflux.app/apt/ * *" | sudo tee /etc/apt/sources.list.d/miniflux.list > /dev/null
sudo apt update
sudo apt install miniflux
sudo apt install postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt install postgresql-16
sudo -u postgres psql
CREATE USER miniflux WITH ENCRYPTED PASSWORD 'miniflux';
CREATE DATABASE miniflux;
GRANT ALL PRIVILEGES ON DATABASE miniflux TO miniflux;
ALTER USER miniflux WITH SUPERUSER;
\q
sudo vim /etc/miniflux.conf
RUN_MIGRATIONS=1
DATABASE_URL=user=miniflux password=miniflux dbname=miniflux sslmode=disable
LISTEN_ADDR=/run/miniflux/miniflux.sock
PORT=8070
miniflux -c /etc/miniflux.conf -migrate
miniflux -c /etc/miniflux.conf -create-admin
# sudo systemctl start postgresql
miniflux -c /etc/miniflux.conf
sudo systemctl enable --now miniflux
sudo systemctl enable --now postgresql

TipsΒΆ

# Backup data
pg_dump -U miniflux -h 127.0.0.1 -p 5432 -F t miniflux > miniflux.tar
# Clear postgresql
sudo systemctl stop postgresql
sudo systemctl disable postgresql
pg_lsclusters
sudo systemctl stop postgresql@16-main
sudo pg_dropcluster 16 main --stop
sudo apt-get remove --purge postgresql-16

ReferenceΒΆ