Hello,

I originally started with MySQL, so know it well, but over the years, I realized that PostgreSQL performed better for larger type backups (500 or more clients) or bigger catalogs, so I switched from MySQL to PostgreSQL.

It was a bit painful because the first user generated script I used that converted MySQL sql output didn't go into Postgres at all. After much tweaking I got it to work, but that was probably between about 10 years ago.

I will see if I can get a script that is known to work with current MySQL and PostgreSQL.

By the way, after switching, I have had zero problems with PostgreSQL.

Best regards,
Kern

On 08/07/2018 11:45 AM, George Anchev via Bacula-users wrote:
On Tue, 7 Aug 2018 11:24:36 +0200 Kern Sibbald wrote:

Right at the moment, I don't recommend using
MariaDB.  They are just now fixing a very serious
false deadlock detection bug that causes Bacula to
fail.
Thanks for the info Kern.

In this case:

How can I migrate my catalog to PostgreSQL please?
(considering I have never used PostgreSQL)

--
George

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to