diff options
| author | John Paulett <john@paulett.org> | 2012-10-03 20:06:05 +0200 |
|---|---|---|
| committer | Claude Paroz <claude@2xlibre.net> | 2012-10-04 09:51:14 +0200 |
| commit | 725128289398ba4bce60a4093d9d69bbcea01d92 (patch) | |
| tree | 3c7026b1b2a7fe8ffe4f136b4b6aa2d4dd05c0b1 /docs | |
| parent | 89544b2bd2323cdc5c29e056838a23abcee07d6e (diff) | |
Fixed #17207 -- Added a troubleshooting note about failing createdb
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/ref/contrib/gis/install.txt | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/docs/ref/contrib/gis/install.txt b/docs/ref/contrib/gis/install.txt index 0ce8253210..355fb55a47 100644 --- a/docs/ref/contrib/gis/install.txt +++ b/docs/ref/contrib/gis/install.txt @@ -757,6 +757,21 @@ Similarly, on Red Hat and CentOS systems:: $ sudo yum install binutils +PostgreSQL's createdb fails +--------------------------- + +When the PostgreSQL cluster uses a non-UTF8 encoding, the +:file:`create_template_postgis-*.sh` script will fail when executing +``createdb``:: + + createdb: database creation failed: ERROR: new encoding (UTF8) is incompatible + with the encoding of the template database (SQL_ASCII) + +The `current workaround`__ is to re-create the cluster using UTF8 (back up any +databases before dropping the cluster). + +__ http://jacobian.org/writing/pg-encoding-ubuntu/ + Platform-specific instructions ============================== |