All,
Rather that try to figure out why 1.38.8 was running slowly after
upgrading RHEL 3 to RHEL 5 and its newer version of Postgresql, I
upgraded Bacula to 2.0.3. Once I got grant_postgresql_privileges running
with help from the list, this message was reported:
psql:<stdin>:62: NOTICE: number of page slots needed (29760) exceeds
max_fsm_pages (20000)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 29760.
I edited /var/lib/pgsql/data/postgresql.conf to set
max_fsm_pages = 40000
and restarted Postgresql.
A test backup shows that speeds are now comparable to the old
configuration of 1.38.8 on RHEL 3.
Even better, bconsole commands such as getting the director status or
doing queries using sqlquery are now appreciably faster.
Thanks all for your help.
Tod
--
Tod Hagan
Information Technologist
AIRMAP/Climate Change Research Center
Institute for the Study of Earth, Oceans, and Space
University of New Hampshire
Durham, NH 03824
Phone: 603-862-3116
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
