Installing things is difficult! But, it does not need to be.
Tobias and me (mostly just Tobias) have already made this easy for you.
This is a Docker Starter Pack thingy to help you up a PostGreSQL Database on your Raspberry Pi within seconds.
Note, this assumes that you have a gentle grasp of what Docker Compose and Containerization are, so stay put for the rodeo!
- Install Docker and Docker Compose on the Raspberry Pi
- Clone the repo which contains the Compose file
git clone https://github.com/CT83/Raspberry-Pi-PostGres-Docker-Compose.git
- Checkout the postgresql.conf, and configure
listen_addressesaccordingly. By default, the container will be open to all users on the port 5432.
Up the container.
sudo docker-compose up --build -d
The container is at :5432 with password password@7979. You can change this in the docker-compose.yml.
Now, you can treat this like a full fledged PostGres server and do your PG-Admin Stuff. 😇
The PostGres Server can be accessed by any device on the network!
Use this to build a truly decentralized off-site infrastructure where each container runs on a separate low powered Raspberry Pi Zero, maybe?