PostgreSQL versions
Supported major versions and upgrading between versions
Last updated
Supported major versions and upgrading between versions
Last updated
fylr is tested with PostgreSQL 15, 16 and 17.
The newest recommended version is part of our , in
Make sure you have enough storage for the old postgres data directory and a copy for the new postgres version, e.g. compare
du -sh /srv/fylr/postgres/pgdata
to
df -h /srv/fylr/postgres/pgdata
.
Also consider the needed storage for another dump, by looking at the size at your currently saved dumps, e.g. ls -lh /srv/fylr/sqlbackups/
.
Stop fylr, e.g. docker compose stop fylr
.
Refer to PostgreSQL documentation on how to upgrade, e.g.
For example use pg_dumpall
of the older PostgreSQL version (15) :
pg_dumpall -U fylr > /mnt/dump_all.sql
At the appropriate step, we renamed the old data directory by:
mv /srv/fylr/postgres/pgdata /srv/fylr/postgres/pgdata_old
The new pgdata
directory was then automatically created by the new PostgreSQL.
We instructed docker compose
to use a newer major PostgreSQL version by changing , e.g. from image: postgres:15
to image: postgres:16
.
Importing the data by e.g.: psql -d fylr -U fylr -f /mnt/dump_all.sql
The following Errors, while restoring, can be caused by and in that case be safely ignored: role "fylr" already exists
and database "fylr" already exists
.
Start fylr, e.g. docker compose up -d fylr
.