Re: [Bacula-users] Migrating from mariadb to postgresql

2022-09-07 Thread dmitri maziuk
On 2022-09-07 5:27 AM, Uwe Schuerkamp wrote: sql_create.c:483 Create DB Media record INSERT INTO Media (VolumeName,MediaType,MediaTypeId,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime,VolT

Re: [Bacula-users] Migrating from mariadb to postgresql

2022-09-05 Thread dmitri maziuk
On 2022-09-05 11:14 AM, Martin Simmons wrote: ... I think you need convert_from(), not encode(). Something like select convert_from(VolumeName::bytea, 'SQL_ASCII') from media; Right, I saw the starting '\x' and looked no further. OP will have to figure out what encoding that POS is actually

Re: [Bacula-users] Migrating from mariadb to postgresql

2022-09-05 Thread dmitri maziuk
On 2022-09-05 4:21 AM, Uwe Schuerkamp wrote: bacula=# select encode(VolumeName, 'hex') from media; encode 7a69662d66756c6c2d30303031 7a69662d696e63722d30303032 7a69662d696e63722d30303033 ... Is the "\xss850938sdkl" you posted before an actual va

Re: [Bacula-users] Migrating from mariadb to postgresql

2022-09-01 Thread dmitri maziuk
On 2022-09-01 7:57 AM, Uwe Schuerkamp wrote: ... So I'm wondering why "text" would end up displayed as "hex" in bconsole? Because it's a hex text, presumably ;) This is likely happening when pulling the data out of mysql, not when displaying it in bconsole. You could try `select encode(Volu

Re: [Bacula-users] Migrating from mariadb to postgresql

2022-08-30 Thread dmitri maziuk
On 2022-08-30 9:04 AM, Uwe Schuerkamp wrote: INSERT 0 6 ERROR: duplicate key value violates unique constraint "status_pkey" DETAIL: Key (jobstatus)=(A) already exists. Any idea what could be causing this? Without looking at the actual DDL, I'd say your tables are wrong and primary key shou

Re: [Bacula-users] bsmtp from within a container

2022-08-02 Thread dmitri maziuk
On 2022-08-02 3:46 PM, Justin Case wrote: The container uses the container ID as hostname. nothing I can do about it with DNS. I will retire the Synology mail server at somepoint but that is months in the future. I disabled authentication for local networks, but still: 504 5.5.2 <3422f1072002>

Re: [Bacula-users] bsmtp from within a container

2022-08-02 Thread dmitri maziuk
On 2022-08-02 2:16 PM, Justin Case wrote: I run the mailserver put its basically a tightly baked postfix dovecot under Synology DSM UI. So I won’t manually change config files. But “Ignore authorization for LAN connections” sounds reasonable, I have activated that now. Lets see if that helps.

Re: [Bacula-users] bsmtp from within a container

2022-08-01 Thread dmitri maziuk
On 2022-08-01 3:57 PM, Justin Case wrote: bsmtp: bsmtp.c:124-0 Fatal malformed reply from mailserver.dummy.net: 504 5.5.2 <3422f1072002>: Helo command rejected: need fully-qualified hostname Who runs the mailserver? Typically you's set "permit-mynetworks" before "reject-XX-helo-hostname" and

Re: [Bacula-users] PostgreSQL replication

2022-07-27 Thread dmitri maziuk
On 2022-07-26 7:19 PM, Shaligram Bhagat, Yateen (Nokia - IN/Bangalore) wrote: Hi all, We are using Bacula 9.x on CentOS with PostgreSQL. I am curios to know if anyone has implemented PostgreSQL replication to a remote site for disaster recovery preparedness. Not for bacula server and I'm not

Re: [Bacula-users] Q: Bacula for TrueNAS Core?

2022-06-19 Thread dmitri maziuk
On 2022-06-19 5:02 PM, Larry Rosenman wrote: For the record it's FreeBSD, not OpenBSD. Sorry, us liGNUx lusers keep forgetting which one's which, or why. Dima ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourcefo

Re: [Bacula-users] Q: Bacula for TrueNAS Core?

2022-06-19 Thread dmitri maziuk
On 2022-06-19 2:42 PM, Radosław Korzeniewski wrote: But reading on the internet what iX-Systems Plugins are I think it is not what I understand with the above term. TrueNAS is a specialized version of OpenBSD that comes with web-based UI to ZFS storage subsystem. A plugin is a binary packaged

Re: [Bacula-users] Q: one job for a group of "identical" machines using the same fileset?

2022-06-15 Thread dmitri maziuk
On 2022-06-15 11:21 AM, Justin Case wrote: in the age of virtualization and cloud technology such as Kubernetes I would assume that people might have a lot of VMs that use the same setup where they may store container user data under the same path for each machine. This is somewhat related t

Re: [Bacula-users] Q: Bacula for TrueNAS Core?

2022-06-15 Thread dmitri maziuk
On 2022-06-15 5:49 AM, Justin Case wrote: ... All the best, I am looking forward to your thoughts on this. My $.02 is why? If you're looking for a basic undelete/rollback capability, ZFS has snapshots. It can ship those incrementally to another ZFS system, in the long run the 2nd system tends

Re: [Bacula-users] Virtual tapes or virtual disks

2022-01-26 Thread dmitri maziuk
On 2022-01-26 12:57 PM, Josip Deanovic wrote: The number of files per directory is far bigger and is unlikely to get reached, especially not for this use case. The limit is one thing, the scaling is another. I agree: 40TB of 10GB files is not enough to see the slow-down on any modern system,

Re: [Bacula-users] Virtual tapes or virtual disks

2022-01-26 Thread dmitri maziuk
On 2022-01-26 11:59 AM, Peter Milesson via Bacula-users wrote: ... I'm having a RAID5 array of about 40TB in size. A separate RAID controller card handles the disks. I'm planning to use the normal ext4 file system. It's standard and well known, most probably not the fastest though. That will

Re: [Bacula-users] Virtual tapes or virtual disks

2022-01-26 Thread dmitri maziuk
On 2022-01-26 11:06 AM, Peter Milesson via Bacula-users wrote: ... Your way of explaining the reasoning of why to use smaller file volumes, is very appreciated. ... The only thing I haven't found out is how to preallocate the number of volumes needed. Maybe there is no need, if the volumes

Re: [Bacula-users] postgres db error while despooling attributes to database

2022-01-12 Thread dmitri maziuk
On 2022-01-12 12:06 PM, mark.berg...@pennmedicine.upenn.edu wrote: bacula: 9.6.5 Postgres 8.4.20 After some large (12TB, 7TB) backup jobs finished and were in the process of despooling attributes to the database, I got the followingg errors: 12-Jan 12:43 vbacula JobId 131494: Fatal err

Re: [Bacula-users] Bacula for QNAP?

2022-01-04 Thread Dmitri Maziuk
On 1/4/2022 12:21 PM, Phil Stracchino wrote: ... This is why for many years now my NAS has run Solaris.  It is THE reference implementation of NFS. Same reason we kept our storage on Solaris for as long as we could at $work[-1], long after Sun quit doing 50% off "educational" sales and priced

Re: [Bacula-users] Bacula for QNAP?

2022-01-04 Thread Dmitri Maziuk
On 1/3/2022 8:05 PM, Gary R. Schmidt wrote: On 04/01/2022 05:47, David Brodbeck wrote: ... I could see iSCSI maybe working better, but I haven't tried it. iSCSI is not the same as NFS (or SMB), it shares a "raw device" which the mounting system then formats and uses, the device can't be sha

Re: [Bacula-users] Bacula for QNAP?

2022-01-04 Thread Dmitri Maziuk
On 1/3/2022 1:31 PM, Phil Stracchino wrote: I did consider completely wiping the thing and installing either Gentoo Linux or Solaris x86.  But I hesitate to do that on a brand new unit still under warranty. I usually pull out the system drive and stick a clean one in for this. But they proba

Re: [Bacula-users] Bacula for QNAP?

2022-01-03 Thread Dmitri Maziuk
On 1/3/2022 7:23 AM, Andrea Venturoli wrote: On 1/3/22 13:56, Heitor Faria wrote: Therefore, you could try TrueNAS , which is based on FreeBSD Then I'd use FreeBSD directly, as I do for servers :) True (formerly known as Free) NAS is FreeBSD, it's just everything

Re: [Bacula-users] Bacula for QNAP?

2022-01-02 Thread Dmitri Maziuk
On 1/2/2022 7:18 AM, Jose Alberto wrote: I have a NAS with HP StoreOnce. I have 4 network ports. Take one of them and connect it point to point with the Bacula. In Bacula I do a mount NFS readonly In this way backup (backup) everything that exists in the NFS at transfer rates between 100 and

Re: [Bacula-users] make_catalog_backup stopped working

2021-12-27 Thread Dmitri Maziuk
On 12/27/2021 2:02 PM, Josip Deanovic wrote: On 2021-12-27 19:19, Phil Stracchino wrote: ... The blazes?   If mysql.user is a VIEW, something is VERY BADLY WRONG. Are you still using Akonadi's MySQL instance? Yes, that doesn't look normal. I hope it's not something Suse specific. Go

Re: [Bacula-users] make_catalog_backup stopped working

2021-12-27 Thread Dmitri Maziuk
On 12/27/2021 1:44 PM, Josip Deanovic wrote: 'localhost' and '%' are special keywords. 'localhost' applies only to unix socket. '%' has a meaning of any AF_INTET socket (any IP address or host) So, the '%' does not include 'localhost'. Thank you, I learned something today (not that I wanted

Re: [Bacula-users] make_catalog_backup stopped working

2021-12-27 Thread Dmitri Maziuk
On 12/27/2021 7:24 AM, Graham Dicker wrote: ... If I change the Catalog definition from dbname = "bacula"; dbuser = "bacula"; dbpassword = "" to dbname = "bacula"; dbuser = "root"; dbpassword = "" then Bacula does work but it doesn't "see" the volumes already in the database and wants to crea

Re: [Bacula-users] New Bacula Server with multiple disks

2021-12-16 Thread dmitri maziuk
On 2021-12-16 3:44 AM, mac-eduki2.co.uk wrote: Good day I hope this message finds you all well. I have been running a small Bacula server with a single disk for a number of years now and it has become a vital part of our small business. I setup our original server with some help from the comm

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

2021-05-03 Thread dmitri maziuk
On 2021-05-03 7:38 PM, Dan Langille wrote: On Mon, May 3, 2021, at 6:16 PM, kjohn...@eclypse.org wrote: DETAIL: The chosen LC_CTYPE setting requires encoding "UTF8". $ createdb -E SQL_ASCII -T template0 bacula $ dropdb bacula $ export LC

Re: [Bacula-users] how to tell 9.6 director to use mysql?

2020-07-20 Thread Dmitri Maziuk
On 7/20/2020 8:50 PM, Gary R. Schmidt wrote: Every day that you learn something new is a good day! I had no idea that Fedora had anything like that - I've seen it on Solaris - I will have to add it to my "things that you needed to know before you broke that" list.  :-) It's from debian actu

Re: [Bacula-users] how to tell 9.6 director to use mysql?

2020-07-20 Thread Dmitri Maziuk
On 7/20/2020 6:31 PM, Gary R. Schmidt wrote: On 21/07/2020 09:21, Greg Woods wrote: Has this always been the case? Yes. Wow. I could swear I installed a backend-specific library RPM and made a symlink or something in the version we're using. It all must've been a figment of my imagination

Re: [Bacula-users] areas for improvement?

2020-06-12 Thread Dmitri Maziuk
On 6/12/2020 12:39 PM, David Brodbeck wrote: None of this, of course, is an issue when backing up always-on servers with static IPs -- which is Bacula's focus. Not really: what's happening is if an intermediate node goes down, IP will find a different route -- *at the network layer*. We nor

Re: [Bacula-users] Converting from Sqlite3

2019-07-05 Thread Dmitri Maziuk via Bacula-users
On 7/4/2019 5:24 AM, Axel Kittenberger wrote: So... what would you recommend, MariaDB or PostGres? That's easy: last I heard mariadb was not officially supported so it's postgres or postgres. Dima ___ Bacula-users mailing list Bacula-users@lists

Re: [Bacula-users] Doubts about Bacula

2019-04-23 Thread Dmitri Maziuk via Bacula-users
On Tue, 23 Apr 2019 23:43:12 +1000 "Gary R. Schmidt" wrote: > 1 - That was proper clusters, that was, not the half-arsed crap that > lusers call clustering these days. It's called availability to the max. As in 737 Ma

Re: [Bacula-users] Doubts about Bacula

2019-04-16 Thread Dmitri Maziuk via Bacula-users
ilover. Using drbd for backup storage is just a waste of disk. I'd also try to run bacula in a container instead of VM at this point. but that's just me. -- Dmitri Maziuk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net htt

Re: [Bacula-users] Multiple disk usage

2019-03-31 Thread Dmitri Maziuk via Bacula-users
more manual work, but not too much. -- Dmitri Maziuk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Error running bacula-sd 9.2.2 on a Zyxel NSA310 [SOLVED]

2019-03-04 Thread Dmitri Maziuk via Bacula-users
On 3/4/2019 10:11 AM, Josh Fisher wrote: ... The fix should be either compiling Bacula with the correct headers or else file a bug report with Zyxel. Or to use plain accept() and call fcntl() with CLOEXEC. As I understand it, there can be a race condition if you fire off your pre-(post-?)job

Re: [Bacula-users] Error running bacula-sd 9.2.2 on a Zyxel NSA310 [SOLVED]

2019-03-01 Thread Dmitri Maziuk via Bacula-users
On 3/1/2019 10:10 AM, Josh Fisher wrote: On 3/1/2019 6:34 AM, Kern Sibbald wrote: At this point, my best assessment is that there is a bug in the Zyxel libraries. It is certainly a bug in the Zyxel libraries. The accept4() is throwing a ENOSYS, meaning that the function is simply not impl

Re: [Bacula-users] Error running bacula-sd 9.2.2 on a Zyxel NSA310 [SOLVED]

2019-02-28 Thread Dmitri Maziuk via Bacula-users
On 2/28/2019 8:06 AM, Andrea Venturoli wrote: On 2/28/19 2:23 PM, Martin Simmons wrote: That suggests the function accept4 was defined at compile time by fails with errno=38 (ENOSYS) at run time. I don't know what to answer. I'm not competent enough to understand the difference between the t

Re: [Bacula-users] Spooling vs buffering

2019-02-07 Thread Dmitri Maziuk via Bacula-users
; > file is filling up the first time. Your clients can stream data over the net at your LTO-whatever's full throughput, and you can't afford an 800 GB SSD? Interesting setup you have. -- Dmitri Maziuk ___ Bacula-users mailing list B

Re: [Bacula-users] [External] Re: [Bacula-devel] IBAdmin

2019-01-26 Thread Dmitri Maziuk via Bacula-users
rious problem with. APIs are work and IME everyone wants something just different enough that you have to add more API calls, and more, until you end up looking like matlab. -- Dmitri Maziuk ___ Bacula-users mailing list Bacula-users@li

Re: [Bacula-users] [Bacula-devel] IBAdmin

2019-01-25 Thread Dmitri Maziuk via Bacula-users
Swearing is not an opinion. Swearing is an expression of, in this case, disbelief. -- Dmitri Maziuk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backing up to NetApp

2019-01-20 Thread Dmitri Maziuk via Bacula-users
On Sun, 20 Jan 2019 15:06:53 -0500 Dan Langille wrote: > Have you backed up to NetApp? No, and we recently turned our FAS2020 boat anchor off altogether, for various reasons, but I would pick iscsi over nfs/cifs for this. -- Dmitri Maz

Re: [Bacula-users] "ERR=database or disk is full" while building directory tree for restore

2018-12-27 Thread Dmitri Maziuk via Bacula-users
sort of see the need back when the only alternative on winders was trying to get AOL CD users to build postgres in cygwin and... and even then one could find e.g. interbase for free if one looked. -- Dmitri Maziuk ___ Bacula-users mailing list B

Re: [Bacula-users] Tape shoe-shining with spooling enabled - why?

2018-12-23 Thread Dmitri Maziuk via Bacula-users
; new. > > I am not familiar with Bacula's cross-platform support, so is this > something that can simply be changed? Or could it just be wrapped by > an `#ifdef MTWEOFI`? RHEL 6 is based on 2.6.32 with an unknown number of back-ported patches. It'll be wi

