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

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

[GENERAL] PostGIS Raster - Loading MrSID format

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

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

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?

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

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?

[GENERAL] Error During PostGIS Build From Source on Linux

Hi All, I am working on a Linux OS (Centos 6.5). I built GDAL successfully from source as below: ./configure --prefix=/path/to/gdal make make install Next I built PostgreSQL successfully from source as below: ./configure --prefix=/path/to/pgsql make make install I attempted to configure PostGIS

Re: [GENERAL] Error During PostGIS Build From Source on Linux

17 12:01 PM, Adrian Klaver wrote: > >> On 04/12/2017 10:14 AM, Osahon Oduware wrote: >> >>> Hi All, >>> >>> I am working on a Linux OS (Centos 6.5). I built GDAL successfully from >>> source as below: >>> ./configure --prefix=/path/to/gdal >

Re: [GENERAL] Error During PostGIS Build From Source on Linux

l/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect Please, do you have any idea what I might be doing wrong? On Thu, Apr 13, 2017 at 3:40 AM, Osahon Oduware wrote: > Hi Adrian, > > I will try this and get back to you. Thanks a lot for

Re: [GENERAL] Error During PostGIS Build From Source on Linux

ary postgis-2.3.so <http://postgis-2.3.so>: libproj.so.12: cannot open shared object file: No such file or directory* I would be glad if someone could point me to what I am doing wrong and possible solution. On Thu, Apr 13, 2017 at 3:00 PM, Adrian Klaver wrote: > On 04/13/2017 02:4

Re: [GENERAL] Error During PostGIS Build From Source on Linux

l/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect I will be glad if anyone could help with this. On Apr 13, 2017 18:27, "Adrian Klaver" wrote: On 04/13/2017 07:54 AM, Osahon Oduware wrote: > Hi Adrian, > > Thanks for your help so far. This is th

Fwd: [GENERAL] Error During PostGIS Build From Source on Linux

Noted Something I meant to refer to earlier, it is considered bad etiquette to > cross post to multiple lists. It means in this case I have to remember to > drop the postgis list from my replies as I am not a member of that list and > I get a rejection notice if I forget.

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Hi Adrian, This suggestion helped to resolve the problem. Thanks a lot for your help. On Sat, Apr 15, 2017 at 8:02 PM, Adrian Klaver wrote: > On 04/15/2017 11:25 AM, John R Pierce wrote: > >> On 4/15/2017 10:49 AM, Adrian Klaver wrote: >> >>> >>> Probably going to involve dealing with ldconfig.

[GENERAL] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

Hi All, I have an out-db raster on PostGIS which I tried to load in QGIS (v 2.14.12-Essen) utilizing the DB Manager to establish a connection. I could view the raster table, but when I try to "Add to canvas" it displays a black screen instead of the raster image. I would be glad if someone could

Re: [GENERAL] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

g output: 1,7000 The "Add to canvas" menu is a pop-up that is displayed when you right-click on the raster table from the DB Manager Menu (Database => DB Manager => DB Manager) On Tue, Apr 18, 2017 at 3:03 PM, Adrian Klaver wrote: > On 04/18/2017 06:41 AM, Osahon Oduware w

Re: [GENERAL] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

I forgot to mention that I have put the question on the qgis-user mailing list. Thanks for your help. On Tue, Apr 18, 2017 at 3:31 PM, Osahon Oduware wrote: > Hi Adrian, > > I think it is a problem with QGIS as things seems fine from the PostGIS > end (raster data) going by t

[GENERAL] GDAL OUT-DB RASTER SUPPORT

Hi All, I am getting a black image when I try to display PostGIS out-db rasters. I discovered that it has to do with GDAL support for out-db rasters as stated in the link below for a similar issue (over 1 year back): https://hub.qgis.org/issues/12133 The last comment by Jürgen Fischer states "...

[GENERAL] Build PostgreSQL With XML Support on Linux

Hi All, I successfully built PostgreSQL from source on Linux (Centos 7) using the following: ./configure --prefix=/home/nagispg/local/pgsql --with-libxml --with-libxslt Prior to this I had installed the xml and xslt packages (amongst others) using: yum install libxml2-devel yum install libxslt-de

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

I am using PostgreSQL 9.6.2 On Wed, May 31, 2017 at 2:34 PM, Adrian Klaver wrote: > On 05/31/2017 06:24 AM, Osahon Oduware wrote: > >> Hi All, >> >> I successfully built PostgreSQL from source on Linux (Centos 7) using the >> following: >> > > What ver

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

