Postgres Restore Error after database plugin migration

AnonymousTRIAL

a year ago

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?

0 Replies

a year ago

what version of pg_restore are you using?


AnonymousTRIAL

a year ago

9a791893-6f16-433d-9ecc-20dafacdc2ac


a year ago

the latest backup template would be using pgdump 16, so you would need to use an applicable pgrestore version


AnonymousTRIAL

a year ago

My versiom 14.7


AnonymousTRIAL

a year ago

How do I update my pg_restore version to 15?


AnonymousTRIAL

a year ago

16


a year ago

download a newer version


AnonymousTRIAL

a year ago

do I have to download a new version of Postgres or can I just download a new version of pg_restore


a year ago

download a newer version of pg_restore


AnonymousTRIAL

a year ago

OK will give it a go thanks


Postgres Restore Error after database plugin migration - Railway Help Station