I'm trying to backup a Postgresql database using fifo's. The following is the fileset:
################################################################################
# List of files to be backed up
FileSet {
Name = "Postgresql dump"
Include {
Options {
signature = MD5
readfifo = yes
}
File = "/var/lib/pgsql/data/dump/globalobjects.dump"
File = /var/lib/pgsql/data/dump/fifo/otrs.data.dump
File = /var/lib/pgsql/data/dump/fifo/otrs.schema.dump
File = /var/lib/pgsql/data/dump/fifo/postgres.data.dump
File = /var/lib/pgsql/data/dump/fifo/postgres.schema.dump
File = /var/lib/pgsql/data/dump/fifo/template1.data.dump
File = /var/lib/pgsql/data/dump/fifo/template1.schema.dump
}
}
The following is exerpted from the client config:
# This creates a backup of the databases with pg_dump to fifos
Client Run Before Job = "su - postgres -c \"/etc/bacula/bin/make_pg_database_backup\""
# This deletes the backup and fifo files
Client Run After Job = "su - postgres -c \"/etc/bacula/bin/delete_pg_database_backup\""
The first script starts pgdump on each of the fifo's for each database. I've verified that that is working by manually catting the fifo to a temp file by hand, after the job finished.
I did a reload at the bconsole prompt, and then did a full backup.
Bacula does a backup, but it doesn't copy any data from the fifo.
I'm obviously missing something, but what?
Thanks in advance
JBB
--
The light at the end of the tunnel may be an oncoming Dragon
