On 01/13/2010 10:35 AM, Scott Brunza wrote:
I'm in the middle of a server migration, and decided to upgrade my instance of mediawiki and postgres to versions 1.15.1 and 8.3.8 (stock SLES11 version) respectively. pg_dumps, restores, and db admin is nothing new to me, but I can't for the life of me get my instance (MW 1.9.3 and pg 8.1.11) into the new postgres. I've even tried moving from 8.1 to 8.2 as an intermediate step before going to 8.3. Nothing is working for me. Can someone clarify the steps for me? I have read the Manual:Upgrading_Postgres page.
What errors are you getting? What exact steps did you perform, and where does it fail to act like you think it should? Make sure the user (default of mwuser) is there and has its search_path set (select * from pg_user will show it).