Re: Problems migrating ReviewBoard from MySQL to PostgreSQL

2013-04-25 Thread David Lee
On Wednesday, April 24, 2013 3:05:05 PM UTC-5, Christian Hammond wrote: Hi David, How did you attempt the migration? Converting raw SQL, or using the dumpdb/loaddb management commands? dumpdb/loaddb. Here's the process we're using: root@old-machine# rb-site manage /var/www/reviewboard

Re: Problems migrating ReviewBoard from MySQL to PostgreSQL

2013-04-25 Thread David Lee
On Thursday, April 25, 2013 8:56:41 AM UTC-5, David Lee wrote: On Wednesday, April 24, 2013 3:05:05 PM UTC-5, Christian Hammond wrote: Hi David, How did you attempt the migration? Converting raw SQL, or using the dumpdb/loaddb management commands? dumpdb/loaddb. Here's the process

Problems migrating ReviewBoard from MySQL to PostgreSQL

2013-04-24 Thread David Lee
We have an existing ReviewBoard setup that we're trying to migrate from an old MySQL infrastructure to a shiny new PostgreSQL setup. We've gotten it to the point where the migration seems to work fine for reading the data out of the PostgreSQL database, and for some simple changes. But when we

Timestamps are off after 1.6.3 to 1.7.6 upgrade

2013-03-20 Thread David Lee
This morning, I upgraded our ReviewBoard installation from 1.6.3 to 1.7.6, and almost everything went smoothly. The only problem we've had with the upgrade is that the timestamps for pre-upgrade reviews, comments, etc. are wrong. Timestamps for new content are correct. I've set the Time Zone