on the new database server:

su - postgres createdb wikidb createuser wikidb

• none admin
• allow creation of databases
• disallow grants

psql: alter role wikidb with password 'wikidbuserpass'; \q

The new user will also need to have the correct search_path set. And the time zone and date display. This can be done manually or just by rerunning the installer/updater. The latter is a step you should always take when moving to a new wiki.

Alternatively, you could simply make sure you are also dumping all the users in their entirety for the new wiki like so:

(old server) pg_dumpall --globals > users.pg (new server) psql -f users.pg