> 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 [email protected] End Point Corporation PGP Key: 0x14964AC8
pgpNCnM2zI1HD.pgp
Description: PGP signature
_______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