Re: [Bacula-users] "ERR=database or disk is full" while building directory tree for restore

2018-12-22 Thread Dmitri Maziuk via Bacula-users
going to get mariadb that Kern doesn't support either, once you hit 50M and 1 records you'll need to figure out how to tune up your innodb, when to optimize every table, etfc. Postgres is pretty much fire-and-forget. -- Dmitri Maziuk ___ Bacu

Re: [Bacula-users] Nagios notification setup

2018-12-05 Thread Dmitri Maziuk via Bacula-users
esses (incl. bacula) in the mib and a little perl wrapper around snmpwalk on the nagios side. -- Dmitri Maziuk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] PostgreSQL: WAL and log management

2018-11-26 Thread Dmitri Maziuk via Bacula-users
r e.g. deletions, a WAL stores the entire old row, and the entire new row. You could run a bunch of deletes and inserts and make it grow big, that's how yours could get that way. The issue though is that posgres is largely self-tuning, and normally that would gradually go down to max_

Re: [Bacula-users] PostgreSQL: WAL and log management

2018-11-25 Thread Dmitri Maziuk via Bacula-users
On Sat, 24 Nov 2018 21:59:41 +0200 George via Bacula-users wrote: > On Sat, 24 Nov 2018 11:39:37 -0600 Dmitri Maziuk via > Bacula-users wrote: > > > So set > > max_wal_senders = 0 > > as well. Now looking at the fine manual I see they > > changed the

Re: [Bacula-users] PostgreSQL: WAL and log management

2018-11-24 Thread Dmitri Maziuk via Bacula-users
eaming (max_wal_senders > 0) requires wal_level > "replica" or "logical" So set max_wal_senders = 0 as well. Now looking at the fine manual I see they changed the default from 9.x, it used to be 0. -- Dmitri Maziuk ___ Bacula-

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

2018-11-17 Thread Dmitri Maziuk via Bacula-users
On 11/17/2018 10:56 AM, George Anchev via Bacula-users wrote: # systemctl status postgresql starts the service. In the 'status' details I see: /usr/lib/postgresql10/bin/postgres -D /var/lib/pgsql/data So from here: How should I proceed with Bacula? As per the fine manual: create bacula role

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

2018-11-17 Thread Dmitri Maziuk via Bacula-users
On 11/17/2018 5:37 AM, George Anchev via Bacula-users wrote: On Fri, 16 Nov 2018 17:46:13 -0600 Dimitri Maziuk via Bacula-users wrote: Well, that's b0rk3d. What can be done about it? You'd have to ask suse. It may be that you need to run 'pg_ctl initdb' to get it all created. Dimitri __

Re: [Bacula-users] Looking for a LTO autoloader

2018-11-13 Thread Dmitri Maziuk via Bacula-users
to switch to BSD just yet... However Lennartware is helping: I'm only deploying Centos 6 on servers now -- though our backup host is from back before that decision so it's still running 7.latest. -- Dmitri Maziuk ___ Bacula-

