Hi Marcio,

On Thu, 9 Aug 2012, Marcio Merlone wrote:

> I have a running bacula 5.0.1-1ubuntu1 on a Ubuntu 10.04.4 LTS server box for 
> some years now, using PostgreSQL 8.4.12-0ubuntu10.04. My file table has 
> around 20M+ records. Whenever I try to restore something using the 
> bacula-console-qt 5.2.5-0ubuntu6.1 from my
> workstation (Ubuntu 12.04) it hangs forever.

Where exactly hangs the restore?

Do you have tuned your PostgreSQL installation? The default settings are 
for wide compatibility and not perfomance, see [1]. I have adjusted 
shared_buffers to 2GB and effective_cache_size to 5G and this boost the 
building directory phase of a restore greatly. Furthermore I have tuned 
the squence object arrcording to [2], but I think this isn't helpful for 
restores.

Best Regards,

  - Jummo


[1] http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
[2] 
http://www.bacula.org/5.2.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION004970000000000000000

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users