How to install PostgreSQL 9.4 on Raspberry Pi, Radxa or other similarmicrocomputers running Lubuntu
I know it’s a bit absurd, but sometimes you may have such tasks, where the application is one of microcomputers the best options.
All in my possession were three microcomputer: Radxa, Cubieboard A20 and the Raspberry Pi. As a guinea was selected Radxa. It has a 4-core ARM Cortex-A9, 2GB of RAM, 8GB and PROM Integrated Wi-Fi module. Raspberry Pi of course also possible use, but it is for my problems did not come on
performance. Cubieboard A20 weaker Radxa, but his main advantage is the availability of the SATA controller on board.
All microcomputers installed Ubuntu Server 14.04 (Linaro processor ARM):
$ Lsb_release -a
No LSB modules are available.
Distributor ID: Linaro
Description: Linaro 14.04
$ Uname -a
Linux radxa 3.0.36+ # 7 SMP PREEMPT Wed Aug 20 10:35:50 CST 2014 armv7l armv7l armv7l GNU / Linux
So here we go:
1. Create a file /etc/apt/sources.list.d/pgdg.list and add to it the following repository:
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main 9.4
deb-src http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main 9.4
If you have another version of the distribution, replace trusty the name of your distribution.
2. Add a new key for apt:
wget –quiet -O – http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add –
3. Update the list of packages:
sudo aptitude update
4. Set the dependencies for PostgreSQL 9.4:
sudo apt-get install fakeroot
sudo apt-get build-dep postgresql-9.4
5. Download and collect PostgreSQL 9.4 from source. Attention,
( do not perform these commands as root from ):
cd / tmp
apt-get source –compile postgresql-9.4
The build process for Radxa took about an hour and during work went unnoticed. On Raspberry Pi, better run such commands before bedtime. After a successful build, you will get 16 deb-packages.
6. Create a local repository and transferred to him
sudo mkdir / var / local / repository
sudo mv * .deb / var / local / repository /
cd / var / local / repository
sudo dpkg-scanpackages ./ & gt; Packages & amp; & amp; gzip -f Packages
7. Add a local repository in
deb [trusted = yes] file: /// var / local / repository ./
8. Update the list of available packages:
sudo aptitude update
9. Now we can install PostgreSQL 9.4:
sudo aptitude install postgresql-9.4
10. Check the operation:
afedorov @ radxa: ~ $ sudo su – postgres
postgres @ radxa: ~ $ psql
Type “help” for help.