Hi,
We recently migrated from 7.4.7 to 8.1.3. I did a pg_dumpall & then
pg_restore and it went fine.
Today I realized that the backups I am creating can't be used to reload
my database.
I use pg_dump -Fc to dump the database as I have Large Objects in the
database.
(I used to use pg_dump -b -Fc in 7.4.7 seems like the -b option is taken
out in 8.1.3 so I assume they are included automatically)
I get the error "ERROR: invalid UTF-8 byte sequence detected........."
Did research online and fund out that it is because of invalid
characters in the database so started trying out the solution mentioned
in the posts that is by using iconv.
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
Any help will be appreciated.
Thanks,
-Prasanth.