I did the following and it worked. 1. Did a text pg_dump and used iconv to remove invalid characters and then loaded this into the database. 2. Took a dump created using -Fc and restored just the pg_largeobject table. Every thing seems to be good. I don't see the -b option in pg_dump in 8.1.3 so am I right in saying that large objects are automatically added to the dump? Thanks, -Prasanth. John DeSoi wrote: > > On Apr 25, 2006, at 4:17 PM, Prasanth wrote: > >> But then my problem is I have to do a text dump to use iconv in which >> case I will loose the large objects. >> I tried using the iconv on the dump generated using the -Fc option and >> then when I try to restore that I am getting the following error >> pg_restore: [archiver] entry ID 0 out of range -- perhaps a corrupt TOC > > -Fc produces a binary format, so you can't use iconv on it. One option > might be to write a script to export your large objects, dump text only > and fix with iconv, then reload the database and import the large objects. > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
