Postgresql – Getting “[archiver] unsupported version (1.13) in file header” when running pg_restore

herokupg-restorepostgresql

I just upgraded to postgres 10.2 on mac os which matches 10.2 on heroku. I'm trying to download a copy of the database and restore it locally. Before the upgrade the restore would work fine.

I run

pg_restore --verbose --clean --no-acl --no-owner -h localhost -d database_name backup.dump

but I am getting this error:

pg_restore: [archiver] unsupported version (1.13) in file header

The database appears to be working OK. It's a rails app and I upgraded the pg gems. I can run rake db:create and db:migrate just fine.

Best Answer

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).

Related Solutions

Postgresql – Rails 3.1 – Pushing to Heroku – Errors installing postgres adapter

Option 1:

Add pg to your Gemfile but skip trying to install it locally.

$ cat Gemfile
...
group :production do
  # gems specifically for Heroku go here
  gem "pg"
end

# Skip attempting to install the pg gem
$ bundle install --without production

Option 2 (Debian/Ubuntu):

Add pg to your Gemfile but first install the prerequisites.

$ cat Gemfile
...
group :production do
  # gems specifically for Heroku go here
  gem "pg"
end

# Install the pg gem's dependencies first
$ sudo apt-get install libpq-dev
# Then install the pg gem along with all the other gems
$ bundle install

Ruby-on-rails – Heroku on Rails – Invalid DATABASE_URL

You need to set the DATABASE_URL environment variable with the path to your online postgres db.

Try running heroku pg. If the output is "myapp has no heroku-postgresql databases." then you need to add the PostgreSQL add-on first. It will create a postgres db for you on Amazon AWS.

heroku addons:add heroku-postgresql:hobby-basic

(hobby-basic is the free plan)

To find the URL for your new database, run

heroku config

You should see a variable that starts with HEROKU_POSTGRESQL. Copy its value (it should start with postgres:// and use it to set the DATABASE_URL

heroku config:set DATABASE_URL=postgres://your-db-url

Best Answer

Related Solutions

Postgresql – Rails 3.1 – Pushing to Heroku – Errors installing postgres adapter

Ruby-on-rails – Heroku on Rails – Invalid DATABASE_URL

Related Topic