I found this blog entry which guides you to do these steps:
-
Create a dump of the PostgreSQL database.
ssh -C username@hostname.com pg_dump --data-only --inserts YOUR_DB_NAME > dump.sql
-
Remove/modify the dump.
- Remove the lines starting with
SET
- Remove the lines starting with
SELECT pg_catalog.setval
- Replace true for ‘
t
’ - Replace false for ‘
f
’
- Remove the lines starting with
-
Add
BEGIN;
as first line andEND;
as last line -
Recreate an empty development database.
bundle exec rake db:migrate
-
Import the dump.
sqlite3 db/development.sqlite3 sqlite> delete from schema_migrations; sqlite> .read dump.sql
Of course connecting via ssh and creating a new db using rake are optional