Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, James Harper (james.har...@bendigoit.com.au) wrote: On 04/10/10, James Harper (james.har...@bendigoit.com.au) wrote: A full pg_dump of the catalogue is 2.8G. The output of the catalogue snapshot for job 60 is 1.6G. Naturally, the full pg_dump of the whole database will

[Bacula-users] Vol Usage

2010-10-04 Thread Bruno Gomes da Silva
Hello .. I wonder if any parameter is particularly used to show the amount of volume (STATUS MEDIA - VOL USAGE) in Bacula Admin Tool (bat). The percentage of volume usage is always 0.00%. Here's the conf Pool: Pool { Name = Server1Diario Pool Type = Backup Recycle = yes AutoPrune = yes Volume

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread James Harper
On 04/10/10, James Harper (james.har...@bendigoit.com.au) wrote: I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. ... How much smaller is the catalogue subset vs the full catalogue? Good question. I'm not able to

[Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
Hi, I just updated from 3.0.3 to 5.0.3. I know that there have been problems with the update_postgresql_tables script. Here are my indexes: bacula=# select * from pg_indexes where tablename='file'; schemaname | tablename | indexname| tablespace |

Re: [Bacula-users] Restore from a file listing

2010-10-04 Thread Graham Keeling
On Mon, Oct 04, 2010 at 12:00:12PM +0100, Rory Campbell-Lange wrote: We provide clients with a Bacula backup-to-tape service, which is complementary to our offsite backup services. As part of the backup-to-tape service we wish to audit each tape by checking that we can retrieve several files

[Bacula-users] Restore from a file listing

2010-10-04 Thread Rory Campbell-Lange
We provide clients with a Bacula backup-to-tape service, which is complementary to our offsite backup services. As part of the backup-to-tape service we wish to audit each tape by checking that we can retrieve several files from each tape in the backup set. Our audit programme (a python script)

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Phil Stracchino
On 10/04/10 07:22, Rory Campbell-Lange wrote: I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. The snapshot provides a bacula database schema file, a database dump of the job's data, and a file listing of files showing info such as

Re: [Bacula-users] Vol Usage

2010-10-04 Thread John Drescher
2010/10/4 Bruno Gomes da Silva kidbro...@gmail.com: Hello .. I wonder if any parameter is particularly used to show the amount of volume (STATUS MEDIA - VOL USAGE) in Bacula Admin Tool (bat). The percentage of volume usage is always 0.00%. Here's the conf Pool: Pool { Name = Server1Diario

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, James Harper (james.har...@bendigoit.com.au) wrote: I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. ... How much smaller is the catalogue subset vs the full catalogue? Good question. I'm not able to answer that

[Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. The snapshot provides a bacula database schema file, a database dump of the job's data, and a file listing of files showing info such as the tape number, path, file, md5 and lstat. We

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Phil Stracchino (ala...@metrocast.net) wrote: On 10/04/10 07:22, Rory Campbell-Lange wrote: I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. The snapshot provides a bacula database schema file, a database dump of the

Re: [Bacula-users] Restore from a file listing

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Graham Keeling (gra...@equiinet.com) wrote: On Mon, Oct 04, 2010 at 12:00:12PM +0100, Rory Campbell-Lange wrote: ... At present I am doing a restore job by using option 3 and entering the job id as all our backups are full backups. Then I go into the restore console. For

Re: [Bacula-users] Problem with webacula

2010-10-04 Thread Yuri Timofeev
Hi docs/INSTALL: System Requirements: - Bacula 5.0 or later 2010/9/29 Daniel beas beasdan...@hotmail.com: Hi to all. I'm trying to install webacula but after do all tha config i get the next error Fatal error: Uncaught exception 'Zend_Exception' with message 'Version error for Catalog

Re: [Bacula-users] Vol Usage

2010-10-04 Thread Bruno Gomes da Silva
John Yes, the volumes were already created and then I changed them. After that I ran the UPDATE command in the console. I thought I would update the Usage Vol. Thanks for the reply. 2010/10/4 John Drescher dresche...@gmail.com 2010/10/4 Bruno Gomes da Silva kidbro...@gmail.com: Hello ..

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Phil Stracchino
On 10/04/10 08:01, Rory Campbell-Lange wrote: Hi Phil I'd be delighted if you could take a look at the python script and for your comments. I really can't help with testing it, sorry. I don't run PostgreSQL and don't speak Python. ;) -- Phil Stracchino, CDK#2 DoD#299792458

[Bacula-users] Rename and move my catalog backups to a sub-directory...

2010-10-04 Thread John Doe
Hi, I am trying to cleanup a bit my old bacula installation (2.4.2-1) and I would like to rename my catalog backups (the files) and move them to a sub-directory. Is it easy or is it now hardcoded in multiple places? Here are the specific parts of the configuration: Device { Name =

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: Hi, I just updated from 3.0.3 to 5.0.3. I know that there have been problems with the update_postgresql_tables script. Here are my indexes: bacula=# select * from pg_indexes where tablename='file'; schemaname | tablename |

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread James Harper
I have developed a catalogue snapshot facility in python to snapshot one job's catalogue and dump it to disk. The snapshot provides a bacula database schema file, a database dump of the job's data, and a file listing of files showing info such as the tape number, path, file, md5 and lstat.

[Bacula-users] Tuning Bacula

2010-10-04 Thread Tim Gustafson
We have recently installed Bacula onto a FreeBSD server and several Linux, SunOS and FreeBSD clients. The Bacula director and storage daemon run on a box with about 6 terabytes of RAID6 storage (SATA 300 drives, 1TB each, Adaptec RAID controller with 512MB cache). The box has 16GB of RAM and

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread Jeremiah D. Jester
Tim, Have you tried backing up other hosts on your network? What are the speeds with these hosts? I've noticed that different host respond with varying speeds despite being on the same network. Wondering if this has to do the client OS doing some throttling based on work load. JJ

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread John Drescher
On Mon, Oct 4, 2010 at 1:37 PM, Tim Gustafson t...@soe.ucsc.edu wrote: We have recently installed Bacula onto a FreeBSD server and several Linux, SunOS and FreeBSD clients.  The Bacula director and storage daemon run on a box with about 6 terabytes of RAID6 storage (SATA 300 drives, 1TB each,

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread Mehma Sarja
On 10/4/10 10:37 AM, Tim Gustafson wrote: We have recently installed Bacula onto a FreeBSD server and several Linux, SunOS and FreeBSD clients. The Bacula director and storage daemon run on a box with about 6 terabytes of RAID6 storage (SATA 300 drives, 1TB each, Adaptec RAID controller

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
Rory Campbell-Lange schrieb: On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: All of the indexes are below; you seem to have the correct ones for the file table. The Debian problems with 5.0.3 were/are related to the upgrade trying to create an index that already exists. See

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread Josh Fisher
On 10/4/2010 1:37 PM, Tim Gustafson wrote: We have recently installed Bacula onto a FreeBSD server and several Linux, SunOS and FreeBSD clients. The Bacula director and storage daemon run on a box with about 6 terabytes of RAID6 storage (SATA 300 drives, 1TB each, Adaptec RAID controller

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread John Drescher
On Mon, Oct 4, 2010 at 3:01 PM, Ralf Gross ralf-li...@ralfgross.de wrote: Rory Campbell-Lange schrieb: On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: All of the indexes are below; you seem to have the correct ones for the file table. The Debian problems with 5.0.3 were/are

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Tim Gustafson (t...@soe.ucsc.edu) wrote: ...we're getting pretty pitiful throughput numbers. When I scp a file from my workstation to the Bacula server, I get something like 40MB/s (320Mb/s). When Bacula runs, we're lucky to get 20MB/s (160Mb/s), and we often get numbers closer

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
John Drescher schrieb: On Mon, Oct 4, 2010 at 3:01 PM, Ralf Gross ralf-li...@ralfgross.de wrote: Rory Campbell-Lange schrieb: On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: All of the indexes are below; you seem to have the correct ones for the file table. The Debian

[Bacula-users] Remove several inactive clients

2010-10-04 Thread Joseph L. Casale
Anyone know the proper way to do this w/ an MySQL db? I really don't know much about sql or bacula's db structure but a ` DELETE FROM Client WHERE name LIKE '%host-fd%';` left the db in an unstable state where a restore was needed. Volumes could no longer be used that were expected to be available