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