SOLVED: [Gnumed-devel] Problems with bootstrap and recovery
From:
Rogerio Luz Coelho
Subject:
SOLVED: [Gnumed-devel] Problems with bootstrap and recovery
Date:
Thu, 29 Oct 2009 23:57:11 -0200
Ok I'll recolect my steps just so it looks good on future searches.
The problem occured in a fresh install of Debian Lenny's PostgreSQL-8.3 server (postgresql-8.3 family packages)
After install the Postres server automatically creates a "main" cluster witch inherits the LC_CTYPE of the system, the problem is that it does not have support for many of the locales the usual Lenny system has, as an example, my "pt_BR" system got Postgres to make a "LATIN1" cluster.
#------------------------------------------------------------ - You find this out by:
1) switching user to postgres ~# su postgres
2) starting psql address@hidden psql
3) asking the database encoding
postgres=# show server_encoding; (the dot-comma IS important)