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
pgsql-general is the one you want, it has the most traffic and people
are very helpful.
Postgresql also has a wiki
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.
--- Let us all bask in television's warm glowing warming glow ---
Scott Brunza 860.326.3637 scottso(a)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
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.