Step 5 (update): Installing PostgreSQL on my Raspberry Pi 1 and 2

Update on 25/Jun/2015
We have added the links to the compiled deb packages.
Skip to this section if you only want to download and install them.

This article is an updated version of our previous post where we explained how to install PostgreSQL on the Raspberry Pi.

Continue reading

Benchmark results of PostgreSQL on Raspberry PI

In step 5, we have installed PostgreSQL. We then performed some benchmarks, by following tips and tricks contained in the world famous book about “PostgreSQL High Performance” by our dear Gregory Smith.

Results will be now presented, to test the efficiency of a PostgreSQL database server installed on a Raspberry PI. This represents a good challenge: build up a database server in a cheap way! Let’s not forget our goal: be able to adopt Postgres in schools so that the SQL language can be taught!

Continue reading

Step 4: configuring Linux on my Raspberry PI

Once the Raspbian image is written on the SD disk, it can be inserted into the Raspberry PI SD port. Just connect the power supply and Raspberry PI will boot for the first time. On the HDMI display, login and password will be required: the Raspbian image has already defined an user named “pi” (having password “raspberry”) with root privileges. A step by step configuration tool will be shown for the first time (where you can set minimal configurations like machine name, etc.). Following boots will require login and password only.

Continue reading