Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Julien Cigar
Stephen Thompson wrote: Hello everyone, We recently attempted a mysql to postgresql migration for our bacula 5.0.2 server. The data migration itself was successful, however we are disappointly either getting the same or significantly worse performance out of the postgres db. I was hoping

[Bacula-users] BConsole Error

2010-06-07 Thread rugamu
Hello, I have an error when a try to connect to bconsole, i have just upgraded ubuntu to the new version, and today i have tried to connect bconsole by typing: prompt#bconsole And the only thing that is shown on the console is this prompt#bconsole Conectando al Director glorfindel:9101

[Bacula-users] wrong bootstrap file when doing restore

2010-06-07 Thread Emil Noether
Hi, I have the following problem. If I do a restore (let's say of a client called cli-1) everything goes fine to the last step before final yes. I see these options: Run Restore job JobName: job-restore-catalog Bootstrap: /var/lib/bacula/dir-our_director.xxx.cz.restore.1.bsr Where:

Re: [Bacula-users] BConsole Error

2010-06-07 Thread John Drescher
On Mon, Jun 7, 2010 at 7:35 AM, rugamu bacula-fo...@backupcentral.com wrote: Hello, I have an error when a try to connect to bconsole, i have just upgraded ubuntu to the new version, and today i have tried to connect bconsole by typing: prompt#bconsole And the only thing that is shown

[Bacula-users] BConsole Error

2010-06-07 Thread rugamu
I have got this exit: bacula 16387 1 0 13:18 ?00:00:00 /usr/sbin/bacula-sd -c /etc/bacula/bacula-sd.conf -u bacula -g tape root 16425 1 0 13:18 ?00:00:00 /usr/sbin/bacula-fd -c /etc/bacula/bacula-fd.conf

Re: [Bacula-users] BConsole Error

2010-06-07 Thread John Drescher
I have got this exit: bacula   16387     1  0 13:18 ?        00:00:00 /usr/sbin/bacula-sd -c /etc/bacula/bacula-sd.conf -u bacula -g tape root     16425     1  0 13:18 ?        00:00:00 /usr/sbin/bacula-fd -c /etc/bacula/bacula-fd.conf This means bacula-dir is not running. Restart the

[Bacula-users] BConsole Error

2010-06-07 Thread rugamu
I have restarted the bacul-dir service by: /etc/init.d/bacula-director restart * Stopping Bacula Director... [ OK ] * Starting Bacula Director... But I have got the

Re: [Bacula-users] BConsole Error

2010-06-07 Thread John Drescher
On Mon, Jun 7, 2010 at 9:28 AM, rugamu bacula-fo...@backupcentral.com wrote: I have restarted the bacul-dir service by: /etc/init.d/bacula-director restart  * Stopping Bacula Director...                                                                                                          

[Bacula-users] BConsole Error

2010-06-07 Thread rugamu
I think that i have got a database problem, this is the exit for the command bacula-dir -d 100 -c /etc/bacula/bacula-dir.conf bacula-dir: dird.c:184-0 Debug level = 100 bacula-dir: bsys.c:511-0 Could not open state file. sfd=-1 size=192: ERR=No existe el fichero ó directorio bacula-dir:

Re: [Bacula-users] BConsole Error

2010-06-07 Thread Phil Stracchino
On 06/07/10 09:56, rugamu wrote: I think that i have got a database problem, this is the exit for the command bacula-dir -d 100 -c /etc/bacula/bacula-dir.conf bacula-dir: dird.c:184-0 Debug level = 100 bacula-dir: bsys.c:511-0 Could not open state file. sfd=-1 size=192: ERR=No existe el

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Stephen Thompson
Yes, it's ext3. On 6/4/10 7:24 PM, Jon Schewe wrote: Which filesystem are you on too? I've found that ext3 is significantly faster than ext4 and xfs. On 06/04/2010 04:01 PM, Stephen Thompson wrote: Thanks, yes it is Linux. I will look at those limits settings. And yes, I've built

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread John Drescher
Which filesystem are you on too? I've found that ext3 is significantly faster than ext4 and xfs. That is only with certain workloads. ext3 is significantly slower than both at large file operations. Especially deletes where ext3 can take minutes to delete a 4GB file while the other two take

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Alan Brown
On 05/06/10 03:24, Jon Schewe wrote: Which filesystem are you on too? I've found that ext3 is significantly faster than ext4 and xfs. Please don't top post, it makes threading harder to read. I'm using Ext4 - on a 48Gb machine with high performance raid controller (battery backup and

[Bacula-users] BConsole Error

2010-06-07 Thread rugamu
Than you very much Phil, and thank you very much drescherjm, you have been very helpful. I have upraded the mysql version first upgrading from V10 to V11 and after that from V11 to V12, and it works!!!. I have learned a lot today. I'm going to leave two links with the upgrade scripts. I don't

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Alan Brown
On Mon, 7 Jun 2010, Julien Cigar wrote: Stephen Thompson wrote: centos 5.5 (64bit) bacula 5.0.2 (64bit) postgresql 8.1.21 (64bit) Why 8.1 ..? 8.1 is more than 5 years old ... because that's what is supplied and supported by Redhat for their enterprise versions. Anything newer

[Bacula-users] is waiting for an appendable Volume

2010-06-07 Thread mario ramirez cervera
Hello everyone: stud fees have my bacula server and new client and I get the following error .. back to work and I go back is waiting for an appendable Volume any ideas? -- ThinkGeek and WIRED's GeekDad team up for the

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Florian Heigl
Hi all, Within psql/mysql: 1) select count(*) from File;                    1sec    30min Disclaimer: I don't know a dime's worth of databases per se. But I spend a lot of time hunting other peoples performance issues. :) I think you should start identifying the cause for this bit at the very

