Is there any way to change the character set of a database and its tables?
I did a pg_dumpall to upgrade from Postgres 8.4 to Postgres 9.2, and
all the tables came back as UTF-8, and now Bacula is complaining that
it wants SQL_ASCII encoding for everything. I don't see a flag on
pg_dumpall or pg_restore to set which character encoding I'd like, and
Google has failed me.
--
Tim Gustafson
tjg(at)ucsc(dot)edu
831-459-5354
Baskin Engineering, Room 313A