It is always a good practice to run Cast Support Tool https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock
Comment actions
Post
Follow
Version issue during Schema Restore
When you are trying to re-store the back up of schema to a server, you might receive the error: "pg_restore: [archiver] unsupported version (1.13) in file header"
This is caused due to two scenarios mainly:
- The backup was taken manually using a higher version of pgadmin than the one you are currently using. In this case you have to download the latest version of pgadmin and perform a restore via pgadmin.
- The backup was taken using the command pg_dump.exe instead of cssbackup.exe. In this case you have to restore the schema using the command pg_restore.exe. The command line must be as follows:
..CSSAdmin\3rdParties\x64pg11\pg_restore.exe --host YOURHOST--port 2280 --username "operator" --dbname "postgres" --password --verbose "YOUR CSSDUMP"
Please sign in to leave a comment.
Date
Votes
2 comments
It is always a good practice to run Cast Support Tool but there are cases where some users use scripts to take backup while upgrading and during such cases, there is a possibility of them using the command pg_dump.exe to take backup which results in this issue.
Comment actions