Thread: 7.2 back to 7.1.3

7.2 back to 7.1.3

From
"Raymond Curtis Rodgers"
Date:
I find myself in an odd position. Some how, over the last few months, I ended up with a 7.2 [development] installation
whereonce I had a 7.1.3 installation. Now that I'm in the process of trying to migrate the data to another 7.1.3
installation,I appear to be stuck as pg_dump and pg_dumpall aren't working out for me. I get lots of errors on import
asyou might well imagine. 

Does anyone have any suggestions on how to correct this situation, or at least retrieve the data, tables, etc., without
havingto manually recreate it all? 

Thanks,
Raymond


Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com

Re: 7.2 back to 7.1.3

From
Andrew Gould
Date:
Have you tried dumping the database in 2 steps?
First, dump the database schema only.  Review and edit
the SQL manually. Then dump the database data only.
Once you can recreate the database structure without
problems, you can copy the data into the tables.

I hope I haven't oversimplified the issue.

Best of luck,

Andrew Gould


--- Raymond Curtis Rodgers <rcrodgers@eudoramail.com>
wrote:
> I find myself in an odd position. Some how, over the
> last few months, I ended up with a 7.2 [development]
> installation where once I had a 7.1.3 installation.
> Now that I'm in the process of trying to migrate the
> data to another 7.1.3  installation, I appear to be
> stuck as pg_dump and pg_dumpall aren't working out
> for me. I get lots of errors on import as you might
> well imagine.
>
> Does anyone have any suggestions on how to correct
> this situation, or at least retrieve the data,
> tables, etc., without having to manually recreate it
> all?
>
> Thanks,
> Raymond
>
>
> Join 18 million Eudora users by signing up for a
> free Eudora Web-Mail account at
> http://www.eudoramail.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly


__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com

Re: 7.2 back to 7.1.3

From
"Raymond C. Rodgers"
Date:
Actually, that was very close to what it took to solve the problem. (I just
fixed it a bit ago.) I had to manually remove some extra definition
information that 7.2 stuck on timestamp fields, remove the maxvalue for a
sequence or two, and kill any references to "REFERENCES" in my permissions.
But I managed to do it in a single step after that.

Thanks!
Raymond
>Have you tried dumping the database in 2 steps?
>First, dump the database schema only.  Review and edit
>the SQL manually. Then dump the database data only.
>Once you can recreate the database structure without
>problems, you can copy the data into the tables.
>
>I hope I haven't oversimplified the issue.
>
>Best of luck,
>
>Andrew Gould
>
>
>--- Raymond Curtis Rodgers <rcrodgers@eudoramail.com>
>wrote:
>> I find myself in an odd position. Some how, over the
>> last few months, I ended up with a 7.2 [development]
>> installation where once I had a 7.1.3 installation.
>> Now that I'm in the process of trying to migrate the
>> data to another 7.1.3  installation, I appear to be
>> stuck as pg_dump and pg_dumpall aren't working out
>> for me. I get lots of errors on import as you might
>> well imagine.
>>
>> Does anyone have any suggestions on how to correct
>> this situation, or at least retrieve the data,
>> tables, etc., without having to manually recreate it
>> all?
>>
>> Thanks,
>> Raymond
>>
>>
>> Join 18 million Eudora users by signing up for a
>> free Eudora Web-Mail account at
>> http://www.eudoramail.com
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please
>> send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org
>> so that your
>> message can get through to the mailing list cleanly
>
>
>__________________________________________________
>Do You Yahoo!?
>Check out Yahoo! Shopping and Yahoo! Auctions for all of
>your unique holiday gifts! Buy at http://shopping.yahoo.com
>or bid at http://auctions.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>