Re: [Bacula-users] Separation of bacula-dir and Catalog service

[Bill Arlofski via Bacula-users]

On 11/21/22 02:16, Yateen Shaligram Bhagat (Nokia) wrote:

Hi all,

We are using Bacula 9.4 on Centos.

At the moment the bacula-dir and the catalog service (PgSQL server) are 
co-located  on one single host.

For optimization reasons, we need to move the PgSQL server to another server 
(FreeBSD based).

Is that possible?

Thanks,

Yateen Bhagat

Hello Yateen,

Yes, it is quite possible, and very simple to do.

In your bacula-dir.conf configuration look for a resource called `Catalog`

Here you set the host, port, user, and password to connect to the catalog 
database server.



Basic Steps:
------------
- Stop Director
- Dump bacula database
- Stop the database server on the Director, and disable it from starting
- Import database dump into new DB host
- Create remote user in new db server
- Grant this user full permission on bacula db
- Create any needed firewall rules to allow director server to connect to DB
- Edit bacula-dir.conf file on Director and specify correct DB settings in 
Catalog resource

- When all is OK from the command line on the Director, then start the Director 
and test.


Hope this helps!


Best regards,
Bill

--
Bill Arlofski
w...@protonmail.com

Just set these parameters to the correct ones for your new DB server, and on that DB server, make sure that the Director server is allowed to connect to the DB's port (ie firewall on db server), and also make sure to create the remote db user and grant it necessary permissions in the database. - Test from the command line with `psql cliednt toolto make sure connectivity to the bacula db on remote server is OK, correct any issues before moving on

signature.asc
Description: OpenPGP digital signature

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users