Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-03 Thread Dan Langille
Lucas B. Cohen wrote: > Kern Sibbald wrote: > >> Apparently, for PostgreSQL 8.4, one must specify: >> >> CREATE DATABASE bacula ENCODING 'SQL_ASCII' TEMPLATE=template0; >> >> Rather than making this incompatible modification, it would have been >> advisable to make the default equivalent to the a

Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Lucas B. Cohen
Kern Sibbald wrote: > Apparently, for PostgreSQL 8.4, one must specify: > > CREATE DATABASE bacula ENCODING 'SQL_ASCII' TEMPLATE=template0; > > Rather than making this incompatible modification, it would have been > advisable to make the default equivalent to the above. Can one please confirm

Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Falk Sauer
Hi Craig, Am Donnerstag, 3. Dezember 2009 06:35:23 schrieb Craig Ringer: > The director is responsible for managing all the metadata, and it's the > component that connects to Pg. > > If the fd sent the system charset along with the bundle of filenames etc > that it sends to the director, then I

Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Dan Langille
pgsql-general removed from CC: list Gary R. Schmidt wrote: > On Thu, December 3, 2009 00:18, Kern Sibbald wrote: > [SNIP change in Postgres defaults.] > > Bloody typical, after the recent bollocking of MySQL, I was thinking, > "Maybe I should switch over to postgres?" Yes. I think you should.

Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Gary R. Schmidt
Re-sent, may appear twice. On Thu, December 3, 2009 00:18, Kern Sibbald wrote: [SNIP change in Postgres defaults.] Bloody typical, after the recent bollocking of MySQL, I was thinking, "Maybe I should switch over to postgres?" Hmm, I think I've got some spare Oracle or DB2 licenses floating arou

Re: [Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Gary R. Schmidt
On Thu, December 3, 2009 00:18, Kern Sibbald wrote: [SNIP change in Postgres defaults.] Bloody typical, after the recent bollocking of MySQL, I was thinking, "Maybe I should switch over to postgres?" Hmm, I think I've got some spare Oracle or DB2 licenses floating around... Now, do I *have* the

[Bacula-devel] Catastrophic changes to PostgreSQL 8.4

2009-12-02 Thread Kern Sibbald
Hello, I am the project manager of Bacula. One of the database backends that Bacula uses is PostgreSQL. This email is to notify you that a change you made to setting database character codes has created havoc with certain unfortunate Bacula users. Bacula sets the database encoding to SQL_ASCI