heroku postgres dump - not working locally

Question

I have done this:

heroku pgbackups:capture 
heroku pgbackups:url 
downloaded file from url obtained from above result

Created psql db "abc"

Ran this comamnd locally:

pg_restore --verbose --clean -no-acl --no-owner -U uname -d abc  ~/Downloads/b001.dump

output:

pg_restore: connecting to database for restore
pg_restore: implied data-only restore

I have loaded in 2ways. First created db, and directly ran pg_restore command. Then no tables created.

Then, thinking that dump contains only data, I have run migrations(means create table structure) on the new created db and ran pg_restore command. But still table data is empty.

You can look at the dump file, it is a normal text file. There should be a lot of CREATE TABLE at the top of the file. — some
– some, Commented Nov 12, 2013 at 4:04
I think I found the problem: you are using -no-acl instead of --no-acl.. and getting -a that means "import only data". — some
– some, Commented Nov 12, 2013 at 4:05
Added it as an answer so you can mark it as accepted AND vote on it :) — some
– some, Commented Nov 12, 2013 at 4:10

some · Accepted Answer · 2013-11-12 04:08:43Z

8

If you are running the command exactly as you have written you have an error:

You have written -no-acl instead of --no-acl and are getting -a that means:

-a, --data-only

Restore only the data, not the schema (data definitions).

answered Nov 12, 2013 at 4:08

some

49.8k14 gold badges84 silver badges96 bronze badges

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

1 Comment

Chris Nicola Over a year ago

lol, thanks. Just did this myself. I don't think I would have ever seen that.

Collectives™ on Stack Overflow

heroku postgres dump - not working locally

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related