Tag: postgres

Issues restoring Gitea from dump

Somehow, the official documentation for restoring Gitea from dump did not work for me. Roughly, the following command for the original rootful Docker image could look like this: /app/gitea/gitea dump --file gitea-dump.zip -c /data/gitea/conf/app.ini --skip-lfs-data --skip-reposit…

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…

Accessing Gitea Postgres inside Docker

The gitea issue #5917 discusses how to make multiple users unwatch a repository. It has inspired to write the steps down, as it was not entirely obvious to me. There was a change introduced via PR #5852 released that added an option AUTO_WATCH_NEW_REPOS into the Gitea config file…