On Tue, 2007-08-07 at 12:39 -0400, Dan Langille wrote:
> On 7 Aug 2007 at 11:57, Tod Hagan wrote:
> > On Thu, 2007-08-02 at 20:31 -0400, John Drescher wrote:
> > > I doubt that the tape drive is the cause. Did you make any database
> > > changes?
> >
> > Sort of. A more recent postgresql package was installed from scratch,
> > and the database restored via 'psql bacula < bacula.sql'.
> >
> > Does the above method of restoring a postgresql database create indexes?
>
> It will recreate any indexes that were present in the original
> database. Running "vacuum analyse" from within psql will help
> refresh the table statistics which are used during query planning.
I did a 'vacuum analyze;' while one of the large full monthly backups is
running. Had it corrected the cause of the problem that backup would
have finished, but it's still running.
I really don't think it's the db, as it's hardly breaking a sweat:
> ps auxww | grep ^postgres
postgres 3776 0.0 0.0 20424 2760 ? S Aug02 0:00
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 3778 0.0 0.0 10200 632 ? S Aug02 0:00
postgres: logger process
postgres 3780 0.0 0.2 20560 9264 ? S Aug02 0:00
postgres: writer process
postgres 3781 0.0 0.0 11204 564 ? S Aug02 0:00
postgres: stats buffer process
postgres 3782 0.0 0.0 10436 768 ? S Aug02 0:00
postgres: stats collector process
postgres 6569 0.0 0.3 21768 11724 ? S Aug06 1:47
postgres: bacula bacula 10.0.0.1(55864) idle
>
The bconsole 'status' command only shows that a backup is running. Are
there some other ways I can observe what bacula is doing?
Thanks.
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
