Converting Satellite 6 databases to UTF-8 encoding
Issue
- Satellite 6 Postgresql databases (candlepin, foreman, gutterball) are not UTF-8 encoded:
# su - postgres
$ psql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+----------+----------+-----------------+-----------------+-------------------------
candlepin | postgres | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 | =T/postgres +
| | | | | postgres=CTc/postgres +
| | | | | candlepin=CTc/postgres
foreman | foreman | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 | =T/foreman +
| | | | | foreman=CTc/foreman
gutterball | postgres | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 | =T/postgres +
| | | | | postgres=CTc/postgres +
| | | | | gutterball=CTc/postgres
postgres | postgres | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 |
template0 | postgres | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | LATIN1 | en_GB.ISO8859-1 | en_GB.ISO8859-1 | =c/postgres +
| | | | | postgres=CTc/postgres
(6 rows)
Environment
- Satellite 6.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.