On Tue, Jan 24, 2017 at 1:32 PM, Martin Kersten
Never simply stop the server using e.g. a kill command.!!
Is MonetDB intended to survive a power failure, system crash, OOM condition, or other event which causes all database processes to terminate? (The existence of the "wal" implies the answer is yes) If so, then you could use a low-level atomic snapshot mechanism (LVM, zfs, btrfs support this) and then use rsync to copy the snapshot. After restoring the backup it will appear as if MonetDB simply crashed and should be able to recover from that. rsync against a running database is highly unsafe because it copies different files at different times, but an OS-level snapshot will see a consistent version of all files in the dbfarm. -s