Getting "[archiver] unsupported version (1.13) in file header" when running pg_restore
You need to upgrade your local postgres to get the last security patch from the 2018-03-01, like Heroku
did the 1st march. You need one of the last releases 10.3
, 9.6.8
, 9.5.12
, 9.4.17
, and 9.3.22
.
The security patch can be found here https://www.postgresql.org/about/news/1834/.
It seems the patch modified pg_dump, that's probably why we can't use pg_restore anymore without that patch for the dump of Heroku (with the patch applied).
Use pg_restore to restore from a newer version of PostgreSQL
pg_restore is only for restoring dumps taken in the "custom" format.
If you do a "plain text" dump you have to use psql to run the generated SQL script:
psql -f nvdls.db dbname username
Related Topics
SQL Server Dynamic PIVOT Query
Difference Between "INNER JOIN" and "OUTER JOIN"
Sql Average from Multiple Columns
How to Identify Rows Where Two Columns Have Match Exactly in SQL Server
Datediff Getting the Previous Month
Executing SQL Scripts on Docker Container
Unable to Get Min and Max Time from a Datetime Column from Every Backday
How to Make an If Statement in Ssis
How to Select Only 1 Row from Oracle SQL
Postgresql Convert Columns to Rows Transpose
Sql Select Join: How to Prefix All Columns as 'Prefix.*'
How to Convert Nvarchar to Numeric in SQL Server
Update Table Column With Different Random Numbers
How to Split a Comma-Separated Value to Columns
Sql Merge Two Rows With Same Id But Different Column Values (Oracle)