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
Release: 14.04
Codename: trusty

$ 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

  deb-packages:   

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
     /etc/apt/sources.list.d/pgdg.list :   

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
psql (9.4beta3)
Type “help” for help.

(Visited 2,671 times, 1 visits today)
adminTips
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...

Do you want to be notified about new DBA updates, releases, jobs and free tips? Join our email newsletter. It's fast and easy. You will be among the first to know about hot new DBA updates and stuff, it will help you enhance your DBA skills.
We take your privacy very seriously