Your message dated Wed, 19 Jun 2013 14:55:02 +0200
with message-id <[email protected]>
and subject line Re: Bug#550390: [postgresql-8.4] main.log uses wrong encoding 
sometimes/by default
has caused the Debian Bug report #550390,
regarding [postgresql-8.4] main.log uses wrong encoding sometimes/by default
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
550390: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=550390
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-8.4
Version: 8.4.1-1
Severity: minor

The main.log seems to use wrong encoding most of the time. The content is in 
French, as my locale fr_CA.UTF-8 dictates. But for many messages, the accented 
characters display like garbage.

$ file /var/log/postgresql/postgresql-8.4-main.log
/var/log/postgresql/postgresql-8.4-main.log: UTF-8 Unicode text

But if I open it with less, I get garbage. I couldn't even find an encoding 
that worked using kwrite (tried ISO-8859-1). So I don't know what wrong 
encoding it would be using. When using UTF-8, some of the messages (probably 
from phppgadmin) display correctly. The problematic messages include startup 
messages (as triggered by invoke-rc.d postgresql-8.4 restart).

--- System information. ---
Architecture: i386
Kernel:       Linux 2.6.30-1-amd64

Debian Release: squeeze/sid
  990 testing         security.debian.org 
  990 testing         ftp.ca.debian.org 
  500 unstable        ftp.ca.debian.org 
    1 experimental    ftp.ca.debian.org 

--- Package information. ---
Depends                               (Version) | Installed
===============================================-+-======================
libc6                                  (>= 2.4) | 2.9-25
libcomerr2                            (>= 1.01) | 1.41.9-1
libgssapi-krb5-2                (>= 1.6.dfsg.2) | 1.7dfsg~beta3-1
libkrb5-3                       (>= 1.6.dfsg.2) | 1.7dfsg~beta3-1
libldap-2.4-2                        (>= 2.4.7) | 2.4.17-1
libpam0g                          (>= 0.99.7.1) | 1.1.0-4
libpq5                    (>= 8.4~0cvs20090328) | 8.4.1-1
libssl0.9.8                       (>= 0.9.8f-5) | 0.9.8k-5
libxml2                             (>= 2.6.27) | 2.7.5.dfsg-1
postgresql-client-8.4                           | 8.4.1-1
postgresql-common                      (>= 98~) | 101
tzdata                                          | 2009m-1
ssl-cert                                        | 1.0.23
locales                                         | 2.9-25


Package's Recommends field is empty.

Suggests          (Version) | Installed
===========================-+-===========
oidentd                     | 
 OR ident-server            | 




2009-10-09 14:14:46 EDT LOG:  le syst?me de bases de donn?es a ?t? arr?t? ? 2009-10-09 14:14:45 EDT
2009-10-09 14:14:46 EDT LOG:  paquet de d?marrage incomplet
2009-10-09 14:14:47 EDT FATAL:  le syst?me de bases de donn?es se lance
2009-10-09 14:14:47 EDT LOG:  lancement du processus autovacuum
2009-10-09 14:14:47 EDT LOG:  le syst?me de bases de donn?es est pr?t pour accepter les connexions
2009-10-09 14:15:27 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << tikidbuser >>
2009-10-09 14:15:27 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << tikidbuser >>
2009-10-09 14:21:24 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << tikidbuser >>
2009-10-09 14:21:24 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << tikidbuser >>
2009-10-09 14:21:38 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << postgres >>
2009-10-09 14:21:38 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << postgres >>
2009-10-09 14:21:53 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << postgres >>
2009-10-09 14:21:53 EDT FATAL:  authentification par mot de passe ?chou?e pour l'utilisateur  << postgres >>
2009-10-09 14:28:42 EDT ATTENTION:  utilisation non standard de \\ dans une chaîne littérale au caractère 263
2009-10-09 14:28:42 EDT ASTUCE :  Utilisez la syntaxe de chaîne d'échappement pour les antislashs, c'est-à-dire E'\\'.
2009-10-09 14:29:21 EDT ATTENTION:  utilisation non standard de \\ dans une chaîne littérale au caractère 494
2009-10-09 14:29:21 EDT ASTUCE :  Utilisez la syntaxe de chaîne d'échappement pour les antislashs, c'est-à-dire E'\\'.
2009-10-09 14:29:22 EDT ERREUR:  la relation « pg_autovacuum » n'existe pas au caractère 157
2009-10-09 14:29:22 EDT INSTRUCTION :  SELECT vacrelid, nspname, relname, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit 
						FROM pg_autovacuum join pg_class on (oid=vacrelid) join pg_namespace on (oid=relnamespace) ORDER BY nspname, relname
