[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

[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

[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] 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?

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

> > > On 04/12/2017 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: >>> ./confi

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 <osahon@gmail.com> wrote: > Hi Adrian, > > I will try this and get

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

te: > On 04/13/2017 02:46 AM, Osahon Oduware wrote: > >> Hi Adrian, >> >> I followed the step you provided and the installation was successful. >> However, I created a test database and when I try to create a postgis >> extension in the test database using: >

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

[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] 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" <adrian.kla...@aklaver.com> wrote: On 04/13/2017 07:54 AM, Osahon Oduware wrote: > Hi Adrian, > > Thanks for your help so far. This

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 <adrian.kla...@aklaver.com> wrote: > On 04/

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] 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 <osahon@gmail.com> wrote: > Hi Adrian, > > I think it is a problem with QGIS as things seems fine from the PostGIS > end (

[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

wrote: > On 07/06/2017 08:52 AM, Osahon Oduware wrote: > >> 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/r

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 <osahon@gmail.com> > wrote: > >> Hi All, >> >> I used the raster2pgs

[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

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 <t...@sss.pgh.pa.us> wrote: > Osahon Oduware <osahon@gmail.com> writes: > > The pg_trigger_depth() function solved the issue. Thanks a lot, you made > my > > day. > > If you start finding

[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

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 <t...@sss.pgh.pa.us> wrote:

[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

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 <adrian.kla...@aklaver.com> 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 >> follow

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 <t...@sss.pgh.pa.us> wrote: > Adrian Klaver <adrian.kla...@aklaver.com> writes: > > On 05/31/2017 06:24 AM, Osahon Oduware wrote: > >> I successfully built PostgreSQ

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 <osahon@gmail.com> > wrote: > >> Hi All, >> >> I wanted to find out how to use a subst

[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

[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

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

stgresql.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 <fola...@peoplecall.com> wrote: > On Tue, Sep 12, 2017 at 12:30 PM, Osahon Oduware <osahon@gmail.com> > wrote: > > I am try