Re: Postgres Backup and Restore

"Phillip Smith" <phillip.smith@weatherbeeta.com.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