Your message dated Sat, 03 Apr 2010 14:19:25 +0000
with message-id <[email protected]>
and subject line Bug#546246: fixed in dbconfig-common 1.8.46
has caused the Debian Bug report #546246,
regarding Fails to pass -T template0 with dbc_pgsql_createdb_encoding
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.)
--
546246: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=546246
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: bacula-director-pgsql
Version: 3.0.2-3
Severity: normal
My postgresql 8.4 database was created with all tables having UTF8 as
encoding, probably because I use an UTF8-locale. Now bacula needs to use
SQL_ASCII instead of UTF8 and this is correctly specified in the postinst
script.
The problem is that postgresql cannot create the database with a different
encoding (SQL_ASCII vs. UTF8) as long as you do not specify -T template0:
------------------------------------------------------------------------
postgres $ createdb -O bacula -E SQL_ASCII bacula
createdb: database creation failed: ERROR: new encoding (SQL_ASCII) is
incompatible with the encoding of the template database (UTF8)
HINT: Use the same encoding as in the template database, or use template0 as
template.
postgres $ createdb -O bacula -E SQL_ASCII -T template0 bacula
postgres $ psql
postgres=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+----------+-----------+-------------+-------------+-----------------------
bacula | bacula | SQL_ASCII | de_DE.UTF-8 | de_DE.UTF-8 |
postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres
:
postgres=CTc/postgres
(4 rows)
------------------------------------------------------------------------
So, please add this flag to the creation.
Thanks and best regards,
Michael
--- End Message ---
--- Begin Message ---
Source: dbconfig-common
Source-Version: 1.8.46
We believe that the bug you reported is fixed in the latest version of
dbconfig-common, which is due to be installed in the Debian FTP archive:
dbconfig-common_1.8.46.dsc
to main/d/dbconfig-common/dbconfig-common_1.8.46.dsc
dbconfig-common_1.8.46.tar.gz
to main/d/dbconfig-common/dbconfig-common_1.8.46.tar.gz
dbconfig-common_1.8.46_all.deb
to main/d/dbconfig-common/dbconfig-common_1.8.46_all.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Sean Finney <[email protected]> (supplier of updated dbconfig-common package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Sun, 28 Mar 2010 17:14:26 +0200
Source: dbconfig-common
Binary: dbconfig-common
Architecture: source all
Version: 1.8.46
Distribution: unstable
Urgency: low
Maintainer: Sean Finney <[email protected]>
Changed-By: Sean Finney <[email protected]>
Description:
dbconfig-common - common framework for packaging database applications
Closes: 546246 573069
Changes:
dbconfig-common (1.8.46) unstable; urgency=low
.
* Fix error removing postgres databases and users (Closes: #573069)
- thanks to "J.M.Roth" <[email protected]>
* Numerous fixes to unit test internals.
* New unit tests covering some of the pgsql support.
* Various misc fixes to pgsql support found by said unit tests :)
* Fix pgsql createdb code to use template0 when encoding is specified
- thanks to John Goerzen <[email protected]> (Closes: #546246)
* A few quotation and unset shell variable related fixes in mysql
support found by updated unit tests.
* Fix zsh support with unit tests
* Remove test/tmp directory in debian/rules clean target
Checksums-Sha1:
d7b2c13f3e5e7ba3b63310ce847607467ea30dea 991 dbconfig-common_1.8.46.dsc
13be463c5f54dcc8e9391e964888aa353b1fa20d 357534 dbconfig-common_1.8.46.tar.gz
cfad944992c45f14918aaa5867298947cb2acbb3 474034 dbconfig-common_1.8.46_all.deb
Checksums-Sha256:
15b5d44732b00a84bfa2f4ed6030f70f63a208c59a6538d679fc9a128aff11c6 991
dbconfig-common_1.8.46.dsc
f5ead9b421cbfa5e779cc94d43e109102824bd1feea9822f95080071c049c158 357534
dbconfig-common_1.8.46.tar.gz
aa3803a4928ba2cd5510eaad306f76d05dc4c9a394498ce3b69f720388d369bb 474034
dbconfig-common_1.8.46_all.deb
Files:
ed89b8ad4a43446efe19c0f4bfe32f51 991 admin optional dbconfig-common_1.8.46.dsc
8371aed3d627c21b984387b4a3a4c150 357534 admin optional
dbconfig-common_1.8.46.tar.gz
f5afee048a88044168a0b87e4ecc70e8 474034 admin optional
dbconfig-common_1.8.46_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iD8DBQFLr3WYynjLPm522B0RAnhoAJ9ciq2Vx/paohmNVNffeFMVQS4uPwCfQhCq
TuSywH5xsqo0fjLGnKdUwQs=
=9emo
-----END PGP SIGNATURE-----
--- End Message ---
