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:Jump to solution
the latest backup template would be using pg_dump 16, so you would need to use an applicable pg_restore version
9 Replies
Project ID:
9a791893-6f16-433d-9ecc-20dafacdc2ac
what version of pg_restore are you using?
9a791893-6f16-433d-9ecc-20dafacdc2ac
Solution
the latest backup template would be using pg_dump 16, so you would need to use an applicable pg_restore version
My versiom 14.7
How do I update my pg_restore version to 15?
16
download a newer version
do I have to download a new version of Postgres or can I just download a new version of pg_restore
download a newer version of pg_restore
OK will give it a go thanks