Postgres Restore Error after database plugin migration

I migrated my database plugin to a V2 database last month. Since that time I had a problem backing up my postgres database (I'm using the Railway backup-cron template to backup to Amazon S3). I was able to fix the backup issue by running the available update. My issue now is trying to run a restore of my database. When running a restore I'm getting this error, "pg_restore: error: unsupported version (1.15) in file header" I wasn't getting this error before the database plugin migration. Any idea what has changed with the template and how I can fix?
Solution:
the latest backup template would be using pg_dump 16, so you would need to use an applicable pg_restore version
Jump to solution
9 Replies
Percy
Percy9mo ago
Project ID: 9a791893-6f16-433d-9ecc-20dafacdc2ac
Brody
Brody9mo ago
what version of pg_restore are you using?
kilo2849
kilo28499mo ago
9a791893-6f16-433d-9ecc-20dafacdc2ac
Solution
Brody
Brody9mo ago
the latest backup template would be using pg_dump 16, so you would need to use an applicable pg_restore version
kilo2849
kilo28499mo ago
My versiom 14.7 How do I update my pg_restore version to 15? 16
Brody
Brody9mo ago
download a newer version
kilo2849
kilo28499mo ago
do I have to download a new version of Postgres or can I just download a new version of pg_restore
Brody
Brody9mo ago
download a newer version of pg_restore
kilo2849
kilo28499mo ago
OK will give it a go thanks
Want results from more Discord servers?
Add your server