Skip to content
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 

Repository files navigation

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

About

Transfer Postgres databases

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages