Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Andrzej Zawadzki
Dan Langille wrote: > John Drescher wrote: > >> On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote: >> >>> Eduardo J. Ortega U. wrote: >>> Hi, all: I am considering bacula for backing up a server whose primary role is PostgreSQL. My question is, is bacula appropr

[Bacula-users] Enable/disable spooling when starting jobs with "run" ?

2009-01-03 Thread Wolfgang Denk
Hello, usually I like to disable spooling for full dumps, but enable it for differential and incremental ones. This works fine by selecting one default setting (say: spooling enabled) in the global configuration and overwriting it for the jobs that need the opposite setting (in my example:

[Bacula-users] "List last 20 Full Backups for a Client" broken?

2009-01-03 Thread Wolfgang Denk
Hi, when I query the "List last 20 Full Backups for a Client" trhe result is not what I would expect: *query Available queries: 1: List up to 20 places where a File is saved regardless of the directory 2: List where the most recent copies of a file are saved 3: List last 20 Full Ba

Re: [Bacula-users] messages configuration

2009-01-03 Thread Thomas
ah, now i got it (i think) in the source code there are different log level defined: info, warning, error, ... and every level is passed to the resource where the level matched. so the "fatal" email address gets only the line of output where the fatal error happens. the "all" email gets also the

Re: [Bacula-users] messages configuration

2009-01-03 Thread Dan Langille
Thomas wrote: Please do not top post. See below. > > Dan Langille schrieb: >> Thomas wrote: >>> Hi list, >>> >>> i have this messages configuration >>> >>> Messages { >>> Name = Standard >>> mailcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) %r\" -s >>> \"Bacula: %t %e of %c %l\" %r" >>

Re: [Bacula-users] messages configuration

2009-01-03 Thread Thomas
the keywords warnig, error, fatal, ... only describe the message level the persons get, but why is the content different? if i get a fatal message because of i get "all" messages why i get more content/information in the mail than all-other-admins? (they get the fatal message because of they get

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Dan Langille
Eduardo J. Ortega U. wrote: > Thanks to all for your suggestions, I'll take a look at LVM snapshots > and PITR, which seem pretty good options. I do not recommend snapshots. The database is not guaranteed to be in a proper state. PITR ensure that. I am not a fan of snapshots for database backu

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Dan Langille
John Drescher wrote: > On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote: >> Eduardo J. Ortega U. wrote: >>> Hi, all: >>> >>> I am considering bacula for backing up a server whose primary role is >>> PostgreSQL. My question is, is bacula appropriate for taking online >>> postgres backups (conside

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Julien Cigar
Note that for LVM snapshots you need to stop PostgreSQL before On Sat, 2009-01-03 at 14:36 -0500, Eduardo J. Ortega U. wrote: > Thanks to all for your suggestions, I'll take a look at LVM snapshots > and PITR, which seem pretty good options. > >

Re: [Bacula-users] Timing problems with backups

2009-01-03 Thread Dan Langille
Apple Jack wrote: > Hi list, > > I am experiencing a problem, where when I backup my nas the job takes so long > that by the time the backup finishes, a new job is already scheduled as a > full backup. > To make thins clear: > 1. Schedule daily Incremental job for the NAS. > 2. The job starts, s

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread John Drescher
On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote: > Eduardo J. Ortega U. wrote: >> Hi, all: >> >> I am considering bacula for backing up a server whose primary role is >> PostgreSQL. My question is, is bacula appropriate for taking online >> postgres backups (considering that a filesystem backup

Re: [Bacula-users] messages configuration

2009-01-03 Thread Dan Langille
Thomas wrote: > Hi list, > > i have this messages configuration > > Messages { > Name = Standard > mailcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) %r\" -s \"Bacula: > %t %e of %c %l\" %r" > operatorcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) %r\" -s > \"Bacula: Interventio

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Eduardo J. Ortega U.
Thanks to all for your suggestions, I'll take a look at LVM snapshots and PITR, which seem pretty good options. -- Eduardo J. Ortega U. -- ___ Bacula-users mailing list Bacula

Re: [Bacula-users] Backup initiated by client (FD)

2009-01-03 Thread Dan Langille
Cedric Gavage wrote: > Hi, > > Is there a way to initiate the backup from client side? > > I have a special case where director is outside a lan... and it can't > connect to client directly... but client can connect to director... > > Is it possible something like that? (without to add vpn solu

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Dan Langille
Eduardo J. Ortega U. wrote: > Hi, all: > > I am considering bacula for backing up a server whose primary role is > PostgreSQL. My question is, is bacula appropriate for taking online > postgres backups (considering that a filesystem backup when the > database is running is a badf solution) ? Look

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread John Drescher
On Sat, Jan 3, 2009 at 2:15 PM, Eduardo J. Ortega U. wrote: >> Is it possible to dump the database using pgdump? Or would that take too >> long? > > It takes a long time, and kills my disks I/O, causing database > performance issues... are there any other choices? > LVM snapshot http://tldp.org/

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Eduardo J. Ortega U.
Hi: > it can be as simple as backing up postgres dump files, but this may be of > help: I'd rather not take pg_dumps, as the DB is fairly large and the dumps take long and kill disk I/O, hurting performance. > > http://wiki.bacula.org/doku.php?id=application_specific_backups:postgresql > >> --

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Eduardo J. Ortega U.
> Is it possible to dump the database using pgdump? Or would that take too long? It takes a long time, and kills my disks I/O, causing database performance issues... are there any other choices? > > John > -- Eduardo J. Ortega U. --

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread John Drescher
On Sat, Jan 3, 2009 at 1:56 PM, Eduardo J. Ortega U. wrote: > Hi, all: > > I am considering bacula for backing up a server whose primary role is > PostgreSQL. My question is, is bacula appropriate for taking online > postgres backups (considering that a filesystem backup when the > database is run

Re: [Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Michael Galloway
On Sat, Jan 03, 2009 at 01:56:49PM -0500, Eduardo J. Ortega U. wrote: > Hi, all: > > I am considering bacula for backing up a server whose primary role is > PostgreSQL. My question is, is bacula appropriate for taking online > postgres backups (considering that a filesystem backup when the > datab

[Bacula-users] Bacula for backing up postgres

2009-01-03 Thread Eduardo J. Ortega U.
Hi, all: I am considering bacula for backing up a server whose primary role is PostgreSQL. My question is, is bacula appropriate for taking online postgres backups (considering that a filesystem backup when the database is running is a badf solution) ? Thanks, -- Eduardo J. Ortega U. -

[Bacula-users] Backup initiated by client (FD)

2009-01-03 Thread Cedric Gavage
Hi, Is there a way to initiate the backup from client side? I have a special case where director is outside a lan... and it can't connect to client directly... but client can connect to director... Is it possible something like that? (without to add vpn solution). -- Cedric Gavage -- openpg

[Bacula-users] messages configuration

2009-01-03 Thread Thomas
Hi list, i have this messages configuration Messages { Name = Standard mailcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) %r\" -s \"Bacula: %t %e of %c %l\" %r" operatorcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) %r\" -s \"Bacula: Intervention needed for %j\" %r" mail = tho

Re: [Bacula-users] LTO3 performance

2009-01-03 Thread Jesper Krogh
Jason A. Kates wrote: > For a speed test /dev/zero isn't the best item to use as the hardware > compression will show how good it can be. I would test on files that > aren't in the OS cache and will have representative level of > compression. I agree, but if the test with /dev/zero ends with 10M

[Bacula-users] Timing problems with backups

2009-01-03 Thread Apple Jack
Hi list, I am experiencing a problem, where when I backup my nas the job takes so long that by the time the backup finishes, a new job is already scheduled as a full backup. To make thins clear: 1. Schedule daily Incremental job for the NAS. 2. The job starts, says it will perform a full backup.

[Bacula-users] Device is BLOCKED waiting to create a volume for:

2009-01-03 Thread Apple Jack
Hi list, I have a recurring problem. 2 pools: poolA poolB 1. Overnight a job runs and does not find appendable media for poolA (which is correct) 2. I cancel the job 3. I start a job that writes to poolB, for which there are tapes in the autochanger In this scenario the director asks me to: Pl

Re: [Bacula-users] LTO3 performance

2009-01-03 Thread Jason A. Kates
For a speed test /dev/zero isn't the best item to use as the hardware compression will show how good it can be. I would test on files that aren't in the OS cache and will have representative level of compression. -Jason On Fri, 2009-01-02 at 20:14 +0100, Jesper Kr