
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
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!