C[omp]ute

From: andrew cooke <andrew@...>

Date: Thu, 29 Dec 2011 11:00:05 -0300

For my own sanity, this is a reference so I can more easily do the same in the
future.

This is for when re-installing a postgresl mediawiki database from a backup
(in this case, I had updated the OS and wanted to import the previous
version).

 - Install postgres (and apache and php etc) and get apache working
 - Start postgres
 - Modify the pg_hba.conf to restrict postgres to ident user on the same
   machine, and then add md5 entries for wikidb/wikiuser
 - Restart postgres
 - As postgres, create the wikiuser user with password
 - As postgres, create the wikidb database
 - Check you can connect to the wikidb database as the wikiuser
 - Load the database by doing something like:
   zcat backup.gz | psql -f - wikidb
 - Run the update.php script
 - Check that access works via the web page

Andrew