Re: Bacula suddenly running very slow
Bill Arlofski via Bacula-users <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Message-ID | <[email protected]> |
On 8/7/24 1:11 PM, Chris Wilkinson wrote: > And then import the saved sql dump which drops all the tables again and creates/fills them? > > -Chris Hello Chris! My bad! I have been using a custom script I wrote years ago to do my catalog backups. It uses what postgresql calls a custom (binary) format. It's typically faster and smaller, so I switched to this format more than 10 years ago. I had not looked at an ASCII dump verison in years and I just looked now, and it does indeed DROP and CREATE everything. So, the only thing you needed to do was create the database with the create_bacula_database script, then Sorry for the static. :) Best regards, Bill -- Bill Arlofski [email protected] _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
signature.asc
(application/pgp-signature, 509 B)
-----BEGIN PGP SIGNATURE----- Version: ProtonMail wsBzBAEBCAAnBQJms9HzCRBIDTDab9XDQBYhBMuLnlBaSQiuSUbb6UgNMNpv 1cNAAACgigf/QtTxmK4/yyvtwF8FeCc1G335VueSHSNICP3pVlTWIZuTuA7M AwfFWZzJLtboBwM/2XO8gJ7XXGtgBZYLwRUx+g/G92PaN0WwSZ0Hlv/gvLK1 xk0SRgKVGYjZIqGMot6xY5dI1UnGgtC7goCX2o8hOaFwNsZksssS9dXRjnVN XzwX/+6eAI/TZqXVbgX8jpBhEMlftUXalkXR493tmPlOpQsgApsMzd/7s/c0 /xt4ChoKf4KIk37Kgw49IbU37OLMnOzAr6SAusuWSAWPczLlKmHXVTdvvyRH n6cVwBFTYJrMxHjuvD7HU04aAP/8kHBfbgzBc7biiCgXy1otL7Jzhg== =aBSH -----END PGP SIGNATURE-----