smellman

Append  (cost=4.08..275139.53 rows=16 width=32) (actual time=21.317..26.948 rows=16 loops=1)
   ->  Aggregate  (cost=4.08..4.09 rows=1 width=32) (actual time=21.316..21.317 rows=1 loops=1)
         ->  Append  (cost=0.00..3.95 rows=27 width=3447) (actual time=0.202..11.278 rows=27 loops=1)
               ->  Append  (cost=0.00..3.54 rows=27 width=3447) (actual time=0.202..11.274 rows=27 loops=1)
                     ->  Seq Scan on ne_110m_ocean  (cost=0.00..1.03 rows=2 width=41832) (actual time=0.201..10.175 rows=2 loops=1)
                           Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1'::geometry) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL))
                     ->  Seq Scan on ne_110m_lakes  (cost=0.00..2.38 rows=25 width=376) (actual time=0

smellman

# t-rex configuration

[service.mvt]
viewer = true

[[datasource]]
dbconn = "postgresql://openmaptiles:openmaptiles@postgres/openmaptiles"
name = "dbconn"
default = true

smellman

rails	1.8.7	1.9.2	1.9.3	2.0.0	2.0.0-p648	2.1	2.1.1	2.1.10	2.2	2.2.10	2.2.4	2.2.5	2.2.6	2.2.7	2.2.8	2.3.0	2.3.1	2.3.3	2.3.4	2.3.5	2.3.7	2.4.0	2.4.1	2.4.2	2.4.4	2.5.0	2.5.1	jruby	jruby-19mode	rbx	rbx-19mode	rbx-2	ruby-head
v5.2.2										o											o				o		o						o
v5.2.1.1										o											o				o		o						o
v5.2.1										o											o				o		o						o
v5.2.0															o					o				o		o							o
v5.1.6.1															o					o				o									o
v5.1.6															o					o				o									o
v5.1.5															o					o				o									o
v5.1.4														o					o				o										o

smellman

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQCWosL9txveGDc/4Ulr++5nTMLyiD/imA9UaRMOB11mrqEi4ZhMm1AxCQQLWctFLhAl8J+aUnnP6Dl+mvLbnXWwc5wVsvCt/dSZAgfpN/g9BJHz0W/gT4Rl9Y5GhyxU4xSLj13Wr4RWcLS610v/ZLrIdckbXYSAvA1XyMpBr504ipgzDSp9Z/g/QzwBoFxkRNFTvbt9Udxkodc4CbzKlaCWbDTj62cUHlXrkMD8HDQ5sF1jCdX5FsolTL7N0umQzGY2+SVhu62MeQDo5QHJnRJXSe27YLyMKc9iztTPk4ndYFFSNznltO7XhPwebCIxtHE83B1XUsb9o7VpIiy+DeP9hjLMmP4PVdrCMBNL2LrPGb4ddGECecM8jqWlFk1c7fFMjvHkcCrMuONoEBZA+Y7Au8Jqb0oOhfCGZ9/a24B9tkGJYoR/yrVIwA1y9SirTnr+uDLEd9tsvcFaAlk+K4TbgDNl47tKJSdXT5VKtMuHnA3gnSOvMbczOkrekUprARZT8srLxfv0WfQ1c8sYNEc7Szq0r6qat6VlUc8fu6umCK//qN2hUx4OrW8K3z4CwMJPQ5EVWW+9wEj3PCRIhWpkmbtHyHK1D8HlFTCchi/t+OTHVtrNdWd5WpGls6fCs/RfK9vfnjkC+MTytbpFE56W9rEvSTxcz3Q2yDtv+hcMcw== btm@tech.email.ne.jp

smellman

FROM node:9

RUN npm install -g serve

smellman

listen_addresses = '*'
# Tuning at: https://pgtune.leopard.in.ua/
# DB Version: 9.6
# OS Type: linux
# DB Type: dw
# Total Memory (RAM): 16 GB
# CPUs num: 20
# Connections num: 100
# Hard drive type: ssd

smellman

After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work.
The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."

Database files have to be updated before starting the server, here are the steps that had to be followed:

# first stop force reload by launchctl
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

# need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default
brew unlink postgresql

smellman

smellman

class OutdoorRouting
  include ActiveModel::Model

  attr_reader :result, :source_optional_id, :target_optional_id
  attr_accessor :source_lon, :source_lat, :target_lon, :target_lat, :search_type, :source_name, :target_name
  validates :source_lon, :source_lat, :target_lon, :target_lat, :search_type, presence: true
  def initialize(source_lon, source_lat, target_lon, target_lat, search_type, source_name, target_name, source_optional_id = nil, target_optional_id = nil)
    @source_lon = source_lon
    @source_lat = source_lat
    @target_lon = target_lon

smellman

{
  "version": 8,
  "name": "Dark Matter",
  "metadata": {
    "mapbox:autocomposite": false,
    "mapbox:type": "template",
    "mapbox:groups": {
      "b6371a3f2f5a9932464fa3867530a2e5": {
        "name": "Transportation",
        "collapsed": false