Re: [Bacula-users] is waiting for an appendable Volume

2010-06-07 Thread John Drescher
2010/6/7 mario ramirez cervera marioramire...@gmail.com: Hello everyone: stud fees have my bacula server and new client and I get the following error .. back to work and I go back is waiting for an appendable Volume any ideas? Verify that there exists an appendable volume in the pool its

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Florian Heigl
Also, I don't know if I would value RedHat supporting postgre 8.1 higher than running 8.4.1  :) after all, you had to ask here, not at RedHat. -- 'Sie brauchen sich um Ihre Zukunft keine Gedanken zu machen' --

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Stephen Thompson
On 06/07/2010 12:33 AM, Julien Cigar wrote: Stephen Thompson wrote: Hello everyone, We recently attempted a mysql to postgresql migration for our bacula 5.0.2 server. The data migration itself was successful, however we are disappointly either getting the same or significantly worse

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Stephen Thompson
On 06/07/2010 09:24 AM, Florian Heigl wrote: Hi all, Within psql/mysql: 1) select count(*) from File;1sec30min Disclaimer: I don't know a dime's worth of databases per se. But I spend a lot of time hunting other peoples performance issues. :) I think you should

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Martin Simmons
On Mon, 7 Jun 2010 18:24:34 +0200, Florian Heigl said: Hi all, Within psql/mysql: 1) select count(*) from File;                    1sec    30min Disclaimer: I don't know a dime's worth of databases per se. But I spend a lot of time hunting other peoples performance issues. :) I

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Julien
On Mon, 2010-06-07 at 18:24 +0200, Florian Heigl wrote: Hi all, Within psql/mysql: 1) select count(*) from File;1sec30min Is your MySQL database in the MyISAM format ? If yes, then it's perfectly normal. Disclaimer: I don't know a dime's worth of databases per

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Julien
On Mon, 2010-06-07 at 20:10 +0100, Martin Simmons wrote: On Mon, 7 Jun 2010 18:24:34 +0200, Florian Heigl said: Hi all, Within psql/mysql: 1) select count(*) from File;1sec30min Disclaimer: I don't know a dime's worth of databases per se. But I spend

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Stephen Thompson
On 06/07/2010 12:17 PM, Julien wrote: On Mon, 2010-06-07 at 18:24 +0200, Florian Heigl wrote: Hi all, Within psql/mysql: 1) select count(*) from File;1sec30min Is your MySQL database in the MyISAM format ? If yes, then it's perfectly normal. Yes. So it sounds

Re: [Bacula-users] postgres tuning?

2010-06-07 Thread Alan Brown
On 07/06/10 17:28, Stephen Thompson wrote: It doesn't sound like I'm doing anything egregiously wrong. I am still surprised at how slow postgres is compared to mysql on the same hardware after all I've read and heard about postgres superiority. One the scale you're using it should be,

[Bacula-users] bacula storage daemon connect problem.

2010-06-07 Thread Jeremiah D. Jester
Hello, I'm a bacula newbie and having a problem resolving the following error: 07-Jun 14:40 bacula-dir JobId 0: Fatal error: authenticate.c:120 Director unable to authenticate with Storage daemon at bacula.microslu.washington.edu:9103. Possible causes: Passwords or names not the same or

Re: [Bacula-users] bacula storage daemon connect problem.

2010-06-07 Thread John Drescher
I’m a bacula newbie and having a problem resolving the following error: 07-Jun 14:40 bacula-dir JobId 0: Fatal error: authenticate.c:120 Director unable to authenticate with Storage daemon at bacula.microslu.washington.edu:9103. Possible causes: Passwords or names not the same or

Re: [Bacula-users] bacula storage daemon connect problem.

2010-06-07 Thread Jeremiah D. Jester
John, Thanks for the reply. I do see the default value of 20 max connections in the bacula-sd.conf file. Previously I had played around with having the SDAddress in bacula-sd.conf set to 127.0.0.1 and my FQDN. However, I saw something on a post that suggested commenting it out. And in response

Re: [Bacula-users] Problems restoring data

2010-06-07 Thread Jerry Lowry
Well, the difference between the system is only about 7 minutes, so I don't think that would cause it. Any other ideas? I don't want to lose anything at some point down the road. We were able to get past it this time. jerry Doug Forster wrote: Jerry, I would check your backup server to

[Bacula-users] Problem after configure and install using mysql DB.

2010-06-07 Thread Robbie Base
Bacula does not start up. OK went thru the configuration using the mysql database. I verified the DB is up and running. I verified the db and tables are there. I see the bacula DB in mysql as well as the tables. What am I missing. When I try to start bacula I get nothing. Does bacula create