GNU bug report logs - #29675
databases should be created with chattr +C

Previous Next

Package: guix;

Reported by: Efraim Flashner <efraim <at> flashner.co.il>

Date: Tue, 12 Dec 2017 11:47:02 UTC

Severity: normal

Tags: notabug

Done: ludo <at> gnu.org (Ludovic Courtès)

Bug is archived. No further changes may be made.

Full log

Message #11 received at 29675 <at> debbugs.gnu.org (full text, mbox):

From: Danny Milosavljevic <dannym <at> scratchpost.org>
To: Efraim Flashner <efraim <at> flashner.co.il>
Cc: 29675 <at> debbugs.gnu.org
Subject: Re: bug#29675: databases should be created with chattr +C
Date: Wed, 13 Dec 2017 15:40:03 +0100

Hi Efraim,

On Tue, 12 Dec 2017 13:46:08 +0200
Efraim Flashner <efraim <at> flashner.co.il> wrote:

> We support running GuixSD on top of btrfs, and the prevailing wisdom is
> to mark databases (sqlite, postgresql, etc.) as 'chattr +C', that is, as
> not copy-on-write. It is honored under ext4, but it shouldn't cause any
> changes.

It sounds reasonable to do that - but I don't think that relational databases are managed by the Guix store.  Rather they are in /var or in the home directory.  Long story short, it would make sense for Postgres and Sqlite upstream to do the chattr +C, if they don't already do it.
This bug report was last modified 7 years and 156 days ago.

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.