PROBLEM - I have run multiple fulls and have NEVER been able to complete a
PG insert operation. Granted my fileset is large - about 9.8 million files,
~700GB. What am I doing wrong?
SYSTEM
FreeBSD 7.1-RELEASE system, 8 GB RAM, 4 core AMD 64 processor, SUN Ultra 40
DATABASE
Postgresql version 8.2
postgresql.conf
shared_buffers = 20MB
temp_buffers = 96MB
max_prepared_transactions = 10
work_mem = 512MB
maintenance_work_mem = 256MB
max_stack_depth = 525kB
checkpoint_segments = 15
autovacuum = off
DIR
bacula-dir.conf
Director { # define myself
Name = titanic-dir # director name
DIRport = 9101 # where director
listens for console connections
QueryFile = "/usr/local/share/bacula/query.sql" # query commands for
console
WorkingDirectory = "/var/db/bacula" # Director puts status files
here
PidDirectory = "/var/run" # Director puts puts
process Id file here
Maximum Concurrent Jobs = 1 # max # of total Director
Jobs that should run concurrently
Password = "something" # Console
password
Messages = Daemon # Director messages
not associated with a specific Job
}
JobDefs {
Name = "DefaultJob" # Job name specified in console Run
command to start a job
Type = Backup
Level = Incremental # files changed since the last
backup of the same Job
Client = zydeco-fd # Client (File daemon) that will be
used in the current Job
FileSet = "Full Set" # Name of file set used for the
current job
Schedule = "MonthlyCycle"
Storage = File # name of storage services to backup
FileSet
Messages = Standard # Messages resource used for this
job
Pool = Default # defines the pool of Volumes
Priority = 10 # control the order in which jobs
will be run
}
# Define the main nightly save backup job
# By default, this job will back up to disk
Job {
Name = "zydeco"
JobDefs = "DefaultJob"
Write Bootstrap = "/var/db/bacula/zydeco.bsr"
# Bacula writes a bootstrap
file for each Backup job run
}
# Backup the catalog database (after the nightly save)
Job {
Name = "BackupCatalog"
JobDefs = "DefaultJob"
Level = Full
FileSet="Catalog"
Schedule = "MonthlyCycleAfterBackup"
# This creates an ASCII copy of the catalog
# Arguments to make_catalog_backup are:
# make_catalog_backup <database-name> <user-name> <password> <host>
RunBeforeJob = "/usr/local/share/bacula/make_catalog_backup bacula pgsql"
# This deletes the copy of the catalog
RunAfterJob = "/usr/local/share/bacula/delete_catalog_backup"
Write Bootstrap = "/var/db/bacula/BackupCatalog.bsr"
Priority = 11 # run after main backup
}
# Standard Restore template, to be changed by Console program
# Only one such job is needed for all Jobs/Clients/Storage ...
Job {
Name = "RestoreFiles"
Type = Restore
Client=zydeco-fd
FileSet="Full Set"
Storage = File
Pool = Default
Messages = Standard
Where = /array/bacula-restores
}
# List of files to be backed up
FileSet {
Name = "Full Set"
Include {
Options {
signature = MD5
noatime=yes
onefs=yes
}
File = /array/home
}
}
# This is the backup of the catalog
FileSet {
Name = "Catalog"
Include {
Options {
signature = MD5
}
File = /var/db/bacula/bacula.sql
}
}
Schedule {
Name = "MonthlyCycle"
Run = Level=Full Pool=Default 1st fri at 17:05
Run = Level=Differential 2nd-5th fri at 17:05
Run = Level=Incremental Pool=Default mon-sat at 17:05
}
# This schedule does the catalog. It starts after the WeeklyCycle
Schedule {
Name = "MonthlyCycleAfterBackup"
Run = Full sun-sat at 23:10
}
# Client (File Services) to backup
Client {
Name = zydeco-fd
Address = zydeco
FDPort = 9102
Catalog = MyCatalog
Password = "bacula" # password for FileDaemon
File Retention = 30 days # 30 days
Job Retention = 6 months # six months
AutoPrune = yes # Prune expired Jobs/Files
}
# Definition of file storage device
Storage {
Name = File
# Do not use "localhost" here
Address = titanic.ucolick.org # N.B. Use a fully qualified
name here
SDPort = 9103
Password = "bacula"
Device = FileStorage
Media Type = File
}
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = "db_bacula"; dbuser = "pg_user"; dbpassword = "something"
}
# Reasonable message delivery -- send most everything to email address
# and to the console
Messages {
Name = Standard
mailcommand = "/usr/local/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\"
-s \
"Bacula: %t %e of %c %l\" %r"
operatorcommand = "/usr/local/sbin/bsmtp -h localhost -f \"\(Bacula\)
\<%r\>\"
-s \"Bacula: Intervention needed for %j\" %r"
mail = r...@localhost = all, !skipped
operator = r...@localhost = mount
console = all, !skipped, !saved
#
# WARNING! the following will create a file that you must cycle from
# time to time as it will grow indefinitely. However, it will
# also keep all your messages if they scroll off the console.
#
append = "/var/db/bacula/log" = all, !skipped
}
# Message delivery for daemon messages (no job).
Messages {
Name = Daemon
mailcommand = "/usr/local/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\"
-s \
"Bacula daemon message\" %r"
mail = r...@localhost = all, !skipped
console = all, !skipped, !saved
append = "/var/db/bacula/log" = all, !skipped
}
# Default pool definition
Pool {
Name = Default
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle
Volumes
AutoPrune = yes # Prune expired volumes
Volume Retention = 365 days # one year
}
# Scratch pool definition
Pool {
Name = Scratch
Pool Type = Backup
}
# Restricted console used by tray-monitor to get the status of the director
Console {
Name = titanic-mon
Password = "bacula"
CommandACL = status, .status
}
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
