User Tools

Site Tools


user:sachy:inf

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
user:sachy:inf [2018/08/03 22:25] – created sachyuser:sachy:inf [2018/08/10 23:11] (current) sachy
Line 30: Line 30:
 create extension postgis; create extension postgis;
 </code> </code>
 +
 +=== Pristup z localhostu s heslem ale bez hesla ===
 +Editovat /etc/postgresql/9.6/main/pg_hba.conf a prepsat opravneni na "trusted", aby heslo neotravovalo.
  
 Uzivatel musi mit nastavene heslo protoze mapnik a jine tooly neumi pristup bez hesla Uzivatel musi mit nastavene heslo protoze mapnik a jine tooly neumi pristup bez hesla
- Kvuli tomu je treba upravit konfigurak na "trusted" z localhostu, aby heslo neotravovalo cloveka. 
  
 ==== postgres v RAM ==== ==== postgres v RAM ====
Line 50: Line 52:
 ==== Import dat ==== ==== Import dat ====
  
 +Import .osm (trva par minut)
 <code> <code>
 osm2pgsql -s -d gis -C 22000 ./czech_republic-2018-08-02.osm osm2pgsql -s -d gis -C 22000 ./czech_republic-2018-08-02.osm
 </code> </code>
  
 +Kontrola ze se nahralo...
 <code> <code>
 psql gis psql gis
Line 88: Line 92:
 ==== TODO ==== ==== TODO ====
  
-Vsechny nastroje (mapnik,...) bud hodi SIGSEGV nebo jinak nefunguji :(+https://gis.stackexchange.com/questions/292464/mapnik-postgresql-python-segmentation-fault 
 + 
 +Vsechny nastroje na vygenerovani mapy (mapnik,...) bud hodi SIGSEGV nebo jinak nefunguji :(
user/sachy/inf.1533335106.txt.gz · Last modified: 2018/08/03 22:25 by sachy