It turns out that this is becoming more of a hassle than I thought it would be. I've just spent the last few hours trying to migrate all of my live data from an older revision of Wikidot 1 to a new server with the latest revision (196). It seemed like the tables populated properly, but I'm running into a number of database errors, mostly related to duplicate keys.
The approach I took (and it seemed like it should work well), was to export my live database using PGAdmin3. I then spent a lot of time editing the dump.sql file that is distributed with Wikidot. I simply copied all of the sql COPY commands stdin data from my live data into the corresponding place in the dump.sql file.
I did have to redo things a couple of times because I noticed that the structure of some tables changed (well, at least one table for sure - categories). I'm going to have to spend some more time comparing the table structure before I try this again (unless a Postgresql guru can give me some help!)
I suspect this would be a lot less painful if I was going from one machine to another with the same version of everything on both machines. In my case I've got an old version of Wikidot on psql 8.2 trying to move to the latest revision of Wikidot and psql 8.3.
Stay tuned! I'll be trying again in a couple of days.
-Ed
(account deleted)