No description, website, or topics provided.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Dockerfile
Dockerfile-rpi
LICENSE
README.md
entry.sh
gost-db-install.sh
gost_init_db.sql Added index for observation id to fix slow v1.0/Observations req Sep 27, 2018
postgresql.conf Improved performance for Inserts and select, now using alpine as base… Sep 13, 2017

README.md

GOST-DB

GOST repository containing database initialization sql script, shell install script and some Docker commands.

GOST schema is by default in schema gost.v1

Testcase: Connect in pgadmin with localhost:5432 postgres/postgres, GOST database should be in gost.v1

SQL script

Run https://github.com/gost/gost-db/blob/master/gost_init_db.sql sql script in a new GOST database, default user/password: postgres/postgres

Shell script - for installation without Docker

Run (gost-db-install.sh) to installl PostgreSQL + PostGIS + GOST database from terminal.

$ wget https://raw.githubusercontent.com/Geodan/gost-db/master/gost-db-install.sh
$ sh gost-db-install.sh

Docker

Public image: [https://hub.docker.com/r/geodan/gost-db/]

Public image Raspberry Pi: [https://hub.docker.com/r/geodan/rpi-gost-db/]

Running GOST database

$ docker run -p 5432:5432 -e POSTGRES_DB=gost geodan/gost-db

Running GOST database on Raspberry Pi

$ docker run -p 5432:5432 -e POSTGRES_DB=gost geodan/rpi-gost-db

Building gost-db image

$ docker build -t geodan/gost-db .
$ docker push geodan/gost-db

Building rpi-gost-db image for Raspberry Pi

$ docker build -f Dockerfile-rpi -t geodan/rpi-gost-db .
$ docker push geodan/rpi-gost-db

Database tuning

The database is tuned in the postgresql.conf files, changes:

shared_buffers -> 512MB (from 128MB)

work_mem -> 16MB (from 1 MB)

synchronous_commit -> off (from 'on')

wal_buffers -> 16MB (from ?)

wal_writer_delay -> 1000ms (from 200 ms)

checkpoint_timeout -> 15min (from 5min)