Deploy PostgreSQL server on Raspberry Pi3 (RPI3) via Pantahub

Note:Pantahub is the only place where Linux firmware can be shared and deployed for any device, You can signup @pantahub here:http://www.pantahub.com

Make your RPI3 device ready to deploy PostgreSQL server by following 6 Steps

Step 1: Burn the RPI3 initial stable image into your sd card.

a) Download RPI3 image

Click to download

b) unxz the device image

Run $ unxz rpi3_initial_stable.img.xz

c) Burn image into sd card using Raspberry Pi Imager 1.2

Step 2: Boot your RPI3

a) Insert your sd card and supply the power

Step 3: Singup @pantahub here http://www.pantahub.com

Step 4: Download & Install a CLI tool “pvr”

Note: pvr is a CLI tool which can be used to interact with your device through pantahub platform. Note: Using pvr you can share your firmware and projects as simple as with a git tree: Note: Move the pvr binary to your bin folder after download.

Linux(AMD64): Download Linux(ARM32v6): Download Darwin(AMD64): Download

pvr clone; pvr commit; pvr post

To install from github source code:

$ go get gitlab.com/pantacor/pvr
$ go build -o ~/bin/pvr gitlab.com/pantacor/pvr

Note: You need “GOLANG” to be installed in your system for building pvr from github source code.

Step 5: Detect & Claim your device

a) Connect a LAN cable between your RPI3 & computer/Router.

b) Open your terminal & run $ pvr scan

c) Claim your device

$ pvr claim -c merely-regular-gorilla https://api.pantahub.com:443/devices/5f1b9c44e193a5000afa9901

d) Log into Panthub.com and check whether the newly claimed device appeared in the dashboard or not.

Step 6: Clone the device to your computer using the Clone URL of your device

$ pvr clone https://pvr.pantahub.com/sirinibin/presently_learning_pelican/0 presently_learning_pelican

Now your device is ready to deploy your PostgreSQL app

Deploy your PostgreSQL Server app to the device by following 3 Steps

Step 1: Add “postgresql” app to the device & deploy the change

a) Add “postgresql” app

$ pvr app add postgresql --from=arm32v7/postgres:9.5-alpine --config-json=<(echo -n -e '{
"Env": [
  "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
  "POSTGRES_USER=root",
  "POSTGRES_PASSWORD=123",
  "LANG=en_US.utf8",
  "PGDATA=/var/lib/postgresql/data"
]
}')

b) Deploy the changes

 $ pvr add .
 $ pvr commit
 $ pvr post

Step 2: Access the PostgreSQL Server through Shell

psql -h 10.42.0.231 -U root -P 123

Step 3: Access the PostgreSQL Server through a dashboard app called “adminer”

Adminer is a dashboard app which can be used to visually manage the mysql database

By default Adminer will be server through port 8080

a) Add “adminer” app

pvr app add adminer —from=arm32v7/adminer

b) Deploy the changes

 $ pvr add .
 $ pvr commit
 $ pvr post

c) Access the Adminer dashboard by using http://10.42.0.231:8080/

d) Log into the Adminer dasdhboard by entering the below credentials

 System: PostgreSQL
 Server:10.42.0.231
 Username:root
 Password:123

Now you can easily Create/update/delete postgrSQL databases/tables through Adminer

You are Done!