INeedMana

Might be! It’s just that having a container like that feels easier than looking after bare-metal secondary db

Maybe I’ll just pg_dump during Nextcloud maintenance window and get into BorgBackup putting the dumps on NAS? If I have to revive the db from the dead, I’ll probably just use the dump anyway, so that’s one hoop less

2nd DB would be on the NAS but its not being used by the app, so as long as it’s asynchronous writes, you should be okay

But then I have to maintain it too. And it will be using RAM that was supposed to only be for servicing RAID. On a platform where RAM can’t grow

For sure my setup will be growing and changing with time. But ATM this “prod” db lives only on laptop’s SSD

replication in the database it self

AFAIK db replication would require running another db on NAS. Which I tried to avoid

I have another cronjob that takes a backup into the first database docker init folder. Older backups end with -date so they won’t get picked up by the init script. You can do similar with just docker.

Yeah, that’s why I’m thinking to do. Have a container that watches changes to db data and rsyncs those into the NAS for safekeeping. My main goal in all of this is so db data won’t die with laptop’s SSD

Oh, that’s interesting! Sounds a bit crazy but I’m interested in what you find out :D

I wonder if in this case VMs don’t make it work better. There is another layer between the process and NFS than pure docker+volume

db running on the Pi with storage on the Pi could be faster than the db running on the laptop with storage on the Pi

I think so too, but I’m mindful of the 1GB RAM per TB rule. I’m afraid to choke the NAS and on Pi I can’t put in more RAM

keep the DB on the most powerful CPU and quickest disk

Thing is, I expect that NAS to be faster than the SSD on the laptop that runs a bunch of stuff. Even NC log file will take up some IO

But I get the point you are all making here, I’m changing course :)

it’s generally not a good plan to put anything that needs realtime access remote to the device processing it

So in your opinion putting whole nextcloud_data as NFS mount is also a bad idea? Keep NFS as external storage and/or only user data?

AIO docker

It was too blackbox to me. I had some issue and found it hard to debug. fpm+nginx is more my speed
This BorgBackup app is available only in AIO?

You can easily just try it out though

Yeah, but if that setup leads to problem in a few months, I won’t catch that. That’s why I decided to ask and judging by the other answer, I dodged a bullet here

Now I’m thinking of setting up something like this. Maybe even in another container? One volume with data bound, one with NFS and a bunch of scripts in entrypoint to rsync(?) between the two on inotifywait. There is lsyncd but it’s been unmaintained for two years now

Ah. So there is a devil in the details here. Thank you :)

back the data dir up to the NAS (or replicate)

Could you please expand on that? You mean DB replication or there is something like NFS replication?

Well, they only say they won’t work on it. But can we keep it alive as community without forking?

I hope Logseq OG will be accepting PRs. I’d hate to go back to Obsidian