Package: postgresql-common
Version: 39
Followup-For: Bug #343057

This arised when client_encoding in postgresql.conf is not the same as
lc_ctype from pg_controldata. Reasons exist to set database to one byte 
charset while client work in unicode locale.
Simple workaround:

--- /usr/bin/pg_ctlcluster      2005-12-23 00:36:53.000000000 +0300
+++ ./pg_ctlcluster     2006-01-23 12:28:39.456450128 +0300
@@ -233,7 +233,7 @@
     }
      
           # set locale for the postmaster
           -    $ENV{'LC_ALL'} = $ENV{'LANG'} = $lc_ctype;
           +#    $ENV{'LC_ALL'} = $ENV{'LANG'} = $lc_ctype;
            
                 my $postmaster_opts = '-c unix_socket_directory="' .
                 $info{'socketdir'} . '"';

IMHO LC_ALL and LANG is not needed, postmaster set own locale by itself.
But if charmap of LANG is not equal client_encoding from postgresql.conf,
"psql -l" will be broken.

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-amd64-k8-smp
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)

Versions of packages postgresql-common depends on:
ii  adduser                       3.80       Add and remove users and groups
ii  debconf [debconf-2.0]         1.4.67     Debian configuration management sy
ii  lsb-base                      3.0-13     Linux Standard Base 3.0 init scrip

Versions of packages postgresql-common recommends:
ii  openssl                       0.9.8a-5   Secure Socket Layer (SSL) binary a

-- debconf information:
  postgresql-common/obsolete-major:


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to