waleee-cl has quit [Quit: Connection closed for inactivity]
drakonis has quit [Read error: Connection reset by peer]
drakonis_ has joined #nixos-chat
drakonis has joined #nixos-chat
drakonis_ has quit [Ping timeout: 276 seconds]
drakonis has quit [Ping timeout: 250 seconds]
drakonis_ has joined #nixos-chat
drakonis has joined #nixos-chat
drakonis__ has joined #nixos-chat
drakonis_ has quit [Ping timeout: 265 seconds]
<ashkitten>
i wonder if i could write systemd units that get run before and after the zfs auto snapshot service to lock and unlock the postgresql database for mastodon
<ashkitten>
i guess honestly just shutting down the postgresql server temporarily would be more effective
<ashkitten>
or yk, just dumping the db to a file...
<ashkitten>
lol
<ashkitten>
think smarter, ash
{^_^} has quit [Remote host closed the connection]
endformationage has quit [Ping timeout: 240 seconds]
<clever>
ashkitten: zfs snapshots are syscall level atomic, and the order of syscalls is preserved
<clever>
sphalerite: so postgresql should behave as-if it was an improper shutdown, between 2 write syscalls, and it will probably do a tiny internal rollback, of whatever was partially written
<clever>
if you attempt to restore a snapshot
<sphalerite>
me?
drakonis__ has quit [Quit: Leaving]
cjpbirkbeck has joined #nixos-chat
cjpbirkbeck has quit [Quit: Quitting now.]
cjpbirkbeck has joined #nixos-chat
clever has quit [Ping timeout: 240 seconds]
cjpbirkbeck has quit [Quit: Quitting now.]
szyk has joined #nixos-chat
szyk has left #nixos-chat [#nixos-chat]
endformationage has joined #nixos-chat
<ashkitten>
oh huh
<ashkitten>
clever++
<ashkitten>
oh, they're not here
__monty__ has joined #nixos-chat
drakonis_ has joined #nixos-chat
drakonis has quit [Ping timeout: 240 seconds]
drakonis_ has quit [Read error: Connection reset by peer]
drakonis_ has joined #nixos-chat
<ashkitten>
has anyone tried to set up zfs backups to backblaze b2 or other s3 compatible object stores?