Docker Postgres: FATAL Database Files are incompatible with server

Currently reading
Docker Postgres: FATAL Database Files are incompatible with server

46
6
NAS
DS720+,DS212
Operating system
  1. Windows
Mobile operating system
  1. Android
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!)
 
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 😊
 
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?
 
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
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Similar threads

For the heck of it, I just checked again in docker container, and it announced an update was available. I...
Replies
4
Views
484
  • Question
Do realize, that enabling any user to run docker containers is largely the same as giving that user full...
Replies
6
Views
1,079
Hello, I already have it configured perfectly with wireguard. I was looking at the Gluetun configuration...
Replies
4
Views
757
Thanks... I tried something similar with rsync. The docker volume lived in...
Replies
7
Views
763
I can’t find any option to restore just the settings. 1710356648 Phew, managed to fix it. Within the...
Replies
4
Views
580
Good to hear. Deluge has not been updated for almost two years now as an app, nevertheless. But it gives...
Replies
12
Views
1,271
  • Question
Open an issue on that GitHub page. The developers will be glad to assist. OP has posted two threads on...
Replies
5
Views
1,232

Welcome to SynoForum.com!

SynoForum.com is an unofficial Synology forum for NAS owners and enthusiasts.

Registration is free, easy and fast!

Back
Top