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

2022-08-30 Thread Wanderlei Huttel
Hello Uwe I've made a script to migrate MySQL/MariaDB to PostgreSQL https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql I've found errors only in the Log table. I've looked for chars with wrong encoding and make an update in MySQL, did a dump and import again f

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

2022-08-30 Thread Charles Tassell
Hi Uwe,   I think Martin was right with this one.  You are probably going to have to edit the export file from mysqldump to remove the inserts for tables that the Postgres schema maker creates automatically.  To make this easier, so you don't have to recreate the schema each time, you can use

[Bacula-users] Community 11.0.6 binaries for el9

2022-08-30 Thread Dirk
When are you going to release Bacula Community 11.0.6 binaries for EL9?  We are on hold with our el9 deployment waiting for Bacula 11.0.6 binaries. OL9 (Oracle Linux 9, a redist of RHEL9) is available for free from here: https://yum.oracle.com/oracle-linux-isos.html --- _

Re: [Bacula-users] Need help with fileset declaration - what's my mistake?

2022-08-30 Thread Justin Case
Martin, you are right, my bad, I overlooked that you were not using RegexDir, but Regex for the exclude. I am very glad that your solution works, thank you so much. I have to admit, on that evening I had been mucking around a lot more and also a friend, and none of our attempts worked as intend

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

2022-08-30 Thread Martin Simmons
> On Tue, 30 Aug 2022 16:04:08 +0200, Uwe Schuerkamp said: > > Hello Charles, > > thanks for "INSERT only" idea... it's worked partially. After removing > some double quotes and other characters using sed psql didn't like, > the import runs for a while and then stops with the following error:

[Bacula-users] Q: what do JobtoVerify, WriteVerifyList ?

2022-08-30 Thread Justin Case
Hi all, I am using Baculum to manage my Bacula V11 installation. Today I wanted to define a verify job for the first time. In Baculum I find 3 fields in the Verify section: VerifyJob: AFAU this is the name of the job which should be verified (I am using Level “Data). JobToVerify: no idea what

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

2022-08-30 Thread dmitri maziuk
On 2022-08-30 9:04 AM, Uwe Schuerkamp wrote: INSERT 0 6 ERROR: duplicate key value violates unique constraint "status_pkey" DETAIL: Key (jobstatus)=(A) already exists. Any idea what could be causing this? Without looking at the actual DDL, I'd say your tables are wrong and primary key shou

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

2022-08-30 Thread Martin Simmons
> On Mon, 29 Aug 2022 08:28:31 +0200, Uwe Schuerkamp said: > Mail-Followup-To: Uwe Schuerkamp , > > On Thu, Aug 25, 2022 at 06:57:46PM +0100, Martin Simmons wrote: > > Do you have non-ASCII characters in your volume, job or client names? If > > not, > > then I don't see why the warning would

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

2022-08-30 Thread Uwe Schuerkamp
Hello Charles, thanks for "INSERT only" idea... it's worked partially. After removing some double quotes and other characters using sed psql didn't like, the import runs for a while and then stops with the following error: INSERT 0 6 ERROR: duplicate key value violates unique constraint "status_

Re: [Bacula-users] Need help with fileset declaration - what's my mistake?

2022-08-30 Thread Martin Simmons
The order of the File declarations relative to the Options declarations doesn't matter. However, the order of the Options declarations relative to each other does matter (Bacula uses the first Options that matches based on RegexDir etc). The problem below is that you are using RegexDir instead of

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

2022-08-30 Thread Justin Case
Greetings, I am interested in the new V13 storage groups feature. If I wanted a given pool to use file folumes on several externally connected USB HDDs: -the devices would be connected all the time, would the director fill the devices one ofter the other, or would it scatter the jobs randomly a

[Bacula-users] Bacula Status report - 30 August 2022

2022-08-30 Thread Eric Bollengier via Bacula-users
The topics for this Status Report are: 1. Bacula Release Status 2. Bacula Binaries 3. Windows Binaries 4. macOS Binaries 5. New Services === 1. Bacula Release Status The latest Bacula version 13.0.1 was released to Source Forge and to www.bacula.org. This version includes many enhancement

[Bacula-users] Gitlab migration

2022-08-30 Thread Eric Bollengier via Bacula-users
Dear All, As a valued member of the Bacula Community and a user of either Git or Mantis bug tracker for Bacula Community, we would like to inform you that we have started to migrate your mantis account and issues to the new GitLab instance. The Gitlab instance, like the git repository and Mantis