blob: 7d236ffadfb6e8ee8619c80cb510efe65a2054b7 (
plain) (
tree)
|
|
Introduction
============
Below are some common tasks needed to administrate a miniflux instance.
Create the Database (Example)
=============================
# Switch to the postgres user
$ su - postgres
# Create a database user for miniflux
$ createuser -P miniflux
Enter password for new role: ******
Enter it again: ******
# Create a database for miniflux that belongs to our user
$ createdb -O miniflux miniflux
# Create the extension hstore as superuser
$ psql miniflux -c 'create extension hstore'
CREATE EXTENSION
Create the hstore Extension
===========================
To create the hstore extension, connect to the miniflux database as any user
with SUPERUSER privileges (like the postgres user) and run:
CREATE EXTENSION hstore;
Alternatively, give SUPERUSER privileges to the miniflux user only during the
schema migration:
ALTER USER miniflux WITH SUPERUSER;
-- Run the migrations (miniflux -migrate)
ALTER USER miniflux WITH NOSUPERUSER;
Create the First Admin User
===========================
The easiest way to create the first admin user with your new miniflux instance
is by running:
miniflux -create-admin
Alternatively, set the DATABASE_URL, RUN_MIGRATIONS, CREATE_ADMIN,
ADMIN_USERNAME, and ADMIN_PASSWORD variables in your config file or run miniflux
with these set as environment variables. For example:
export DATABASE_URL=postgres://miniflux:secretpassword@db/miniflux
export RUN_MIGRATIONS=1
export CREATE_ADMIN=1
export ADMIN_USERNAME=admin
export ADMIN_PASSWORD=n0tAstrongPassw0rd!
miniflux
Migrating the Database
======================
On upgrades, the miniflux database needs to be migrated to the new schema
version. This is handled automatically when you run 'emerge --config miniflux'
but can also be performed using the following manual steps:
1. Export the DATABASE_URL variable.
2. Disconnect all users by flushing all sessions with 'miniflux -flush-sessions'
3. Stop the miniflux server.
4. Backup your database.
5. Verify that your backup is really working.
6. Run the database migrations with 'miniflux -migrate' or set the environment
variable RUN_MIGRATIONS=1.
7. Start miniflux.
|
