Hi all,
I understand that PostgreSQL isn't as well supported by mediawiki as MySQL is, but it's what I am familiar with, so I use it. :) Specifically, I already use it on my server (Debian Lenny), and I want to install it on my laptop for devel and testing (Ubuntu 9.10), so I actually really need to stick with PostgreSQL at this point. Which brings me to my problem;
I tried just copying my MW install and database to the laptop, but I get a bunch of PgSQL errors:
------------------------------------- Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...diaWikiBagOStuff::_doquery */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: .../* MediaWikiBagOStuff::_doquery 127.0.0.1 */ FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: .../* MediaWikiBagOStuff::_doquery 127.0.0.1 */ FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "page" does not exist LINE 1: ...eCache::loadFromDB 127.0.0.1 */ page_title FROM page WHER... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 MediaWiki internal error.
Exception caught inside exception handler -------------------------------------
How do I know if I am doing something wrong WRT restoring from backup versus a MW + PgSQL 8.4 bug? I simply do 'pg_dump an_wiki -U digimer > an_wiki.out' and use the resulting file to load back the DB: 'psql an_wiki -U digimer -f an_wiki.out'; Nothing special.
Thanks!
Madi
mediawiki-l@lists.wikimedia.org