Hi, I am realizing, hopefully not to late, that I need to convert my database to postgresql so that I can have concurrent sessions and all the other goodness that it brings to the table. Is there an easy way to convert? I am trying to do it on the command line, but it isn't working so well. I am kind of new to postgres and even sqlite
I tried this dump/import command, but it does not work. It didn't seem to like "PRAGMA" so I removed it (sqlite3 universe.sqlite .dump|grep -v 'PRAGMA'|psql chapman galaxy) 2>&1|less
BEGIN NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "migrate_version_pkey" for table "migrate_version" CREATE TABLE INSERT 0 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dataset_pkey" for table "dataset" CREATE TABLE ERROR: column "deleted" is of type boolean but expression is of type integer LINE 1: ...5:50:25.714594','2013-06-28 15:51:00.760008','ok',0,0,0,'/me... ^ HINT: You will need to rewrite or cast the expression. 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