Docker Postgres: FATAL Database Files are incompatible with server

[Didam]

I am using Postgres with FreshRSS, installed via a portainer stack. I have Watchtower running, and a day or two ago, I started getting the fatal error. I'm assuming that postgres updated to a new version (a risk using Watchtower, I understand!).

I changed the stack to use PostGres 13 image and everything works.

My question is how to upgrade the database once I upgrade the image to 14? I saw that people use brew Postgres - FATAL: database files are incompatible with server, but I'm confused how to run the command on Synology. Is this something where I login as root? Do I need to install brew on synology?

Relative novice here, so flailing! (Well, I fixed the problem for the short term, but would like the long term solution!)

 

[Rusty]

Try and run another Postgres 14 container side by side. Export DB from your current Postgres and import it into 14. See if that will work. Then just switch your apps to use the new instance and terminate the old one.

 

[one-eyed-king]

I was going to write details about how to dump the old database and import the dump into the new database, until I realized that I actualy don't know the exact commands. I always "have a guy" in my projects that takes core of those type of details

 

[Didam]

Sorry, confused by the interface. Would I export/import using a database tool (a la phpmyadmin, something specific to postgres) or is this done by ssh into the NAS?

 

[Rusty]

Sorry, confused by the interface. Would I export/import using a database tool (a la phpmyadmin, something specific to postgres) or is this done by ssh into the NAS?

backup example inside the postgres container:

pg_dump -Ft DBNAME -U DBUSERNAME > backup_name.tar

Restore process:

pg_restore -d DBNAME -U DBUSERNAME backup_name.tar

more info: pg_dump