Re: [Bacula-users] Q. storage groups for a given pool using several external USB HDDs?

Hello Justin, You're welcome! If you plan to monitor the disk space in each USB storage, then I think removing the usb storage from the list is reasonable. You don't need it to be in the list for restore purposes, Bacula will find out the storage required by the restore. vchanger helps to spread

Re: [Bacula-users] Q. storage groups for a given pool using several external USB HDDs?

Hi Ana, thank you for chiming in, see my response inline: > On 1. Sep 2022, at 13:38, Ana Emília M. Arruda wrote: > > On Tue, Aug 30, 2022 at 3:43 PM Justin Case > wrote: > Greetings, > > I am interested in the new V13 storage groups feature. > If I wanted a given

Re: [Bacula-users] Migrating from mariadb to postgresql

On 2022-09-01 7:57 AM, Uwe Schuerkamp wrote: ... So I'm wondering why "text" would end up displayed as "hex" in bconsole? Because it's a hex text, presumably ;) This is likely happening when pulling the data out of mysql, not when displaying it in bconsole. You could try `select encode(Volu

Re: [Bacula-users] Migrating from mariadb to postgresql

Yes, that's what I meant. With the default casts, pgloader will convert those fields to binary and use hex-encoded strings in the SQL (https://www.postgresql.org/docs/current/datatype-binary.html#id-1.5.7.12.9). Since the actual PostgreSQL field type is text, the encoded strings are then inserted

Re: [Bacula-users] Migrating from mariadb to postgresql

Hello Uwe I found a document on the internet about pgloader. Maybe it would be necessary to make a cast of the fields. https://pgloader.readthedocs.io/en/latest/ref/mysql.html#mysql-database-casting-rules Best regards *Wanderlei Hüttel* Em qui., 1 de set. de 2022 às 10:00, Uwe Schuerkamp <

Re: [Bacula-users] Migrating from mariadb to postgresql

On Thu, Sep 01, 2022 at 01:01:31PM +0100, Martin Simmons wrote: > The volume name above is "zif-incr-0019" if you decode the hex, so it looks > like you need to add some translation from the various BLOB types to text in > the pgloader configuration if that is possible. By default, pgloader conve

Re: [Bacula-users] Migrating from mariadb to postgresql

> On Thu, 1 Sep 2022 09:38:08 +0200, Uwe Schuerkamp said: > > I've now used the bacula provided scripts to create the database, > tables and grants and have reloaded the catalog using this gploader > file: > > LOAD DATABASE > FROM mysql://bacula:vampyre2020k@localhost/bacula > INTO postgresql

Re: [Bacula-users] Q. storage groups for a given pool using several external USB HDDs?

Hello Justin, Currently there are two storage group policies that you can use: StorageGroupPolicy = Storage Group Policy determines how Storage resources (from the 'Storage' directive) are being choosen from the Storage list. If no StoragePolicy is specified Bacula always tries to use first avai

[Bacula-users] Working for Bacula?

Hello, If you like Bacula, maybe you would like to have the opportunity to work for Bacula Systems and contribute to improve Bacula over the time. We have two open positions for the moment, and you are welcome to apply. https://baculasystems.com/company/careers-at-bacula-systems/senior-technical

Re: [Bacula-users] Migrating from mariadb to postgresql

Hi folks, On Tue, Aug 30, 2022 at 03:53:47PM +0100, Martin Simmons wrote: > Bacula will probably not work if pgloader created the schema. I think you > should do that part with Bacula's make_postgresql_tables script and configure > pgloader to keep that schema (i.e. the opposite of most of the "