Migrating from sqlite3 to postgresql on Rails 3?

Question

Following the post: How to migrate from SQLite to PostgreSQL (Rails)

I am running sqlite3 development.sqlite3 .dump | psql mypgdb mypguser in my Rails app and I'm getting this error (same for all models/tables in my app):

ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  syntax error at or near "AUTOINCREMENT"
LINE 1: ...E TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREM...

Would appreciate some suggestions/fixed. Thanks!

Richard Huxton · Accepted Answer · 2012-07-02 10:23:08Z

2

That's not valid SQL for PostgreSQL - you probably want a SERIAL instead of INTEGER AUTOINCREMENT. You may want to manually set the nextval of thesequence to max(id)+1 too.

Then you'll want to deal with all the other differences between a mostly-typeless sqlite and a strict PostgreSQL.

Then you'll want to stop using different systems on your development setup and in deployment. It's just causing yourself pain.

answered Jul 2, 2012 at 10:23

Richard Huxton

23.6k5 gold badges43 silver badges54 bronze badges

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

Comments

Bogdan M. · Accepted Answer · 2012-09-15 12:18:16Z

0

I recommand you to use gem "yaml_db", it's purpose is to move tables from one database to another. https://github.com/ludicast/yaml_db#readme

You can get everything done simply by this gem with a nice documentation. It has 2 basic commands so nothing difficult about it.

answered Sep 15, 2012 at 12:18

Bogdan M.

2,1817 gold badges31 silver badges56 bronze badges

Collectives™ on Stack Overflow

Migrating from sqlite3 to postgresql on Rails 3?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related