Tim Gustafson <tjg@xxxxxxxx> wrote: > 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. use pg_dump instead of pg_dumpall, because of the lack of a -E - Swich for pg_dumpall. Found http://postgresql.1045698.n5.nabble.com/Encoding-problem-using-pg-dumpall-td1911202.html it's from 2009, money quote: ,----[ ] | (Hmm, actually it looks like pg_dumpall hasn't got a -E switch, | which seems like an oversight. So you need to fix your locale, | or else use pg_dump directly.) | | regards, tom lane `---- Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
