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.
-B-
--- Let us all bask in television's warm glowing warming glow --- Scott Brunza 860.326.3637 scottso@sonalysts.com
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
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).
to move the database
Postgresql does not do in-place upgrade of databases .
use pgdump from postgres 8.3 when backing up 8.1 database
Install postgresql 8.3 create the database then restore the backed up database to 8.3
if you are still having problems go to the postgresql mailing list http://www.postgresql.org/community/lists/ pgsql-general is the one you want, it has the most traffic and people are very helpful.
Postgresql also has a wiki http://wiki.postgresql.org/wiki/Main_Page
On 1/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.
-B-
--- Let us all bask in television's warm glowing warming glow --- Scott Brunza 860.326.3637 scottso@sonalysts.com
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.
CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately. Thank you.
mediawiki-l@lists.wikimedia.org