From mboxrd@z Thu Jan  1 00:00:00 1970
From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=)
Subject: bug#29675: databases should be created with chattr +C
Date: Wed, 20 Dec 2017 14:12:39 +0100
Message-ID: <87efnpy248.fsf@gnu.org>
References: <20171212114608.GB1873@macbook41>
	<20171213154003.29024f01@scratchpost.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:47323)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1eReBG-0001D6-4A
	for bug-guix@gnu.org; Wed, 20 Dec 2017 08:13:06 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1eReBB-0005XU-Vg
	for bug-guix@gnu.org; Wed, 20 Dec 2017 08:13:06 -0500
Received: from debbugs.gnu.org ([208.118.235.43]:34580)
	by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <Debian-debbugs@debbugs.gnu.org>)
	id 1eReBB-0005XH-Rv
	for bug-guix@gnu.org; Wed, 20 Dec 2017 08:13:01 -0500
Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1eReBB-00054v-MI
	for bug-guix@gnu.org; Wed, 20 Dec 2017 08:13:01 -0500
Sender: "Debbugs-submit" <debbugs-submit-bounces@debbugs.gnu.org>
Resent-Message-ID: <handler.29675.B29675.151377556419497@debbugs.gnu.org>
In-Reply-To: <20171213154003.29024f01@scratchpost.org> (Danny Milosavljevic's
	message of "Wed, 13 Dec 2017 15:40:03 +0100")
List-Id: Bug reports for GNU Guix <bug-guix.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/bug-guix>,
	<mailto:bug-guix-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/bug-guix/>
List-Post: <mailto:bug-guix@gnu.org>
List-Help: <mailto:bug-guix-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/bug-guix>,
	<mailto:bug-guix-request@gnu.org?subject=subscribe>
Errors-To: bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org
Sender: "bug-Guix" <bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org>
To: Danny Milosavljevic <dannym@scratchpost.org>
Cc: 29675@debbugs.gnu.org

Hello,

Danny Milosavljevic <dannym@scratchpost.org> skribis:

> On Tue, 12 Dec 2017 13:46:08 +0200
> Efraim Flashner <efraim@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 datab=
ases 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.

I agree.

Efraim, unless we have a specific example, I=E2=80=99m inclined to close it=
 as
=E2=80=9Cnot-a-bug=E2=80=9D, with the understanding that it=E2=80=99s an up=
stream issue rather
than something GuixSD-specific.

How does that sound?

Ludo=E2=80=99.