pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
change Log language
2+ messages / 2 participants
[nested] [flat]

* change Log language
@ 2022-11-11 15:42 fernando violante <fer_violante@live.com>
  2022-11-11 15:56 ` Re: change Log language Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: fernando violante @ 2022-11-11 15:42 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: change Log language
  2022-11-11 15:42 change Log language fernando violante <fer_violante@live.com>
@ 2022-11-11 15:56 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2022-11-11 15:56 UTC (permalink / raw)
  To: fernando violante <fer_violante@live.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2022-11-11 15:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-11 15:42 change Log language fernando violante <fer_violante@live.com>
2022-11-11 15:56 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox