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

Поиск
Список
Период
Сортировка
Искать
От
Howard Eglowstein
Тема
Stuck (again) trying to move a 7.x app and database to 8.2
Дата
Msg-id
4672D563.5080906@yankeescientific.com
Список
Дерево обсуждения
Stuck (again) trying to move a 7.x app and database to 8.2 Howard Eglowstein <howard@yankeescientific.com>
Re: Stuck (again) trying to move a 7.x app and database to 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: Stuck (again) trying to move a 7.x app and database to 8.2 Tommy Gildseth <tommy@gildseth.com>
Re: Stuck (again) trying to move a 7.x app and database to 8.2 Howard Eglowstein <howard@yankeescientific.com>
Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau <ecomeau@signiant.com>
Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau <ecomeau@signiant.com>
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'

I will admit I don't know SQL enough to know how to view the data in the 
interactive terminal, but my app knew how to extract data and it says 
there's no data in the database.

Did I miss some obvious, critical step? I would appreciate any 
suggestions you may have, or better yet, if there's one of you out there 
that would like to consult for a few hours, I would gladly pay for your 
time (in the Boston, MA area) to fix this stupid thing.

Thank you in advance for your help.

Howard
В списке pgsql-novice по дате отправления
От: nhrcommu@rochester.rr.com
Дата:
От: Tom Lane
Дата:
FAQ