Re: [Bacula-users] Bacula 2.4.4 backup error [SOLVED]
2009-07-21 02:01:56
Thomas Kempf schrieb:
>> Thomas Kempf wrote:
>>> Bruno Friedmann schrieb:
>>>> Hi Thomas, I remember discussion on the ML about trouble with postgresql &
>>>> bacula.
>>>> Bacula mens insist to have SQL_ASCII for postgres & bacula.
>>>> Your bacula's db is SQL_ASCII, but I suppose as template0 and template1
>>>> are UTF-8 the batch temporary table
>>>> are created based on one of the two which conduct to the errors you
>>>> encounter.
>>>>
>>>> I think you have to give this information if you are reporting this bug.
>>>> (Perharps give a try to the wiki, searching about postgresql & the docs )
>>>> before you transmit a bug.
>>>>
>>>> Anyway if bacula need a sql_ascii table, it should be "smart" enough to
>>>> create it with this requirement.
>>>>
>>> Hi Bruno,
>>> first of all thank you for your explanation. It seems reasonable for me,
>>> that this is the root of the problem with postgresql and bacula. I 've
>>> really searched the docs, the mailinglist and the web, but have not
>>> found any place where the template DB encoding is mentioned as the
>>> problem source. I'll check this though.
The problem is solved in SVN now. Eric submitted a patch, which checks
for the return value of the SQL-Transaction. But far better than that,
the underlying problem with Postgresql rejecting the transaction is
solved too by setting the client_encoding explicitely to SQL_ASCII just
before the transaction begins!
Thank you Eric!
Tom
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|