* bug#29675: databases should be created with chattr +C
@ 2017-12-12 11:46 Efraim Flashner
2017-12-13 8:50 ` Rutger Helling
2017-12-13 14:40 ` Danny Milosavljevic
0 siblings, 2 replies; 5+ messages in thread
From: Efraim Flashner @ 2017-12-12 11:46 UTC (permalink / raw)
To: 29675
[-- Attachment #1: Type: text/plain, Size: 443 bytes --]
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.
--
Efraim Flashner <efraim@flashner.co.il> אפרים פלשנר
GPG key = A28B F40C 3E55 1372 662D 14F7 41AA E7DC CA3D 8351
Confidentiality cannot be guaranteed on emails sent or received unencrypted
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 833 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* bug#29675: databases should be created with chattr +C
2017-12-12 11:46 bug#29675: databases should be created with chattr +C Efraim Flashner
@ 2017-12-13 8:50 ` Rutger Helling
2017-12-13 14:40 ` Danny Milosavljevic
1 sibling, 0 replies; 5+ messages in thread
From: Rutger Helling @ 2017-12-13 8:50 UTC (permalink / raw)
To: 29675
This should also be done with virtual machine images.
^ permalink raw reply [flat|nested] 5+ messages in thread
* bug#29675: databases should be created with chattr +C
2017-12-12 11:46 bug#29675: databases should be created with chattr +C Efraim Flashner
2017-12-13 8:50 ` Rutger Helling
@ 2017-12-13 14:40 ` Danny Milosavljevic
2017-12-20 13:12 ` Ludovic Courtès
1 sibling, 1 reply; 5+ messages in thread
From: Danny Milosavljevic @ 2017-12-13 14:40 UTC (permalink / raw)
To: Efraim Flashner; +Cc: 29675
Hi Efraim,
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 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.
^ permalink raw reply [flat|nested] 5+ messages in thread
* bug#29675: databases should be created with chattr +C
2017-12-13 14:40 ` Danny Milosavljevic
@ 2017-12-20 13:12 ` Ludovic Courtès
2017-12-20 13:31 ` Efraim Flashner
0 siblings, 1 reply; 5+ messages in thread
From: Ludovic Courtès @ 2017-12-20 13:12 UTC (permalink / raw)
To: Danny Milosavljevic; +Cc: 29675
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 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.
I agree.
Efraim, unless we have a specific example, I’m inclined to close it as
“not-a-bug”, with the understanding that it’s an upstream issue rather
than something GuixSD-specific.
How does that sound?
Ludo’.
^ permalink raw reply [flat|nested] 5+ messages in thread
* bug#29675: databases should be created with chattr +C
2017-12-20 13:12 ` Ludovic Courtès
@ 2017-12-20 13:31 ` Efraim Flashner
0 siblings, 0 replies; 5+ messages in thread
From: Efraim Flashner @ 2017-12-20 13:31 UTC (permalink / raw)
To: Ludovic Courtès; +Cc: 29675
[-- Attachment #1: Type: text/plain, Size: 1575 bytes --]
On Wed, Dec 20, 2017 at 02:12:39PM +0100, Ludovic Courtès wrote:
> 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 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.
>
> I agree.
>
> Efraim, unless we have a specific example, I’m inclined to close it as
> “not-a-bug”, with the understanding that it’s an upstream issue rather
> than something GuixSD-specific.
>
> How does that sound?
>
> Ludo’.
My intention was that after creating the database in /var that it should
get 'chattr +C file', but it actually looks like people are divided
between less fragmentation from not CoW for the database or more
recovery options from having it CoW and the checksumming, so closing it
and leaving it alone for now seems best.
--
Efraim Flashner <efraim@flashner.co.il> אפרים פלשנר
GPG key = A28B F40C 3E55 1372 662D 14F7 41AA E7DC CA3D 8351
Confidentiality cannot be guaranteed on emails sent or received unencrypted
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 833 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2017-12-20 13:32 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2017-12-12 11:46 bug#29675: databases should be created with chattr +C Efraim Flashner
2017-12-13 8:50 ` Rutger Helling
2017-12-13 14:40 ` Danny Milosavljevic
2017-12-20 13:12 ` Ludovic Courtès
2017-12-20 13:31 ` Efraim Flashner
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/guix.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).