[raster]: postgis.gdal_datapath not working (windows 9.4 64-bit)

[robe]

I thought I had tried this on lower before but perhaps not. I very well might be doing something really stupid.

I tried doing this:

ALTER DATABASE testpostgis22
  SET postgis.gdal_datapath = 'C:/ming64gcc48/projects/postgresql/rel/pg9.4w64gcc48edb/gdal-data';

Which is where I think my path is and it seems to just ignore it. Get the GDAL Data not found error. Tried also setting at session level and doesn't seem to do anything.

So back to setting in my batch script:

@SET GDAL_DATA=%~dp0\gdal-data

I'll check my 9.3.

The other GUC variables work fine even with using the new ALTER SYSTEM feature. So doesn't seem to be anything wrong with the GUC machinery.

ALTER SYSTEM SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';

If you are not seeing an issue, I'll confirm to make sure I didn't make any typos or it's not the direction of / which is different when I set in batch script.

[dustymugs]

Does this work in 9.3? I haven't tested 9.4 yet. Oh… debug? I think there are debug output.

[robe]

That's what I was going to try next. It's quite possible I never tried that variable since I have the GDAL_DATA embedded in my batch scripts.

I thought it is supposed to override the environment variable. Even if I have the postgis.gdal_datapath GUC set, as long as I have my GDAL_DATA variable set, it works fine.

[dustymugs]

robe, is this still valid?

[robe]

Yes. I think for now I just can't rely on the postgresql gdal_path GUC for windows for the data path setting. Which is fine. The others seem to work fine which is more important.

People will have issue anyway using raster2pgsql if they don't have a gdal_data path set so I think I still need to set it in the installer using env.

[pramsey]

I've attempted to address the GUC redefinition problem in r14680

[strk]

Does not fix #3429 (not sure it was intended to)