Hi @all,
make_catalog_backup works fine if i start it manually as bacula User.
But with a Backup Schedule I always get the follow Error Msg:
FATAL: password authentication failed for user "bacula"
*/etc/postgresql/8.4/main/pg_hba.conf*:
local bacula bacula 127.0.0.1/32 trust
*/var/lib/bacula/.pgpass:*
127.0.0.1:5432:bacula:bacula:PASSWORD
localhost:5432:bacula:bacula:PASSWORD
*make_catalog_backup:*
BINDIR=/usr/bin
cd /var/lib/bacula
rm -f $1.sql
if test xsqlite = xpostgresql ; then
echo ".dump" | ${BINDIR}/sqlite $1.db >$1.sql
else
if test xmysql = xpostgresql ; then
if test $# -gt 2; then
MYSQLPASSWORD=" --password=$3"
else
MYSQLPASSWORD=""
fi
if test $# -gt 3; then
MYSQLHOST=" --host=$4"
else
MYSQLHOST=""
fi
${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1
>$1.sql
else
if test xpostgresql = xpostgresql ; then
if test $# -gt 2; then
PGPASSWORD=$1
export PGPASSWORD
fi
if test $# -gt 3; then
PGHOST=" --host=$4"
else
PGHOST=""
fi
# you could also add --compress for compression. See man pg_dump
#exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 >$1.sql
exec ${BINDIR}/pg_dump -h localhost bacula |bzip2 -9 -f -c >
bacula.sql.bz2
else
echo ".dump" | ${BINDIR}/sqlite3 $1.db >$1.sql
fi
fi
fi
Thanks and regards
Tobias
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users