Re: [Bacula-users] Looking for a LTO autoloader

2018-11-13 Thread Dmitri Maziuk via Bacula-users
re, but in my > area the bandwidth is far more expensive than tapes. Do you need a 10G link though? -- For the amounts I'm backing up here 1G works fine. The other issue is RAID-10 and mhvtl: if you do disk backup, why go through the extra laye

Re: [Bacula-users] Problem connecting to storage daemon [SOLVED]

2018-04-19 Thread Dmitri Maziuk
On 4/19/2018 11:27 AM, Martin Simmons wrote: ... public ip for localhost ... I've often wondered: is there a good reason for doing that in the hosts file? Last I heard linux kernel was supposed to figure it out and route connections to self locally regardless of the ip. IOW no, and bacula is

Re: [Bacula-users] Backups to Google Drive?

2016-07-29 Thread Dmitri Maziuk
On 7/28/2016 9:37 AM, Ken Mandelberg wrote: > Just wondered if anyone had tried anything like this. Maybe there > is different backup software that would be a better fit. Yes. Amazon offers it for pay. There was also this but I don't read Deutch: http://www.libe.net/index.php/MHVTL Dima

Re: [Bacula-users] Bacula causing high disk-io on clients

2015-06-27 Thread Dmitri Maziuk
On 6/27/2015 8:55 AM, Alex Domoradov wrote: > FYI > > I have 1Gb uplinks between bacula sd and client and get the following > results > > Compression: NONE > Time: 07:16:58 > Size: 831.14 GB > Files: 11,288,747 > Speed: 32.46 MB/s > Compression: 0.00 > > Compression: LZO > Time: 07:56:38 > Size: 65

