Debian Bug report logs - #571291
Use SQL_ASCII encoding when creating the PostgreSQL database

Reply or subscribe to this bug.

Display info messages

Message #5 received at [email protected] (full text, mbox, reply):

From: Michael Biebl <[email protected]>

To: Debian Bug Tracking System <[email protected]>

Subject: Use SQL_ASCII encoding when creating the PostgreSQL database

Date: Thu, 25 Feb 2010 01:14:40 +0100

Package: rsyslog-pgsql
Severity: normal

As reference:
http://lists.adiscon.net/pipermail/rsyslog/2010-January/003360.html

upstream recommends to create the postgresql db with encoding
'SQL_ASCII'

Determine, if we want to use SQL_ASCII in Debian or stick with the
default, UTF-8

dbconfig-common's dbc_pgsql_createdb_encoding allows to specify the
encoding but currently fails to create a db using SQL_ASCII as the
template db uses UTF-8.


-- System Information:
Debian Release: squeeze/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.33-rc8 (SMP w/1 CPU core)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages rsyslog-pgsql depends on:
ii  dbconfig-common               1.8.45     common framework for packaging dat
ii  debconf [debconf-2.0]         1.5.28     Debian configuration management sy
ii  libc6                         2.10.2-5   Embedded GNU C Library: Shared lib
ii  libpq5                        8.4.2-2+b1 PostgreSQL C client library
ii  rsyslog                       4.6.0-1    enhanced multi-threaded syslogd
ii  ucf                           3.0025     Update Configuration File: preserv

Versions of packages rsyslog-pgsql recommends:
pn  postgresql-client             <none>     (no description available)

Versions of packages rsyslog-pgsql suggests:
pn  postgresql                    <none>     (no description available)

Message #10 received at [email protected] (full text, mbox, reply):

From: "Rainer Gerhards" <[email protected]>

To: "Michael Biebl" <[email protected]>, <[email protected]>, "Debian Bug Tracking System" <[email protected]>

Subject: RE: Bug#571291: Use SQL_ASCII encoding when creating the PostgreSQL database

Date: Thu, 25 Feb 2010 09:01:50 +0100

> -----Original Message-----
> From: Michael Biebl [mailto:[email protected]]
> Sent: Thursday, February 25, 2010 1:15 AM
> To: Debian Bug Tracking System
> Subject: Bug#571291: Use SQL_ASCII encoding when creating the
> PostgreSQL database
> 
> Package: rsyslog-pgsql
> Severity: normal
> 
> As reference:
> http://lists.adiscon.net/pipermail/rsyslog/2010-January/003360.html
> 
> upstream recommends to create the postgresql db with encoding
> 'SQL_ASCII'

Please let me add that this decision was driven by some users. I have very
limited knowledge on that topic. Some comment I received later on was that
SQL_ASCII is not a good option for recent postgres releases. I would
appreciate solid arguments on the pro and con of this switch.

Rainer

> 
> Determine, if we want to use SQL_ASCII in Debian or stick with the
> default, UTF-8
> 
> dbconfig-common's dbc_pgsql_createdb_encoding allows to specify the
> encoding but currently fails to create a db using SQL_ASCII as the
> template db uses UTF-8.
> 
> 
> -- System Information:
> Debian Release: squeeze/sid
>   APT prefers unstable
>   APT policy: (500, 'unstable'), (1, 'experimental')
> Architecture: i386 (i686)
> 
> Kernel: Linux 2.6.33-rc8 (SMP w/1 CPU core)
> Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
> Shell: /bin/sh linked to /bin/dash
> 
> Versions of packages rsyslog-pgsql depends on:
> ii  dbconfig-common               1.8.45     common framework for
> packaging dat
> ii  debconf [debconf-2.0]         1.5.28     Debian configuration
> management sy
> ii  libc6                         2.10.2-5   Embedded GNU C Library:
> Shared lib
> ii  libpq5                        8.4.2-2+b1 PostgreSQL C client
> library
> ii  rsyslog                       4.6.0-1    enhanced multi-threaded
> syslogd
> ii  ucf                           3.0025     Update Configuration File:
> preserv
> 
> Versions of packages rsyslog-pgsql recommends:
> pn  postgresql-client             <none>     (no description available)
> 
> Versions of packages rsyslog-pgsql suggests:
> pn  postgresql                    <none>     (no description available)
> 
> 

Send a report that this bug log contains spam.