RE: Upgrading from 6.3.2 to 7.0.2

I wouldn't recommend pg_upgrade as 6.3 is quite old, pg_dump should be a
better option.

Since you are having trouble with pg_dump also, we would probably need some
actual errors to be able to help. One suggestion is to dump everything out
with proper inserts ( use the -d or -D option for this), this alleviates
some problems. However there might be some schema problems such as data
types that have changed and are not supported. If that is the problem ,
then you need to edit the pg_dump file and change the table create commands.

my 2¢

> -----Original Message-----
> From: Chris Sterling [SMTP:lemmy(at)eaze(dot)net]
> Sent: Thursday, September 14, 2000 11:44 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Upgrading from 6.3.2 to 7.0.2
>
>
>
> 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
>