Re: [Bacula-users] Bacula causing high disk-io on clients

2015-06-27 Thread Dmitri Maziuk
On 6/26/2015 7:26 AM, Josh Fisher wrote: > However, for backup devices lacking hardware compression (such as disk), > compression may be warranted regardless of client connection speed. This > is why a SD level compression feature would be useful. Compressing data on the client means fewer bytes

Re: [Bacula-users] Job auto-pruning and automatic volume recycling with disabled pool auto-pruning

2015-02-06 Thread Dmitri Maziuk
On 2/6/2015 6:52 AM, Heiko Wundram wrote: > that's not what I meant: I don't want to reclaim parts of a volume, but > simply that Bacula keeps the (complete) volume until no more jobs are > stored on it (i.e. no more jobs in the catalog reference the volume), > and then (and only then) recycles it

Re: [Bacula-users] [Bacula-devel] Request for help

2015-02-02 Thread Dmitri Maziuk
On 2/2/2015 9:56 AM, Dmitri Maziuk wrote: > ... WTF did > think would happen? Where's the "you", I swear I had a "you" in there. -- Dive into the World of Parallel Programming. The Go

Re: [Bacula-users] [Bacula-devel] Request for help

2015-02-02 Thread Dmitri Maziuk
On 2/1/2015 11:49 AM, Phil Stracchino wrote: > Oh boy, That's quite the irony, isn't it, Kern? Bareos is accusing you > of misusing and misappropriating code that was submitted under a > reuse/redistribution license, while themselves misappropriating code to > which no license was ever granted.

