"Mikel Lindsaar" <raasdnil@gmail.com> writes:
> If you have bad character encodings in your data, you can not backup
> and restore that data using pg_dump and pg_restore, on Windows Server
> 2003, using compress or plain text modes. Both modes fail on the bad
> encoding when you try to restore.
Are you sure that the destination database has the same encoding
declaration as the source did? How was the badly-encoded data
inserted in the first place?
regards, tom lane