That is a way of doing it too, but for PostgreSQL 9.4+, I would highly suggest
using the
ALTER SYSTEM approach.
ALTER SYSTEM settings get kept in a file called postgresql.auto.conf and
override whatever same settings are in postgresql.conf
The real benefit I've found with ALTER SYSTEM is that it's easy to keep track
of what settings you changed from default since you can just look at the
postgresql.auto.conf and see.
The other benefit is when upgrade to PostgreSQL 9.5 on another server, I just
copy this file to my 9.5 instance without worrying about all the other
additional things that got added to postgresql.conf in 9.5.
They say you should never edit the postgresql.auto.conf directly, but I tend to
get lazy and just directly type into it and then restart my database service.
>From what I've observed, It's perfectly okay to edit the file directly (as
long as you don't expect comments to be kept) and restart your service, before
making any ALTER SYSTEM calls. Since postgresql loads this file on each startup,
so any ALTER SYSTEM you do after, will start with what got loaded and then write
back all your custom settings back to the file.
Actually I think it might reload the file on each SELECT pg_reload_conf();
call so might actually be safe to just call that too instead of restart the
service.
Hope that helps,
Regina
From: Live-demo [mailto:live-demo-boun...@lists.osgeo.org] On Behalf Of Pieter
du Plooy
Sent: Saturday, January 23, 2016 2:44 PM
To: Brian M Hamlin <mapl...@light42.com>; live-demo@lists.osgeo.org
Subject: Re: [Live-demo] Postgis questions
Hi Brian
In Ubuntu 14.04, set the last part of /etc/postgresql/9.4/main/postgresql.conf
(under the comment
# Add settings for extensions here
as such:
postgis.gdal_enabled_drivers 'ENABLE_ALL'
postgis.enable_outdb_rasters TRUE
restart postgres
In your postgis enabled db, do the following:
select long_name from st_gdaldrivers();
and you will see a lot of gdal enabled drivers
such as:
long_name
--------------------------------------------
Virtual Raster
GeoTIFF
National Imagery Transmission Format
Erdas Imagine Images (.img)
Arc/Info ASCII Grid
DTED Elevation Raster
Portable Network Graphics
JPEG JFIF
Graphics Interchange Format (.gif)
X11 PixMap Format
ILWIS Raster Map
SRTMHGT File Format
JPEG-2000 driver based on OpenJPEG library
FIT Image
JPEG-2000 part 1 (ISO/IEC 15444-1)
OGC Web Map Service
Idrisi Raster A.1
Intergraph Raster
Golden Software ASCII Grid (.grd)
Golden Software Binary Grid (.grd)
Golden Software 7 Binary Grid (.grd)
R Object Data Store
ESRI .hdr Labelled
FARSITE v.4 Landscape File (.lcp)
Azavea Raster Grid format
USGS Optional ASCII DEM (and CDED)
Epsilon wavelets
SAGA GIS Binary Grid (.sdat)
Kml Super Overlay
ASCII Gridded XYZ
HF2/HFZ heightfield raster
Geospatial PDF
WEBP
ZMap Plus Grid
(34 rows)
Regards
Pieter
On Sat, Jan 23, 2016 at 9:01 PM, Brian M Hamlin <mapl...@light42.com
<mailto:mapl...@light42.com> > wrote:
Hi Pieter --
oh, ok.. thats new to me..
according to the PostGIS docs page..
http://postgis.net/docs/postgis_gdal_enabled_drivers.html
those variables can be set at all levels..
cluster-wide -> postgresql.conf
database-persistant -> ALTER DATABASE ...
database-temp, psql session temp -> set ....
also apparently SHELL with bash-style environment vars, as in .bashrc
I would think that all gdal drivers would be enabled by default, and that
really you
need raster out_db set... so I look here
http://postgis.net/docs/postgis_enable_outdb_rasters.html
make sense ?
-Brian
On Sat, 23 Jan 2016 19:51:42 +0200, Pieter du Plooy <pjdupl...@zpanelcp.com
<mailto:pjdupl...@zpanelcp.com> > wrote:
Hi Brian
Thx for the info, but what I really need is where to
postgis.gdal_enabled_drivers = 'ENABLE_ALL'
and postgis.enable_outdb_rasters=1
in Ubuntu 14.04, and system wide
I did it previously in my .bashrc, but for some reason its not
working now.
Pieter
On Sat, Jan 23, 2016 at 6:58 PM, Brian M Hamlin <mapl...@light42.com
<mailto:mapl...@light42.com> > wrote:
Hi Pieter --
I have an a2 build running in a VM.
user@live95a:~$ locate raster.tif <= there is an example file for a QGis
plugin called this
user@live95a:~$ gdalinfo /path/to/raster.tif
hmm non-trivial .. open qgis to let qgis do the work
qgis shows the projection is EPSG:32633
user@live95a:~$ createdb raster_test
user@live95a:~$ psql -c 'create extension postgis' raster_test
user@live95a:~$ psql -c 'select postgis_full_version()' raster_test
yes, RASTER is enabled
use raster2pgsql to load a raster, as per PostGIS raster manual
user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif raster_test |
less
inspect output, yes looks valid
user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif raster_test |
psql raster_test
user@live95a:~$ psql -c '\d raster_test'
note rid, rast columns.. lots of other detail
better command line would name the tables, split into tiles, etc...
hth --Brian
On Sat, 23 Jan 2016 16:45:50 +0200, Pieter du Plooy <pjdupl...@zpanelcp.com
<mailto:pjdupl...@zpanelcp.com> > wrote:
I am struggling to enable postgis gdal drivers and outdb rasters on Ubuntu
(using postgis from the osgeolive nightly, so its for trusty.
How do I go about enabling them in Ubuntu Trusty?
I have tried setting it in .profile, as well as .bashrc systemwide etc..., but
no luck.
Any help?
Regards
Pieter
_____
_______________________________________________
Live-demo mailing list
Live-demo@lists.osgeo.org <mailto:Live-demo@lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/live-demo
<http://../hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Flive-demo>
http://live.osgeo.org
<http://../hwebmail/services/go.php?url=http%3A%2F%2Flive.osgeo.org>
http://wiki.osgeo.org/wiki/Live_GIS_Disc
<http://../hwebmail/services/go.php?url=http%3A%2F%2Fwiki.osgeo.org%2Fwiki%2FLive_GIS_Disc>
--
Brian M Hamlin
OSGeo California Chapter
blog.light42.com <http://blog.light42.com>
--
Brian M Hamlin
OSGeo California Chapter
blog.light42.com <http://blog.light42.com>
_______________________________________________
Live-demo mailing list
Live-demo@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc
