johnniehard

---

title: Setting up PostGIS with Dokku date: 2017-09-22 00:00:00 Z tags:

• GIS
• PostGIS
• Dokku layout: post author: Johnnie Hård subtitle: Note to self on how to set up a PostGIS datbase on a Dokku host.

johnniehard

#!/bin/bash

find $1 -name "*.$2" -print0 | xargs -0 ls >> files.txt

johnniehard

{
  "uuid": "72e679a0-1a59-11ea-b338-d7ffcbd7b692",
  "jobState": "complete",
  "clientUrl": "https://<url-här>",
  "result": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": ["...koordinater"]
    },

johnniehard

const todoMachine = Machine({
    id: 'todoMachine',
    initial: 'fetch',
    context: {
      todos: null
    },
    states: {
        idle: {
            on: {
                FETCH: 'fetch',

johnniehard

events {
	  worker_connections  4096;  ## Default: 1024
}
http {
	server {
			listen 80 default_server;
			listen [::]:80 default_server;

			#root /var/www/html;

johnniehard

	function runTaskList() {
	    //1. task local type-EXPORT_FEATURES awaiting-user-config
	    //2. task local type-EXPORT_IMAGE awaiting-user-config
	    var tasklist = document.getElementsByClassName('awaiting-user-config');
	    for (var i = 0; i < tasklist.length; i++)
	        tasklist[i].children[2].click();
	}
	// confirmAll();
	function confirmAll() {
	    var ok = document.getElementsByClassName('goog-buttonset-default goog-buttonset-action');

johnniehard

import useSketch from ".";

export default function TestSketch() {

    const sketch = useSketch(s => {

        s.setup = () => {
            s.createCanvas(800, 600)
        }

johnniehard

dokku apps:create hasura
dokku domains:add hasura hasura.my.domain.com
dokku postgres:create hasura-db
dokku postgres:link hasura-db hasura
dokku config:set hasura HASURA_GRAPHQL_DATABASE_URL="<info from above command>" HASURA_GRAPHQL_ADMIN_SECRET="blahblah" HASURA_GRAPHQL_ENABLE_CONSOLE="true" 
dokku proxy:ports-set hasura http:80:8080
docker pull hasura/graphql-engine
docker tag hasura/graphql-engine dokku/hasura
dokku tags:deploy hasura
dokku letsencrypt hasura

johnniehard

create table "magnus-etuna".trees as
select fid, center as geom, radius as crownRadius from "magnus-etuna"."tree-polygons", ST_MinimumBoundingRadius(geom) as geom;

johnniehard