Re: [Gnumed-devel] Problems with bootstrap and recovery

[Jerzy Luszawski]

Wednesday 28 October 2009 03:09:36 Rogerio Luz Coelho napisał(a):
> I have a problem to recover a backup database:

> When fussing about I discovered this error while trying to simply bootstrap
> to latest ...
> 
> on a postgresql 8.3 new instalation of a Debian Stable (Lenny)
> 
> 
> 
> Your PostgreSQL installation seems not to have lc_ctype UTF-8 or C.
> This will most probably lead to failures of the GNUmed server installation.
> 
> 
> What to do now?
I remember I also had this message some time ago, and just ignored it. The 
reason was that my locale is pl_PL.UTF-8 and it was not properly recognized as 
UTF-8. 
Try to use psql and check your encoding, see:
--------------------
postgres=# show lc_ctype;
  lc_ctype
-------------
 pl_PL.UTF-8
(1 row)

postgres=# show server_encoding;
 server_encoding
-----------------
 UTF8
(1 row)
---------------------------

Can you force the bootstrap and check the encoding after bootstrapping?