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

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?

--
Tommy