Database error

Development
6

Joplin works perfectly with PostgreSQL 15. The problem you have here is that you can't simply update your postgres container between two major postgres updates. You have to export your v14 database, create a new v15 container, and then re import the database in the new container. Here is how I'm doing it:

  1. docker compose down
  2. docker compose up -d db
  3. docker compose exec -it db pg_dumpall -U joplin > data.sql
  4. docker compose down
  5. Create a new data directory :
    • mv data data.bak
    • mkdir data
  6. Update the tag you are using (postgres:14-alpine → postgres:15-alpine) in docker-compose.yml
  7. docker compose up -d db
  8. docker compose exec -T db psql -U joplin < data.sql
  9. docker compose down
  10. docker compose up -d
  11. Check everything runs correctly
  12. rm -rf data.bak
  13. rm -rf data.sql
1 Like