[Mediawiki-l] Problem restoring MW 1.15.1 DB from PostgreSQL 8.3 to PostgreSQL 8.4

[Madison Kelly]

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