Language conversion Japanese to English for PostgresSQL Database

[amandale]

Hi All,

I have PostgresSQL installed on windows and RHEL machine in Japanese language. Also OS both ( windows and RHEL ) installed in Japanese language.

I am as English user not able to any administration on PostgresSQL Database.

So Can any one please let me know how I can change the PostgresSQL Database console language to English only for me, so I can do administration work and other Japanese user also dont have issue as they will work as before as Japanese.

Is there any language pack need to installed on Database Level .

Plaese help me with this information.

Thanks,

Atul.

[sivamekala]

Hi Amandale, 

Sorry to inform you that, As these settings are Global.  We do not have such facility to change Host Language or Database Language for specific user or time. 

Please let me know if you need anymore details. 

Regards

Siva.

[amandale]

I want to change the language at console level to do the database operations in English. 

[sivamekala]

Hello, 

We understand your concern, But we cannot change language at console level or for specific user. These are system wide settings.  

Regards

Siva.

[amandale]

Thanks Siva for reply.

If I am using Unix system and change language at profile level in OS to English. is there any posibility I will get PostgresSQL console in English.

Also same for windows OS , If we installed English language pack on windows OS and login as English user on OS , what console I will have ?

Thanks 

Atul

[sivamekala]

Hi Atul, 

I kindly request you to please have a look at these. Below details might help when dealing with locale settings.

https://access.redhat.com/solutions/974273

https://www.postgresql.org/docs/9.0/locale.html

Regards

Siva.