Hi Tom, Thanks for the response. Yes, I did all of that. On Wed, May 31, 2017 at 2:46 PM, Tom Lane wrote: > Adrian Klaver writes: > > On 05/31/2017 06:24 AM, Osahon Oduware wrote: > >> I successfully built PostgreSQL from source on Linux (Centos 7) using > >> the

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

Hi Tom, Thanks a lot for your response. You made my day! Your thought in the 2nd paragraph of your response (the "make distclean" stuff) was the solution. It was an oversight on my part. Thanks once again. On Wed, May 31, 2017 at 4:49 PM, Tom Lane wrote: > Osahon Oduware write

[GENERAL] PostGIS ST_CreateOverview Function For Non-Public Schema

Hi All, I am trying to utilize the ST_CreateOverview function as described in the following link: https://postgis.net/docs/RT_CreateOverview.html I need to know how to include the schema name for the raster table in the function. It appears the default is the public schema. Please, I need help

[GENERAL] Table Updatable By Trigger Only

Hi All, I have a trigger on a PostGIS table (say table A) that automatically updates another PostGIS table (say table B). Also, users connect to these tables (table A and B) using QGIS. However, I want the updates to table B to be done by the trigger only (i.e. I don't want table B to be updated f

Re: [GENERAL] Table Updatable By Trigger Only

Hi Achilleas, The pg_trigger_depth() function solved the issue. Thanks a lot, you made my day. On Tue, Jun 20, 2017 at 12:58 PM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 20/06/2017 14:43, Osahon Oduware wrote: > > Hi All, > > I have a trigger on a Pos

Re: [GENERAL] Table Updatable By Trigger Only

Hi Tom, Ok, thanks. On Tue, Jun 20, 2017 at 3:21 PM, Tom Lane wrote: > Osahon Oduware writes: > > The pg_trigger_depth() function solved the issue. Thanks a lot, you made > my > > day. > > If you start finding that that gets in your way for other purposes, you >

[GENERAL] Renaming Raster Table

Hi All, I used the raster2pgsql tool to load a raster with overviews into a PostGIS database using the following format: raster2pgsql -s -d -Y -e -I -C -F -M -l 2,4,8,16 /path/to/raster/file | psql -h -U postgres -p 5432 -d Now, *I want to rename the raster table and I would like to know the

Re: [GENERAL] Renaming Raster Table

Hi Adrian, Thanks for your response. I have already loaded the raster, but *I want to rename the raster table and I am asking of how to do this **without affecting the functionality of the raster/overviews*. On Thu, Jul 6, 2017 at 6:27 PM, Adrian Klaver wrote: > On 07/06/2017 08:52 AM, Osa

Re: [GENERAL] Renaming Raster Table

Hi David, Thanks, I have done so. On Thu, Jul 6, 2017 at 5:05 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jul 6, 2017 at 8:52 AM, Osahon Oduware > wrote: > >> Hi All, >> >> I used the raster2pgsql tool to load a raster with overviews

[GENERAL] PostgreSQL COPY Statement Error On Linux

Hi All, I am trying to utilize the "COPY" statement below to copy a .CSV file to a table in a PostgreSQL database.: *COPY .() FROM '\\shared\network\path\to\csv\test.csv' DELIMITER ',' CSV HEADER;* This works with a PostgreSQL database installed in a WINDOWS environment (Windows 7), but fails

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

resql.org] *On Behalf Of *Osahon Oduware > *Sent:* Dienstag, 12. September 2017 12:30 > *To:* pgsql-general@postgresql.org > *Subject:* [GENERAL] PostgreSQL COPY Statement Error On Linux > > > > Hi All, > > I am trying to utilize the "COPY" statement be

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

Hi Francisco, Thanks for your response. I would try this out and give you feedback. On Tue, Sep 12, 2017 at 12:00 PM, Francisco Olarte wrote: > On Tue, Sep 12, 2017 at 12:30 PM, Osahon Oduware > wrote: > > I am trying to utilize the "COPY" statement below to copy a .CSV

[GENERAL] Using Substitution Variables In PostgreSQL

Hi All, I wanted to find out how to use a substitution variable in an SQL statement that would cause the user to be prompted for a value. Something similar to the ampersand (&&) in ORACLE. For example, given the SQL statement below: SELECT ,, FROM WHERE = 35 I want the user to be p

Re: [GENERAL] Using Substitution Variables In PostgreSQL

Thanks for the information. On Mon, Oct 16, 2017 at 3:27 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware > wrote: > >> Hi All, >> >> I wanted to find out how to use a substitution variable in an SQL