Coding with Titans

so breaking things happens constantly, but never on purpose

Secure access to PostgreSQL on Raspberry Pi

First time this month I thought about doing something right. It’s the end of the year and what about creation of really secured environment for my PostgreSQL database on a Raspberry Pi, that I could expose publicly. What could go wrong here :) ? The goals were clear: Setup a dedicated low-privileged system user, so I could proxy to the database over SSH. Create a new low-privileged PostgreSQL user, so it can access own database only (or ones created in the future). Read more →

HowTo migrate PostgreSQL 9.6 to 11.5

Recently I have created a post on how to upgrade OS on Raspberry Pi. It worked pretty well until I figured out there is something wired with my PostgreSQL installation. And it turned out I ended up with two instances installed one next to the other. So I had the 9.6 version running with my existing databases and as well a cluster for version 11.5. Let me try then to rephrase the other guide, I found here, explaining, how to upgrade PostgreSQL to latest and migrate the databases. Read more →