Re: Migrating from MySQL to PostgreSQL

2011-10-31 Thread Mail Team
Just to close the loop, I needed to delete all entries whose "model" was "contenttypes.contenttype" or "scmtools.tool". Then it worked like a charm! Thanks for pointing me ad dumpdata/loaddata, *way* easier than what I was trying to do with the database manually! Ian On Mon, Oct 31, 2011 at 3:5

Re: Migrating from MySQL to PostgreSQL

2011-10-31 Thread Mail Team
Oh, I needed to add ".json" to the end of the filename, doh! But now I'm getting this one. IntegrityError: duplicate key value violates unique constraint "django_content_type_app_label_model_key" DETAIL: Key (app_label, model)=(changedescs, change description) already exists. Ian On Sat, Oct 2

Re: Migrating from MySQL to PostgreSQL

2011-10-29 Thread Mail Team
I did the dump like this which seemed to go fine. sudo rb-site manage /path/to/site dumpdata > /another/path/rbdump But when I try to load it, nothing happens. sudo rb-site manage /path/to/new/site loaddata /another/path/rbdump No fixtures found. Does that mean anything to you? Ian On Mon, Sep

Re: Migrating from MySQL to PostgreSQL

2011-09-26 Thread Mark
I recently migrated our SQLite RB database to PostgreSQL. You probably have two options, first you could use rb-site manage . dumpdata however that didn't work for me (I think it was because our database was too big). I ended up having to create a new reviewboard instance, delete all the records ou