Upgrading from 6.3.2 to 7.0.2

From: Chris Sterling <lemmy(at)eaze(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading from 6.3.2 to 7.0.2
Date: 2000-09-14 16:44:26
Message-ID: Pine.LNX.4.21.0009141136060.4919-100000@mail.eaze.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I've got a database I would like to upgrade from 6.3.2+phpfi 2.0 to
7.0.2+php 4.0. I've found the changes needed to be made to the php code,
and that should not be a problem. The real issue I'm having at this point
is getting the data into 7.0.2, or any newer release of PostgreSQL. I've
tried the pg_upgrade, but it does not seem to work for 6.3.2 -> 6.5.3.
Should I try 6.4 first, then 6.5.3, then 7.0? I've tried pg_dump and
pg_dumpall, but the data will not insert into the newer version
database. Do I need to provide some err info here? What would be helpful?

Notes on this setup: I've inherited the DBA position for this database. I
know the people who designed and built it, but cannot get any help from
them. They added some special charactor types and some compiled C code to
the postgres install, and I think that may be what's throwing the process
out. Any suggestions?

Thank you,

Chris Sterling
lemmy(at)eaze(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Hall 2000-09-14 16:56:26 Unable to install DBD module
Previous Message Tom Lane 2000-09-14 16:36:30 Re: Corrupt Table

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-09-14 16:59:01 Touched-up regression tests
Previous Message Stephan Szabo 2000-09-14 16:02:19 Re: Show triggers in psql?