Re: Changing Character Sets - Mailing list pgsql-general

Tim Gustafson <tjg@ucsc.edu> writes:
> I'm curious why a pg_dumpall from 8.4 followed by a restore in 9.2
> caused the character sets to change at all.  Was there some change in
> the default character sets between 8.4 and 9.2?

I was wondering that too.  You did use pg_dumpall, and not individual
pg_dumps per database?  In the latter case it's not hard to imagine
making a mistake, but pg_dumpall has been careful about database
properties for a long time.

            regards, tom lane