Bug#671915: postgresql breaks logs
Control: tags -1 confirmed Re: Dmitry E. Oboukhov 2012-05-08 20120508055141.ga25...@apache.rbscorp.ru Package: postgresql-9.1 Version: 9.1.3-2 Tags: l10n Since (I think) I've upgraded postgresql server upto 9.1 version I see broken logs. The previous versions of Pg wrote logs in English. Current version writes part of logs in Russian and part in '?' symbols: The problem here is that pg_ctlcluster initializes the environment from /etc/postgresql/9.1/main/environment, which is usually empty. If you don't have any LANG/LC_* settings in the environment, postgres will log any non-ascii char as ?. We should probably copy the LANG/LC_* settings from the old environment over, or put LANG=$clusterlocale in the enviroment files (or both). Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#671915: postgresql breaks logs
Package: postgresql-9.1 Version: 9.1.3-2 Tags: l10n Since (I think) I've upgraded postgresql server upto 9.1 version I see broken logs. The previous versions of Pg wrote logs in English. Current version writes part of logs in Russian and part in '?' symbols: ... 2012-05-07 01:45:10 MSK ???: ??? ? ?? (? 6 ???.) 2012-05-07 01:45:10 MSK ?: , ? ? checkpoint_segments. 2012-05-07 01:45:16 MSK ???: ??? ? ?? (? 6 ???.) 2012-05-07 01:45:16 MSK ?: , ? ? checkpoint_segments. 2012-05-07 01:45:25 MSK ???: ??? ? ?? (? 9 ???.) 2012-05-07 01:45:25 MSK ?: , ? ? checkpoint_segments. 2012-05-07 01:45:52 MSK ???: ??? ? ?? (? 27 ???.) 2012-05-07 01:45:52 MSK ?: , ? ? checkpoint_segments. 2012-05-07 01:46:31 MSK ??: pgstat wait timeout 2012-05-07 01:46:33 MSK ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности orders_orderid_key 2012-05-07 01:46:33 MSK ПОДРОБНОСТИ: Ключ (orderid)=(0e5587a6260448398f7bddd86c4e8dc1) уже существует. ... $ grep lc_ /etc/postgresql/9.1/main/postgresql.conf lc_messages = 'ru_RU.UTF-8' # locale for system error message lc_monetary = 'ru_RU.UTF-8' # locale for monetary formatting lc_numeric = 'ru_RU.UTF-8' # locale for number formatting lc_time = 'ru_RU.UTF-8' # locale for time formatting -- . ''`. Dmitry E. Oboukhov : :’ : email: un...@debian.org jabber://un...@uvw.ru `. `~’ GPGKey: 1024D / F8E26537 2006-11-21 `- 1B23 D4F8 8EC0 D902 0555 E438 AB8C 00CF F8E2 6537 signature.asc Description: Digital signature
