I need to create a database with SQL_ASCII encoding in Amazon RDS PostgreSql database instance.
template1 are both with utf8 encoding, I get the following error
$ createdb -h endpoint.rds.amazonaws.com -U user -E SQL_ASCII -T template0 createdb: database creation failed: ERROR: encoding "SQL_ASCII" does not match locale "en_US.UTF-8" DETAIL: The chosen LC_CTYPE setting requires encoding "UTF8".
In previous versions of Postgresql,
template0 had no predefined encoding, so that command gave no errors.
Also, I don't have permissions to change template1's enconding:
postgres=> update pg_database set datistemplate = FALSE where datname = 'template1'; ERROR: permission denied for relation pg_database
\l command says my user is the owner of