Re: Invalid UTF8 & Large Objects

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