Skip to content

Latest commit

 

History

History
30 lines (24 loc) · 821 Bytes

README.md

File metadata and controls

30 lines (24 loc) · 821 Bytes

Ruby script for transferring Postgres databases

Based on ddollar's heroku-pg-transfer plugin.

$ ./pg-transfer --help

Usage: ./pg-transfer [options]
-f, --from URL                   Source database URL
-t, --to URL                     Target database URL
-b, --tables-include TABLE_LIST  Tables to copy, defaults to all
-B, --tables-exclude TABLE_LIST  Tables to exclude, defaults to none

Example:

$ ./pg-transfer --from=postgres://user1:pass1@host1:5432/db1 --to=postgres://user2:pass2@host2:5432/db2

Source database: db1 on host1:5432
Target database: db2 on host2:5432
Are you sure? [y/n]
y
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
...
pg_restore: connecting to database for restore
...