New answers tagged postgis
All things considered, I would go with option 2. Dates will be evenly selected on, but I'm going to guess that for a given query only one or two date partitions will be involved. It's a shame you can't cluster on geolocation and partition on date, which would be ideal. Elevation tends to correlate with geolocation anyway, if the bounding boxes are ...
Have you set the environment variables to enable rasters ? As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are disabled by default. In order to re-enable these, you need to set the following environment variables: POSTGIS_GDAL_ENABLED_DRIVERS and POSTGIS_ENABLE_OUTDB_RASTERS in the server environment. If you want to enable offline ...
According to the README included in the dmg file, postgres binaries are installed in '/usr/local/pgsql/bin/' You should add these lines in your ~/.bashrc : export PSQL_DIR=/usr/local/pgsql/bin/ export PATH="$PSQL_DIR:$PATH" Update your environment with 'source ~/.bashrc' or run a new shell and psql should be available.
Top 50 recent answers are included