Hi,

29.05.2008 16:50, gunnar_thielebein AT gmx DOT net wrote:
> My solution which worked on our test machine was taken from this thread:
> 
> http://thread.gmane.org/gmane.comp.sysutils.backup.bacula.general/41042
> 
> steps i made:
> stop bacula-director services
> sudo -u postgres pg_dump bacula > pg_dump-bacula.sql
> sudo -u postgres dropdb bacula
> sudo -u postgres createdb bacula --owner=bacula
> 
> change client encoding in the dump file from UTF-8 to SQL_ASCII
> 
> psql -u bacula -h localhost -W bacula < pg_dump-bacula.sql
> restart service
> 
> @arno lehmann:
> For disabling batch mode I have read that this will decrease db write 
> performance a lot.

Yes. In fact, it will bring the database performance to the level that 
was common before batch inserts were implemented - but many peopled 
used that, even for large installations.

On the other hand, batch inserts needs a more robust database backend 
and connection - temporary table space for the database server, and an 
unbroken connection from the DIR to it are essential. Both have been 
known to cause trouble with out-of-the box setups of OS and MySQL (I 
don't know about PostgreSQL).

Arno

> Regards,
> 
> Gunnar
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users