Change Postgres version #277

Closed
opened 2026-04-05 16:16:06 +02:00 by MrUnknownDE · 0 comments
Owner

Originally created by @MeikelLP on 1/6/2026

I backuped an old Postgres 17 db and imported it via Databasus into an upgraded Postgres 18.

Sadly now the backup job fails with:

PostgreSQL connection or authentication error. stderr: pg_dump: error: aborting because of server version mismatch
pg_dump: detail: server version: 18.1; pg_dump version: 17.7 (Debian 17.7-3.pgdg12+1)

The UI shows the version but the form does not:

Image Image

Please do not answer with "You have to create a new entry in the UI". It will cause dead bodies every time Postgres is upgraded because I cannot use the automatically created Databasus user because I don't know it's password.

*Originally created by @MeikelLP on 1/6/2026* I backuped an old Postgres 17 db and imported it via Databasus into an upgraded Postgres 18. Sadly now the backup job fails with: ``` PostgreSQL connection or authentication error. stderr: pg_dump: error: aborting because of server version mismatch pg_dump: detail: server version: 18.1; pg_dump version: 17.7 (Debian 17.7-3.pgdg12+1) ``` The UI shows the version but the form does not: <img width="284" height="68" alt="Image" src="https://github.com/user-attachments/assets/d86948f4-4e81-4284-88d3-b1eaf6f878e7" /> <img width="375" height="359" alt="Image" src="https://github.com/user-attachments/assets/c7cadc66-defb-4967-a80e-e43ecc3bc7a9" /> --- Please do not answer with "You have to create a new entry in the UI". It will cause dead bodies every time Postgres is upgraded because I cannot use the automatically created Databasus user because I don't know it's password.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github/databasus#277