Re: [Bacula-users] Restore hangs on bat (Postgresql)
2012-08-09 10:03:34
Em 09-08-2012 09:56, Jummo escreveu:
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?
On the "Building directory tree for JobId(s) xxx, xxx, xxx...".
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.
I felt the need for some tune, but this is not the issue. As I told
John, restore works on bconsole and bat 5.0, the issue is just with
my bat 5.2.
Regarding Postgre tunning, will procrastinate this since it is not
the issue. But will definitely do it when time is available.
|
------------------------------------------------------------------------------
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
|
|
|