New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

-F/--format option for dump/restore command #52

Open
invl opened this Issue Sep 24, 2014 · 2 comments

Comments

Projects
None yet
2 participants
@invl

invl commented Sep 24, 2014

sql format could be large and painful to sync between servers.

Since we now have postgresql:console, postgresql:restore probably should use pg_dump's counterpart pg_restore instead of psql

@hakunin

This comment has been minimized.

Show comment
Hide comment
@hakunin

hakunin Nov 4, 2014

+1 Absolutely, heroku for instance gives you just the small format

hakunin commented Nov 4, 2014

+1 Absolutely, heroku for instance gives you just the small format

@hakunin

This comment has been minimized.

Show comment
Hide comment
@hakunin

hakunin Nov 4, 2014

Ha, just found an easy way of working this around:

pg_restore -O latest.dump | dokku postgresql:restore <db_name>

The pg_restore command will gladly uncompress the file for you and you can feed it to restore in pure sql via pipe.

Note: the -O option means the database should not export information about the old owner.

hakunin commented Nov 4, 2014

Ha, just found an easy way of working this around:

pg_restore -O latest.dump | dokku postgresql:restore <db_name>

The pg_restore command will gladly uncompress the file for you and you can feed it to restore in pure sql via pipe.

Note: the -O option means the database should not export information about the old owner.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment