Re: Changing Character Sets

Tim Gustafson <tjg(at)ucsc(dot)edu> 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°