Re: [Bacula-users] restore: file selection not possible
2008-05-30 17:31:40
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
|
|
|