[Bacula-users] pgtune fixes a dbcheck postgresql out of memory error for me - FYI

2023-06-16 Thread kjohnson
I wanted to move the bacula database from Postgresql 11 (PG11) to Postgresql 13 (PG13) in advance of an operating system upgrade from Debian 11.6 to Debian 12, and eventual upgrades to Postgresql (version current in Debian 12). Unfortunately, running dbcheck on the moved database provoked an

Re: [Bacula-users] What is 'voltype'?

2023-03-03 Thread kjohnson
Rob, Thanks for this helpful reply. It had not occurred to me to look through the configuration files. As far as the current manual is concerned, "searches in main.pdf dated 14 Sep 2022 for "voltype" and "Volume Type" both came up empty." Perhaps different search terms would have been more

[Bacula-users] What is 'voltype'?

2023-03-01 Thread kjohnson
bconsole list volume displays a field called 'voltype'. What is this used for, and how can I set it? Searches in main.pdf dated 14 Sep 2022 for "voltype" and "Volume Type" both came up empty. I have a backup job that should run on a volume that has a voltype of 0, and it will not progress.

Re: [Bacula-users] Comm Line Compression report

2022-05-16 Thread kjohnson
'Radoslaw Korzeniewski' suggested that I could take the Comm Line Compression report at face value; I appreciate this interest in my problem. Based on my 'feel' for the system usage, I thought there was a real issue. But today I collected numeric data. Today I used "find -mmin -$((60*24*7))

[Bacula-users] Comm Line Compression report

2022-05-12 Thread kjohnson
I use bacula to perform 5 backups per week of a server here running Debian 10, and version 9.4.2-2+deb10u1 of bacula. Each backup is of the same set of data, so only the most recent tape is needed for a restore. Each backup is to an LT06 tape installed on the server, and about 800 GB is

Re: [Bacula-users] postgres createdb for bacula fails

2021-05-05 Thread kjohnson
Here's how I solved my problem, at least for now. This approached was inspired by the helpful replies I received, though it does not exactly replicate any of them. I took these steps on the test system: aptitude remove bacula-common bacula-common-pgsql bacula-console bacula-director

Re: [Bacula-users] postgres createdb for bacula fails

2021-05-04 Thread kjohnson
All, I want to thank Michel Figgins, Dan Langille, Dimitri Maziuk, and Serio Gelato for replying to my request for help. I'm working on it, but a variety of circumstances mean it will probably be a couple of days before I have results. Thanks. Ken -Original Message- From:

[Bacula-users] postgres createdb for bacula fails

2021-05-03 Thread kjohnson
As time permits, I am working on an sqlite to postgres conversion of a bacula database, in preparation for upgrading from Debian 9 to Debian 10. For a variety of reasons I believe I am pretty close. But... There are three systems involved: the live server (Debian 9), the system where the