Re: [Bacula-users] how to debug a job

2015-01-24 Thread Dmitri Maziuk
On 1/24/2015 9:00 AM, Kern Sibbald wrote: > Bottom line: contrary to what I previously thought there *might* be some > benefits to turning on spooling for disk Volumes, but only if you have > really fast spooling disks (or SSD). This is an interesting topic, and > it would be nice to see some rea

Re: [Bacula-users] how to debug a job

2015-01-23 Thread Dmitri Maziuk
On 1/23/2015 9:03 AM, Josh Fisher wrote: > I use another approach. I define the vchanger to have multiple virtual > drives... So for 10 concurrent jobs there would be 10 virtual > drives and so 10 opened volume files. My way also keeps the config simple stupid: as long as the backups complete on

Re: [Bacula-users] bacula 5.2.16 (slaanesh) anyone?

2014-12-24 Thread Dmitri Maziuk
On 12/24/2014 6:09 PM, Simone Caronni wrote: > The packages work fine, in fact they are almost the same that have been > put into rhel 7. I do not suggest to disable SELinux, you should first > try to set up things as described in the readme and quickstart files in > /use/share/doc/bacula-common/*

Re: [Bacula-users] bacula 5.2.16 (slaanesh) anyone?

2014-12-24 Thread Dmitri Maziuk
OK, scratch that. It turns out I forgot to disable nsalinux -- I though it'd be a reflex action by now but evidently not. Problem solved. Dima -- Dive into the World of Parallel Programming! The Go Parallel Website, spo

Re: [Bacula-users] file table - additional indexes

2014-12-23 Thread Dmitri Maziuk
On 12/23/2014 8:53 AM, Dan Langille wrote: > select * from file where fileindex = 23495 > > It took a long time. > > I added this index: create index file_fileindex on file(fileindex) ... > I am willing to sacrifice that space. I’m also willing to bed that > table updates won’t be affected by muc

Re: [Bacula-users] Dell powerVault 124T tape library

2014-12-04 Thread Dmitri Maziuk
On 12/4/2014 9:33 AM, Ian Lord wrote: > Hi, > > We are looking for a solution to backup freebsd machine with large ZFS > pools (8TB) > ... if I can be safe to purchase a 7000$ library, a new server > running freebsd and that it will work. This is not the kind of things I > have sitting in my lab J

Re: [Bacula-users] current recommendations for SSD spool disk with LTO/Ultrium?

2014-12-03 Thread Dmitri Maziuk
On 12/3/2014 8:23 AM, Josh Fisher wrote: > On 12/3/2014 8:12 AM, Daniel Pocock wrote: >> Can anybody make any practical comments on how to choose a suitable >> spool disk (both speed, size and whether to make an array of disks for >> spooling)? > ... The maximum write speed of LTO-6 is 400 > MB/s,

Re: [Bacula-users] ERR=Permission denied

2014-11-23 Thread Dmitri Maziuk
On 11/22/2014 7:43 PM, Alfons wrote: > Hi, > > My bacula system stopped working ... because some kind of permissions error. Whatever filesystem /home/backup/FileChgr1-Dev1/Daily-0001 is on might be remounted read-only, that happens on some disk/filesystem errors. Dimitri ---

Re: [Bacula-users] Configuration reload for bacula-sd

2014-11-09 Thread Dmitri Maziuk
On 11/9/2014 5:53 AM, Kern Sibbald wrote: > Bacula can only mount one device in any given Device section at a time, > but in an Autochanger (virtual or not) there are multiple Devices and > each can have its own directory. However, if you use different > directories, you must use different Media

Re: [Bacula-users] Configuration reload for bacula-sd

2014-11-08 Thread Dmitri Maziuk
PS. I should probably clarify that bacula has very convenient automatic volume management features that work perfectly well with single-filesystem disk backup. It's a pity bacula's disk backup mechnism is apparently designed so you can have either automatic volume management or multiple disks,

Re: [Bacula-users] Configuration reload for bacula-sd

2014-11-08 Thread Dmitri Maziuk
On 11/8/2014 5:36 AM, Kern Sibbald wrote: > I think so. If I understand correctly, you want disk mount points or > directories to be treated much like a tape drive, so that you can > mount multiple "disks". > > I think this feature is already implemented, with one difference ... > that when the d

Re: [Bacula-users] Configuration reload for bacula-sd

2014-11-07 Thread Dmitri Maziuk
On 11/7/2014 7:10 AM, Kern Sibbald wrote: > Hello, > > I am not sure, but it sounds like you are proposing that Bacula use a > raw device for storing a Volume. This is possible. There might be a > trivial advantage in terms of performance, but there is no real > advantage or demand to do it. The

Re: [Bacula-users] Problem installing bacula on Solaris 10

2014-11-01 Thread Dmitri Maziuk
On 10/31/2014 4:53 PM, Kenneth Garges wrote: > Thanks for the suggestion. I avoided it because everyone in the > office here said stay away from SunStudio, gcc is way better, Solaris > compilers are evil, blah blah. They're incompatible with gnu build chains, especially libtool, so most gnuware

Re: [Bacula-users] automatic purge/delete volumes on full 'File' storage

2014-10-29 Thread Dmitri Maziuk
On 10/28/2014 10:48 PM, Alexei Babich wrote: > Hello everyone. > Tell me, please, how in the bacula possible to automate the process of > automatic removal (or reuse) volumes, and, of course, prune jobs in > database, when storage with 'File' type is completely full? In my case > jobs/volumes reten

Re: [Bacula-users] Configuration reload for bacula-sd

2014-10-28 Thread Dmitri Maziuk
On 10/28/2014 8:24 AM, Alan Brown wrote: ... > Tape and disk are different animals and need to be approached differently. > > Virtual autochangers are a kludge to allow for removable disks but in > most configured installations they do _not_ treat those disks in the > same way as real tape drives.

Re: [Bacula-users] Forcing baccula to purge/recycle a tape instead of appending?!

2014-10-15 Thread Dmitri Maziuk
On 10/15/2014 11:45 AM, Thorsten Reichelt wrote: > Hi! > > I have a problem with my tape pool configuration. > I want to use exactly 12 LTO tapes (one tape per month). > After 12 month the oldest tape shall be reused without appending new data. Other issues aside, you do realise that tape reliabil

Re: [Bacula-users] Round robin to storage servers (disks)

2014-09-19 Thread Dmitri Maziuk
On 9/19/2014 9:15 AM, Hendrik Visage wrote: > Goodday, > > I'm investigating options, and my need is to send back-ups to > separate storage servers in a round robin fashion. Typically only one > of them will be connected at a time. How do you intend to restore stuff? Dimitri -

Re: [Bacula-users] bacula-dir stuck trying to mount the wrong volume

2014-09-07 Thread Dmitri Maziuk
On 9/7/2014 4:33 AM, Kern Sibbald wrote: > It is not a question that I will not document something, why would I > write code and discuss it if I did not want to document it? It *was* a > question that I incorrectly thought it was already documented. > > What some people tend to forget is that I a

Re: [Bacula-users] bacula-dir stuck trying to mount the wrong volume

2014-09-06 Thread Dmitri Maziuk
On 9/6/2014 2:59 PM, Kern Sibbald wrote: ... > perhaps I am overly sensitive I've been dealing with other people's software for a living for close to two decades now and familiarity brings contempt. So yeah, I don't like software -- with very few exceptions, and bacula isn't one of them, I am j

Re: [Bacula-users] bacula-dir stuck trying to mount the wrong volume

2014-09-06 Thread Dmitri Maziuk
On 9/6/2014 3:10 AM, Kern Sibbald wrote: > Can you tell me what my explanation of the disk autochanger was and why > it did not make sense to you? The goal was to write file volumes -- same pool, same backup set, to a set of filesystems (hosted on removable disks). The thread went on a for a co

Re: [Bacula-users] Looking for recommendations on how to backup a Postgresql database using Bacula

2014-08-22 Thread Dmitri Maziuk
On 8/21/2014 9:37 PM, Dan Langille wrote: > When I said .conf, I mean bacula-dir.conf, etc. Keep those files handy, > outside Bacula backups. Ah. There's etckeeper for backing those and any number of ways to copy /etc/.git elsewhere. I've been eyeballing btsync lately, pity it'll probably nev

Re: [Bacula-users] Lets open up a discussion about estimating required space for backups.

2014-08-15 Thread Dmitri Maziuk
On 8/14/2014 7:34 PM, Jeff MacDonald wrote: ... > Is there a good way to plan ahead? If your backup is growing (they always are), you will eventually hit the limits. There are a couple of workarounds: 1. use hot-swappable drives and vchanger. That means manual swapping of drives & re-labeling th

Re: [Bacula-users] New user with Bacula

2014-07-30 Thread Dmitri Maziuk
On 7/30/2014 7:56 AM, Radosław Korzeniewski wrote: > Could you explain what "NetApp Client" is/will be/could be, please. What > do you mean by "NetApp Client". I'd like to understand this thread, but > I'm not an english native speaker so I miss the main point of this thread. It's not your Englis

Re: [Bacula-users] New user with Bacula

2014-07-29 Thread Dmitri Maziuk
On 7/29/2014 2:59 AM, leandro.cu...@reedglobal.com wrote: > > Hi Dimitri, > > Thank you for your return. My requirement is just to keep some snapshots > for a period of 30 days, and once a month an infinity retention job. I expect you'll have to mount netapp volumes someplace and run bacula clien

Re: [Bacula-users] Bacula backup Clusters

2014-05-24 Thread Dmitri Maziuk
On 5/24/2014 1:58 AM, Radosław Korzeniewski wrote: ... > It is the different problem. Yes, bacula could be a more robust > regarding network problems. I wonder how much state you'll to have keep to successfully reconnect. E.g. re-establishing database connection at the start of a backup job shou

Re: [Bacula-users] Bacula backup Clusters

2014-05-23 Thread Dmitri Maziuk
On 5/23/2014 8:35 AM, Radosław Korzeniewski wrote: > My suggestion was a very simple. Do not install/configure another > bacula-fd but simply and clever use existing configuration. In my case > it is a change of 4 parameters and adding a new client definition - your > require a lot more. FWIW I fa