pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedchange 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