Debian 12 bookworm
Sponsored Link

Bacula : Install2023/08/09
 
Install Integrated Backup tool, Bacula.
[1]
Install PostgreSQL Server, refer to here of [1].
[2] Install Bacula components.
root@dlp:~#
apt -y install bacula-director bacula-director-pgsql bacula-sd bacula-console bacula-client
[3] Add a User and Database on PostgreSQL for Bacula.
# replace [password] to your own password

root@dlp:~#
su - postgres

postgres@dlp:~$
createuser bacula

postgres@dlp:~$
createdb bacula -O bacula --encoding=SQL_ASCII --template=template0

postgres@dlp:~$
psql -c "alter user bacula with password 'password'"

ALTER ROLE
postgres@dlp:~$
exit

logout
root@dlp:~#
vi /usr/share/bacula-director/make_postgresql_tables 
# line 14 : change
db_name=bacula

# line 16s : change
psql -f - -d ${db_name} -U bacula -h 127.0.0.1 $* <<END-OF-DATA
# create tables

root@dlp:~#
/usr/share/bacula-director/make_postgresql_tables 

Password for user bacula:

.....
.....

CREATE INDEX
INSERT 0 1
Creation of Bacula PostgreSQL tables succeeded.
Matched Content