On 06/22/2010 01:47 PM, Martin Simmons wrote:
>>>>>> On Tue, 22 Jun 2010 05:26:18 -0500, Jon Schewe said:
>>>>>>
>> I've seen quite a bit of discussion on this on the list. It seems
>> possible, so I figured I'd try. I'm using a combination of
>> http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html#1107
>> and
>> http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg40993.html
>>
>> I did
>> mysqldump -t -n -c --compatible=postgresql --skip-quote-names --skip-opt
>> --disable-keys --lock-tables -u bacula -ppass bacula
>>
>> cat bacula-backup.dmp | sed -e 's/0000-00-00 00:00:00/1970-01-01
>> 00:00:00/g' > fixed-bacula-backup.sql
>> psql -h localhost -U bacula bacula fixed-bacula-backup.sql
>>
>> Then tried to import fixed-bacula-backup.sql into the postgresql tables
>> created by the bacula setup scripts. Things went along pretty well until
>> I ran into this:
>> 2010-06-21 22:55:01 CDT bacula bacula WARNING: nonstandard use of
>> escape in a string literal at character 89
>> 2010-06-21 22:55:01 CDT bacula bacula HINT: Use the escape string
>> syntax for escapes, e.g., E'\r\n'.
>> 2010-06-21 22:55:01 CDT bacula bacula ERROR: invalid byte sequence for
>> encoding "SQL_ASCII": 0x00
>> 2010-06-21 22:55:01 CDT bacula bacula HINT: This error can also happen
>> if the byte sequence does not match the encoding expected by the server,
>> which is controlled by "client_encoding".
>> 2010-06-21 22:55:01 CDT bacula bacula STATEMENT: INSERT INTO Log
>> (LogId, JobId, Time, LogText) VALUES (456892,5599,'1969-12-31
>> 18:00:01','jon-fd JobId 5599: -rw-rw-r-- 1 33 video 727636
>> 2010-02-14 14:51:04
>> /mnt/mybook//home/httpd/html/gallery/albums/osseo1994/DSC_0066_066.jpg\n\0');
>>
> Does every line in the Log table contain the \n and/or \0 at the end of the
> text? That might be a bug.
>
> 1969-12-31 is a rather old timestamp on that log entry too :-)
>
> Simple solution: remove all of the "INSERT INTO Log" lines from the import.
> The rows aren't required for most uses of Bacula.
>
>
>
It's that what is used to view the log in bat?
>> and then:
>> 2010-06-21 23:01:15 CDT bacula bacula ERROR: duplicate key value
>> violates unique constraint "status_pkey"
>> 2010-06-21 23:01:15 CDT bacula bacula STATEMENT: INSERT INTO Status
>> (JobStatus, JobStatusLong, Severity) VALUES ('p','Waiting on higher
>> priority jobs',15);
>>
> You can remove the Status table from the import because it is created and
> filled by the make_postgresql_tables script.
>
>
OK, I'll give that a try.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
