Subject: bug#29675: databases should be created with chattr +C

From: Danny Milosavljevic <[email-masked]>
Date: Wed, 13 Dec 2017 15:40:03 +0100

Hi Efraim,

On Tue, 12 Dec 2017 13:46:08 +0200
Efraim Flashner <[email-masked]> 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.