Re: Stuck (again) trying to move a 7.x app and database to 8.2

Interesting. I did already discover (and had confirmed) that the pg_dump
backups coming from the 7.x machine were useless without the globals. I
went into the office where the 7.x machine is today and did full backups
with pg_dumpall. Hopefully this will help.

I also scrapped the 8.2 on the new box and installed 7.3 - the oldest
version I could find prebuilt for FC6. Now that I have proper backups,
maybe these will work. Sadly, I can't easily connect from one machine to
another. The only connection possible would be through my 768K DSL and
that would take days to transfer anything.

Thank you for the link. I will click on it immediately if not sooner!

Howard

Tommy Gildseth wrote:
> On 06/15/2007 08:07 PM, Howard Eglowstein wrote:
>> Hi all. I asked this question back on January and got a lot of
>> helpful advice, but I never did get the thing up and running. Now
>> that I have time again, I need to get an application and database
>> running on a Debian machine with PSQL 7.x running on a Fedora machine
>> running 8.2.
>>
>> Here's what I've done:
>>
>> 1) I installed 8.2 on the new machine. The installation doesn't
>> complain about anything, and 'initdb' says it inited stuff.
>>
>> 2) The old database makes daily backups with a command like 'pg_dump
>> -U backup -Ft -b data > 20070615.tar'
>>
>> 3) I copied the 20070615.tar file over to the new machine and tried
>> restoring it with 'pg_restore 20070615.tar'
>
>
> You're going to run into problems if you're trying to import a dump
> dumped with a 7.4 pg_dump, into a v8.2 database. Try using the
> pg_dump on your FC machine, to dump the database from your Debian
> machine.
>
>
> I've written up a little list of what I did when I upgraded my stock
> Debian 7.4 postgreSQL, to the latest 8.2 version a while ago, at
> http://www.gildseth.com/pg74-82-migration.html
> Maybe that can be of some help?
>