Re: [Bacula-users] Volumes are not being recycled?

On 02/18/2016 08:44 AM, Phil Stracchino wrote:
> On 02/18/16 09:38, Dimitri Maziuk wrote:
>> MySQL can disagree with whatever it wants, but INTERVAL is an ANSI
>> SQL-92 *datatype* and the link you posted describes a bunch of
>> *functions* with no hint of standards compliance. There is a difference.
> I'm sorry, I misunderstood. I didn't realize we were talking about
> different things.

Specifically, I believe #3 below won't work in mysql:

1. User asked for ExpiresIn column to display something more useful than
an integer.

2. Bacula would do it if there was a way that worked in all supported

3. The standard way is to "CREATE TABLE media (... lastwritten
timestamp, volretention INTERVAL, ..." and then "SELECT ... lastwritten
+ volretention as ExpiresOn ..."

4. The intersection of "databases that support that part of the
standard" and "databases supported by bacula" is postgresql.

AFAIK, ICBW, and all that.
Dimitri Maziuk
BioMagResBank, UW-Madison --

Attachment: signature.asc
Description: OpenPGP digital signature

Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
Bacula-users mailing list