Tag: docker

Cleaning mastodon media attachments

Being too occupied with the work for previous two months left me with absolutely no time for server maintenance. Especially the kind of maintenance that needs some thought or research before being being done properly. One of the things that got neglected this way is the VPS free …

Fighting Docker iptables on Arch

A strange issue I could not find a meaningful explanation anywhere regarding running docker-compose script and iptables firewall on Arch Linux. Steps to reproduce assume bare iptables, Docker and docker-compose available. Step 1. Start Docker Start the docker.service via systemct…

Install Nextcloud with OnlyOffice and Postgres

In the previous short article about installing Nextcloud I did not provide much details, apart from port configuration (that might even be needed depending on other factors). The setup I chose just worked. However, I too found the basic SQLite database performance a little bit la…

Enable query stats in Mastodon with postgres

Clicking pghero under Mastodon Administration menu, the interface shows the Query stats must be enabled for slow queries orange warning, in the interface that looks like this: After clicking the blue Enable button, instead of a success, the error The database user does not have…

Running Mastodon with docker-compose

A minimal set of commands I had to do to successfully run Mastodon via docker-compose on the VPS. Many OS specific configurations are omitted, as I decided to use Arch on this VPS as well, which is not what most people choose for their server environment, at least not when caveat…