Schlagwort-Archive: sqlite

Migrate paperless-ngx from PostgreSQL to sqlite

#insert reasons (e.g. simpler backup)

My reason is that I consider switching from a docker install with PostgreSQL to because the new (2.0+) versions of paperless (docker) removed the support for arm-32.

Inspired by

Also sqlite is not slow:

1. Export the database
(Data is exported into your „export“ folder)

python3 dumpdata --exclude=contenttypes --exclude=auth.Permission > /usr/src/paperless/export/data.json

2. Stop the app, Remove the database from your docker compose file and start the app again.

3. Import the data

python3 loaddata --exclude=contenttypes --exclude=auth.Permission /usr/src/paperless/export/data.json