Thread: 7.2 back to 7.1.3
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
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
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 >