Hello Adrian, Thank you for your reply again.
I will try to use your previous suggestion that I will backup 8.1 database using 9.0 pg_dump and restore it to 9.0 database. Hopefully, 9.0 pg_dump will work on 8.1 database. I have never taken a DB course and very very new to Postgres. Thanks again, 2011/4/16 Adrian Klaver <adrian.kla...@gmail.com> > On Saturday, April 16, 2011 1:10:39 pm Edison So wrote: > > Thank you for the reply. > > > > It has nothing to do with programming. I was trying to back up the 8.1 > > database (using pg_dump) which had exceeded 2Gig limit according to a > > response. When I tried to restore it using pg_restore to a 9.0 database, > it > > complained about custom archiver error and corruption and the whole > backup > > stopped. > > > > One response told me to try backing up 8.1 database using 9.0 pg_dump and > > restore it to 9.0 database using 9.0 pg_restore. Another option, I can > > think of, is to back up each table one at time and restore it one by one. > > This way the 2G limit will never come up during the backup. However, it > > requires a lot of works. > > If you are trying to restore forward to 9.0 you will need to use the 9.0 > version > of pg_dump in either case. If you are trying to create a backup to use on > the > 8.1 database you might try -Fp instead of -Fc to create the dump(untested). > The > bug seems to be with the binary dump version not the text version. > > > > > Any suggestion? > > > > Thanks, > > > > > -- > Adrian Klaver > adrian.kla...@gmail.com > -- Edison
