How to disable Postgresql messages translation

internationalization, jdbc, postgresql

Solution

You could change lc_messages in postgresql.conf or just per database:

ALTER DATABASE dbname SET lc_messages=en_us;

See also the manual.

Problem

Is there a way to disable the Postgresql translation of messages? I´m running my appl and Postgresql on a pt_BR Windows machine and when a exception is thrown the error message is translated to Portuguese, like: Caused by: org.postgresql.util.PSQLException: ERRO: relação "unidade_federacao" não existe Posição: 25 I would like the messages to appear in English. I´m using the driver postgresql-8.4-701.jdbc3.jar on a Java (with Hibernate) app. thanks in advance, Fabrício Lemos

Original source