"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> writes:
> I've been thinking about this, and while I don't agree it's a bug, I think
> that perhaps PostgreSQL should raise a notice or warning that the
> destination database has different encoding than the file being restored...?
If Postgres actually *knows* that the encodings are different, it can
deal with that. The cases that are problematic are where the software
has been misinformed for one reason or another. I doubt that a warning
issued (or not) on the basis of misinformation will be especially helpful.
regards, tom lane