What is your struggle with db updates? Databasus makes it so trivial for me personally.
Comment on Heaper, new tools to organize docs, photos [YouTube]
Prunebutt@slrpnk.net 2 days ago
Postgres? Sorry. If it needs a database, it’s probably not for me. Can’t be asked to keep another database backed up.
Mora@pawb.social 2 days ago
Prunebutt@slrpnk.net 2 days ago
The fact that I have to use a more complicated tool that
cd.totally_human_emdash_user@piefed.blahaj.zone 2 days ago
The fact that I have to use a more complicated tool than
cd.But how does changing the current directory backup your files???
Prunebutt@slrpnk.net 2 days ago
Sorry, meant
cp.
WhyJiffie@sh.itjust.works 16 hours ago
almost every self hosted service needs a database. and what “another” database? are you keeping separate postgreses for each service that wants to use it? one of the most important features of postgres is that it as a single database server can hold multiple databases, with permissions and whatnot
u_tamtam@programming.dev 15 hours ago
From previous interactions in this community, it seems all but obvious nowadays, when peoples’ experience with sysadmin in average amounts to running scripts running docker in some form.
WhyJiffie@sh.itjust.works 9 hours ago
just to be clear, are you saying that most beginners just copy paste the example docker compose from the project documentation, and leave it that way?
I guess that’s understandable. we should have more starter resources that explain things like this. how would they know, not everyone goes in with curiosity to look up how certain components are supposed to be ran
u_tamtam@programming.dev 7 hours ago
Essentially, yes: nowadays you can go much further without basic understanding of what’s going on. The ability to fire up magic black boxes that are somewhat functional without any configuration or understanding required is liberating at first, so it’s perfectly understandable. I don’t think it’s a panacea, though.
Prunebutt@slrpnk.net 10 hours ago
Most selfhosting services employ a database in their own docker (separate) container.
WhyJiffie@sh.itjust.works 9 hours ago
oh, I see what you mean!
they do that for the sake of providing an example that works instantly. but on the long term it’s not a good idea. if you intend to keep using a service, you are better off connecting it to a postgres db that’s shared across all services. once you get used to it, you’ll do that even for those services that you are just quicly trying out.
how I do this is I have a separate docker compose that runs a postgres and a mariadb. and these are attached to such a docker network, which is created once with a command, rather than in a compose file. every compose file where the databases are needed, this network is specified as an “external” network. this way containers across separate compose files can communicate.
my advice is its best to also have this network as “internal” too, which is a weird name but gist is, this network in itself won’t provide access to your LAN or the internet, while other networks may still do that if you want.
basically setup is a simple command like “docker network create something something”, and then like 3 lines in each compose file. you would also need to transfer the data from the separate postgreses to a central one, but thats a one time process.
let me know if you are interested, and I’ll help with commands and what you need. I don’t mind it either if you only get around to this months later, it’s fine! just reply or send a message
Prunebutt@slrpnk.net 8 hours ago
That’s a nice offer. But I’m using nixos containers to top it all off. I’m sure it’s possible to have a master-db on the core os and the containers access the central db… but I have hardly any time to do the stuff, I’m reasonably competent in as it is. Managing nixos containers and learning how to coneect the databases for using postgres in the intended way… idk. 😅