pg_restore to postgres running in docker container

Question

I have a backup of a database that I would to restore to a postgres database running inside a docker container.

I'm using docker-machine on OS X.
Postgres image is postgres:9.4.

This is the script I've come up with so far:

pg_restore --verbose --clean --no-acl --no-owner \
  -h tcp://`docker-machine ip default`:5432 \
  -U postgres \
  -d tonsser-api_development latest.dump

But that doesn't work. I get the error:

pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "tonsser-api_development" failed: could not translate host name "tcp://192.168.99.100:5432" to address: nodename nor servname provided, or not known

Did you ever figure this out?

Abraham Sangha
– Abraham Sangha

2017-06-16 02:55:23 +00:00
Commented Jun 16, 2017 at 2:55 — Abraham Sangha
– Abraham Sangha, Commented Jun 16, 2017 at 2:55

nyx00 · Accepted Answer · 2018-09-12 14:12:59Z

5

There seems to be no proper solution to do this on runtime, however copying the dumpfile to the container:

docker cp dumpfile DBcontainer:/dumpfile

and restore from within the container:

docker  exec -i -t DBcontainer /bin/bash
psql DBname < dumpfile

worked well for a one time use...

edited Sep 12, 2018 at 14:12

answered Sep 12, 2018 at 12:08

nyx00

1063 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Caleb · Accepted Answer · 2017-10-21 08:33:28Z

1

You have to use a connection string, e.g. $DATABASE_URL

The following works well for me:

docker-compose exec fooapp pg_restore 
  --verbose --clean --no-acl --no-owner 
  -d $DATABASE_URL foo.dump

For extra points, you can create a rake task (assuming you're using a Rails app), as follows:

namespace :db do
  desc 'Import a given file into the database'
  task :import, [:path] => :environment do |_t, args|
    dump_path = args.path
    system 'pg_restore --verbose --clean --no-acl --no-owner -d $DATABASE_URL '\
    + dump_path
  end
end

Put that file in lib/tasks, then you can call something like:

docker-compose exec fooapp bundle exec rails db:import[foo.dump]

answered Oct 21, 2017 at 8:33

Caleb

3,8023 gold badges27 silver badges28 bronze badges

Comments

Mykola Gurov · Accepted Answer · 2015-11-30 11:47:38Z

0

Maybe because you have to specify host and port separately?

-h `docker-machine ip default` -p 5432

See docs

answered Nov 30, 2015 at 11:47

Mykola Gurov

8,7754 gold badges32 silver badges27 bronze badges

Collectives™ on Stack Overflow

pg_restore to postgres running in docker container

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related