Re: [HACKERS] PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Osahon Oduware
Hi Robert, Thanks, I have done so and the issue has been resolved. On Tue, Apr 11, 2017 at 2:56 PM, Robert Haas wrote: > On Mon, Apr 10, 2017 at 10:51 PM, Osahon Oduware > wrote: > > I created an out-db raster using the following syntax: > > > > raster2pgsql -s {srid

[HACKERS] Build PostGIS In Windows Using --with-gdalconfig=FILE

2017-04-11 Thread Osahon Oduware
Hi, I am using Windows 7 OS and I have installed a GDAL with support for MrSID format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to point to this new GDAL. How do I accomplish this in a Windows OS?

[HACKERS] Build PostGIS With GDAL-config-file in Windows

2017-04-11 Thread Osahon Oduware
Hi, I am using Windows 7 OS and I have installed a GDAL with support for MrSID format. I want to build my PostGIS with the GDAL-config-file to point to this new GDAL. How do I accomplish this in a Windows OS?

[HACKERS] PostGIS Raster - Loading MrSID format

2017-04-10 Thread Osahon Oduware
Hi, I am trying to use the raster2pgsql tool to import raster images in MrSID format to PostGIS database on a Windows system. However, I get an error indicating that the format is not supported which I could confirm by running: raster2pgsql -G Please, could someone help with the basic steps to fo

[HACKERS] PostGIS Out-DB Raster Not Behaving As Expected

2017-04-10 Thread Osahon Oduware
Hi All, I created an out-db raster using the following syntax: raster2pgsql -s {srid} -c -R -I -C -F -t auto {absolute_file_path} public.{table} | psql -h {host} -p {port} -d {database} -U {user} The table was created successfully. I wanted to confirm that the actual file is being read from the

Re: [HACKERS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions

2017-03-17 Thread Osahon Oduware
ere is no way for any > application to bypass PostgreSQL's internal security model. > > On Fri, Mar 17, 2017 at 11:43 AM, Osahon Oduware > wrote: > >> Hi Giuseppe, >> >> Thanks for the response. I have provided the GRANTS and other PostgreS

Re: [HACKERS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions

2017-03-17 Thread Osahon Oduware
why these privileges are working when tested in pgAdmin/pgsql, but not in QGIS with the same user/schema/table/database. On Fri, Mar 17, 2017 at 4:16 PM, Giuseppe Broccolo < giuseppe.brocc...@2ndquadrant.it> wrote: > Hi Osahon, > > 2017-03-17 15:54 GMT+01:00 Osahon Oduware : > >&g

[HACKERS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions

2017-03-17 Thread Osahon Oduware
Hi All, I created a "Read-only" User in PostgreSQL via a Role with "SELECT" ONLY privilege on all tables in a schema as shown below: GRANT SELECT ON ALL TABLES IN SCHEMA [schema_name] TO [role_name] GRANT [role_name] TO [user_name] Next, I test this by trying to UPDATE a column in a table (same