linux at alteeve
Oct 16, 2009, 10:30 AM
Post #1 of 1
(860 views)
Permalink
|
|
Problem restoring MW 1.15.1 DB from PostgreSQL 8.3 to PostgreSQL 8.4
|
|
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 mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
|
