Re: Postgres Backup and Restore

"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