Rails / postgresql Migrate Data from Database to Newly created database

Question

I have an existing database on my server containing many tables with content. Now I have created a new database but some columns are added.

Is it possible to migrate all the data from the one database to the other.

Kind regards.

zcotter · Accepted Answer · 2013-07-22 22:17:06Z

2

I've used the yaml_db gem to migrate DBs: https://github.com/ludicast/yaml_db - this gem adds some rake tasks that are helpful

After installing the gem, you can run rake db:data:dump to save your database to a .yml file.

Then, after changing your database configuration, you can run rake db:data:load to load the data into your new database.

answered Jul 22, 2013 at 22:17

zcotter

2071 silver badge8 bronze badges

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

Comments

FastSolutions · Accepted Answer · 2013-07-23 06:57:12Z

1

I like your answer! But a more easy way is to dump the whole database like you said. But just transfer it to another server.

Like this:

To Dump:

pg_dump -U demo02 -h localhost -O demo02 > demo2.sql

To Restore:

psql -U demo3 demo3 < demo2.sql

answered Jul 23, 2013 at 6:57

FastSolutions

1,8171 gold badge27 silver badges53 bronze badges

1 Comment

jpw Over a year ago

This was very helpful, although a little confusing using the same text for the username and database name. pg_dump -U ADMINUSER1 -h localhost -O DBASENAME > dump.sql and psql -U ADMINUSER2 DBASENAME < dump.sql

Collectives™ on Stack Overflow

Rails / postgresql Migrate Data from Database to Newly created database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related