Skip to content

Self-hosting

Automatically upgrading PostgreSQL container with pgautoupgrade

The MariaDB container image has an upgrade option which will automatically upgrade system tables when switching to a newer version. The PostgreSQL container image has no such option. The reason is that it is a bit more involved to do so. The pg_upgrade binary needs the binaries of the previous (current) version and the next version.

There are several options to accomplish this task. One is to dump and restore the data via pg_dumpall. However, doing this in production can lead to a long downtime depending on the size of the databases.

There are some additional container images that can help with this doing an in-place upgrade:

Backup your database first

Before doing anything, it is crucial to backup your databases first so you can restore if anything goes wrong.

I tried them both and found pgautoupgrade to be the easiest.

Notes on traefik v2, Nextcloud, etc

Now that the Raspberry Pi is set up and Docker ready to be used, Gitea is running nicely. However, without TLS and just accessible by the IP address and port. So before setting up Nextcloud, I wanted to get a reverse proxy ready that also takes care of TLS termination. I use traefik which supports/integrates with Docker. Here I document how I configured it to put all my services (this includes Pi-Hole and my router's web interface) behind the reverse proxy with TLS.

At the end, I'll briefly note how Nextcloud is set up.

Migrating Data to Nextcloud

If you need to migrate your data to Nextcloud you probably don't want to upload all your files through the web interface.

I suggest to first try the below instructions with a small amount of data (for example, one folder) to verify that it works. Since Nextcloud runs as a container in my case some of the commands are specific to that, but if you don't you can just use the main command that is executed.

As previously noted, my data was "in the cloud" (encrypted at rest) so not already on an external drive (besides my backup of course). In general, although it depends on the size of your data, I therefore suggest to copy the data on to an external drive instead of copying it over the network from your machine to your server. Unless the server is not physically accessible of course (such as a virtual server somewhere). Even then, you can use the same procedure I used.