From 8a615636d22f7548dae464d561e02cd17e21f78b Mon Sep 17 00:00:00 2001 From: Andrew Harvey Date: Tue, 17 Aug 2021 15:27:00 +1000 Subject: UNLOGGED tables are lost on machine restart so unsetting it --- Makefile | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Makefile b/Makefile index 202c31e..0192367 100644 --- a/Makefile +++ b/Makefile @@ -85,12 +85,12 @@ dist/vicmap-osm.fgb: dist/vicmap-osm.geojson # useful for development to be able to query a database loadPgAdd: data/vicmap/ll_gda94/sde_shape/whole/VIC/VMADD/layer/address.shp - ogr2ogr -f PostgreSQL PG: $< -lco UNLOGGED=YES -nln vmadd + ogr2ogr -f PostgreSQL PG: $< -nln vmadd # index all columns for faster queries during development psql -f src/createIndexQuery.sql --tuples-only | psql loadPgProp: data/vicmap/ll_gda94/sde_shape/whole/VIC/VMPROP/layer/property_view.shp - ogr2ogr -f PostgreSQL PG: $< -lco UNLOGGED=YES -nln vmprop -nlt MULTIPOLYGON + ogr2ogr -f PostgreSQL PG: $< -nln vmprop -nlt MULTIPOLYGON data/victoria.osm.pbf: wget --no-verbose --directory-prefix=data http://download.openstreetmap.fr/extracts/oceania/australia/victoria.osm.pbf -- cgit v1.2.3