Re: 7.2 back to 7.1.3 - Mailing list pgsql-general

From Raymond C. Rodgers
Subject Re: 7.2 back to 7.1.3
Date
Msg-id 000395233065082f_mailit@192.168.0.1
Whole thread Raw
In response to Re: 7.2 back to 7.1.3  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL DBI DBD::Pg Access Problem
Next
From: "Dan Maher"
Date:
Subject: simple query question