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
--
Greg Sabino Mullane greg(a)endpoint.com
End Point Corporation
PGP Key: 0x14964AC8