> > How does the output from "psql -l" look like?
> List of databases
> Database | Owner | Encoding
> ------------+----------+-----------
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
> Jacob
I don't know why your template1 DB's encoding is SQL_ASCII, but you
need to change the encoding of the DB anyway.
try:
psql -c "update pg_database set encoding = 7 where datname =
'template1'" template1
--
Tatsuo Ishii