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
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
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
Public image: [https://hub.docker.com/r/geodan/gost-db/]
Public image Raspberry Pi: [https://hub.docker.com/r/geodan/rpi-gost-db/]
$ docker run -p 5432:5432 -e POSTGRES_DB=gost geodan/gost-db
$ docker run -p 5432:5432 -e POSTGRES_DB=gost geodan/rpi-gost-db
$ docker build -t geodan/gost-db .
$ docker push geodan/gost-db
$ docker build -f Dockerfile-rpi -t geodan/rpi-gost-db .
$ docker push geodan/rpi-gost-db
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)