Re: [Bacula-users] Extraction of a specific file

[Rob G. <ro...@cr...>]

I'm not sure, but maybe you'll need to query your database directly instead
of relying on Bacula to simplify that process. *This is not an educated
answer, just my novice guess.*

I see bacula bconsole has a 'query' command that I believe passes SQL query
language commands on to the relevant DB server. Might want to look into
that, possibly in the bacula console operators manual. I've used the PDF
copy of the documentation because it's easier to search.

Slightly off-topic:
I think when it comes to interacting with your DB server of choice, bacula
is deliberately vague because they expect you to know how to admin the DB
server yourself. I think they're also vague sometimes because the user
could be using any of several different DB servers (Sqlite, MySQL/mariadb,
postgresql). (Postgresql is the currently recommended DB server of choice.)
I know when it came time to restore a database backup there weren't any
Bacula-centric instructions. Why? Because the DB restore wasn't done
through Bacula. It was done using postgresql psql console. It was
definitely weird though, I found instructions everywhere in Bacula docs for
how to back up the database, and nothing about how to restore it. In the
end, the restore was easy.

Robert Gerber
402-237-8692
ro...@cr...

On Sat, Sep 30, 2023, 3:27 PM Dr. Thorsten Brandau <
tho...@br...> wrote:

> Hi
>
> I was trying to get a list of files (via bconsole) of the backups I do on
> tape (most recent for example). The only way I found is to use "restore"
> and then select the last backup. I was able to see some directories (e.g.
> /mnt/data) but not the files that were backup up.
>
> Is there a way to get a list of all files in the backup, preferably with
> date, size etc.?
>
> I am looking for a function like
>
> list files=*officedocument*.odt
>
> or so. It should be wildcard aware.
>
> The onlinedocumentation is not in a way that I would understand how it is
> possible, so maybe I am just too stupid (and there are not a lot of
> examples, especially for restore etc.).
>
> Cheers
>
> T
> _______________________________________________
> Bacula-users mailing list
> Bac...@li...
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>