change Log language

Started by fernando violanteover 3 years ago2 messagesgeneral
Jump to latest
#1fernando violante
fer_violante@live.com

Hi,

I need to change the language of the log from Spanish to English, , but I understand that this change drop tables database .

Is there a mechanism to make this change without losing data?

Thank you in advance

Fer

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: fernando violante (#1)
Re: change Log language

fernando violante <fer_violante@live.com> writes:

I need to change the language of the log from Spanish to English, , but I understand that this change drop tables database .

Uh ... no. All you need to do is change lc_messages, eg like

alter system set lc_messages to 'en_US';

and "pg_ctl reload".

regards, tom lane