Re: [Bacula-users] versions table has two rows

On Sat, Sep 28, 2024, at 3:37 PM, Phil Stracchino wrote: > On 9/28/24 15:15, Dan Langille wrote: >> >> I found a solution after some searching: use ctid >> >>>From >>>https://www.postgresql.org/docs/current/ddl-system-columns.html#DDL-SYSTEM-COLUMNS-CTID >> >> "The physical location of the row

Re: [Bacula-users] Very long retention time

On 2024-08-15 09:14, Mehrdad Ravanbod wrote: Thank you Josip Appreciate your response, so if i understand correctly the whole ten year backup data need not be kept in DB?? Not sure about the bootstrap file and the rest though, new to bacula and trying to figure it out as yet Hello Mehrdad,

Re: [Bacula-users] Aggressively prune (and truncate) file volumes on Progressive backups...

On 9/28/24 15:20, Chris Wilkinson wrote: Sure. I put it here. It's a bash script. will need a bit of tweaking for your particular setup. https://drive.google.com/file/d/1WOFIjgZMx-XL2Jv7FqGupnjctLpUEhLG/view?usp=drivesdk

Re: [Bacula-users] Strategies for backup of millions of files...

On Thu, Sep 26, 2024, at 7:02 AM, Marco Gaiarin wrote: > Mandi! Arno Lehmann > In chel di` si favelave... > >> I have not looked up the discussion leading here. > > See my previous post: i'm fighting with ZFS. ;-) > > >> What I usually prefer is a combination of a Run Script on the client to >>

Re: [Bacula-users] versions table has two rows

On 9/28/24 15:15, Dan Langille wrote: I found a solution after some searching: use ctid From https://www.postgresql.org/docs/current/ddl-system-columns.html#DDL-SYSTEM-COLUMNS-CTID "The physical location of the row version within its table. Note that although the ctid can be used to locate

Re: [Bacula-users] FreeBSD: bacula9 and bacula11 are now deprecated

On Thu, Apr 4, 2024, at 8:11 AM, Dan Langille wrote: > Hello, > > HEADS UP for all FreeBSD users: sysutils/bacula9-server and > sysutils/bacula-11-server are deprecated and will be removed from the > ports tree at the end of September 2024 (they won't be in the 2024Q4 > ports tree branch). > > T

Re: [Bacula-users] Aggressively prune (and truncate) file volumes on Progressive backups...

Sure. I put it here. It's a bash script. will need a bit of tweaking for your particular setup. https://drive.google.com/file/d/1WOFIjgZMx-XL2Jv7FqGupnjctLpUEhLG/view?usp=drivesdk -Chris- On Sat, 28 Sept 2024, 19:52 Dan Langille, wrote: > On Fri, Sep 27, 2024, at 3:50 PM, Chris Wilkinson wrote

Re: [Bacula-users] versions table has two rows

On Mon, Sep 16, 2024, at 8:55 PM, Phil Stracchino wrote: > On 9/16/24 20:34, Dan Langille wrote: >> On Mon, Sep 16, 2024, at 5:46 PM, Phil Stracchino wrote: >>> On 9/16/24 15:17, Dan Langille wrote: >>> >>> delete from version order by version limit 1; >> >> bacula=*# delete from version order by

Re: [Bacula-users] Aggressively prune (and truncate) file volumes on Progressive backups...

On Fri, Sep 27, 2024, at 3:50 PM, Chris Wilkinson wrote: > I have a script to do that and a few other things. I use disc based backups > and am always conscious of running out of space. I'd be happy to PM it to you > if you wish. It's too big to send via the list. Would you consider just publish