2009-10-09 14:41:53 EDT ERREUR:  la relation « pg_autovacuum » n'existe pas au caractère 157
2009-10-09 14:41:53 EDT INSTRUCTION :  SELECT vacrelid, nspname, relname, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit 
						FROM pg_autovacuum join pg_class on (oid=vacrelid) join pg_namespace on (oid=relnamespace) ORDER BY nspname, relname
2009-10-09 14:41:55 EDT ERREUR:  la relation « pg_autovacuum » n'existe pas au caractère 157
2009-10-09 14:41:55 EDT INSTRUCTION :  SELECT vacrelid, nspname, relname, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit 
						FROM pg_autovacuum join pg_class on (oid=vacrelid) join pg_namespace on (oid=relnamespace) ORDER BY nspname, relname
2009-10-09 14:41:58 EDT ERREUR:  la relation « pg_autovacuum » n'existe pas au caractère 157
2009-10-09 14:41:58 EDT INSTRUCTION :  SELECT vacrelid, nspname, relname, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit 
						FROM pg_autovacuum join pg_class on (oid=vacrelid) join pg_namespace on (oid=relnamespace) ORDER BY nspname, relname
2009-10-09 14:41:59 EDT ERREUR:  la relation « pg_autovacuum » n'existe pas au caractère 157
2009-10-09 14:41:59 EDT INSTRUCTION :  SELECT vacrelid, nspname, relname, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit 
						FROM pg_autovacuum join pg_class on (oid=vacrelid) join pg_namespace on (oid=relnamespace) ORDER BY nspname, relname
2009-10-09 14:49:45 EDT LOG:  paquet de d?marrage incomplet
2009-10-09 14:49:46 EDT LOG:  a re?u une demande d'arr?t rapide
2009-10-09 14:49:46 EDT LOG:  annulation des transactions actives
2009-10-09 14:49:46 EDT LOG:  arr?t du processus autovacuum
2009-10-09 14:49:46 EDT LOG:  arr?t en cours
2009-10-09 14:49:46 EDT LOG:  le syst?me de base de donn?es est arr?t?
2009-10-09 14:49:47 EDT LOG:  le syst?me de bases de donn?es a ?t? arr?t? ? 2009-10-09 14:49:46 EDT
2009-10-09 14:49:47 EDT LOG:  lancement du processus autovacuum
2009-10-09 14:49:47 EDT LOG:  le syst?me de bases de donn?es est pr?t pour accepter les connexions
2009-10-09 14:49:48 EDT LOG:  paquet de d?marrage incomplet

--- End Message ---
--- Begin Message ---
Re: Filipus Klutiero 2009-10-09 <[email protected]>
> Package: postgresql-8.4
> Version: 8.4.1-1
> Severity: minor
> 
> The main.log seems to use wrong encoding most of the time. The content is in 
> French, as my locale fr_CA.UTF-8 dictates. But for many messages, the 
> accented characters display like garbage.

postgresql-common (142) unstable; urgency=low

  * pg_ctlcluster: Set LANG so non-ascii chars in the server log are not
    replaced by '?'. Thanks to Adrian Vondendriesch for help debugging this.
    (Closes: #671915)

 -- Martin Pitt <[email protected]>  Tue, 07 May 2013 11:11:58 +0200

Christoph
-- 
[email protected] | http://www.df7cb.de/

--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

Reply via email to