Tim Gustafson <tjg@xxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general