headers
Volkmar Herbst | 1 Feb 08:05
Picon
Picon

Re: Installation of PL/R: Updata

Thanks for the info- good to know. Also for me the PostGis in action book was the start- very well written and of great practical use.

Good luck with your project.

Volkmar

 

Von: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] Im Auftrag von Darrel Maddy
Gesendet: Dienstag, 31. Januar 2012 21:30
An: PostGIS Users Discussion
Betreff: Re: [postgis-users] Installation of PL/R: Updata

 

Dear Volkmar,

 

I contacted the author (Joe Conway) of the PL/R package and he confirmed that the dll had not yet been compiled for PG9.1.2 – clearly being a decent chap he quickly produced a dll for me which I am glad to report works as intended (I think he will do a little more testing before releasing it into the wild) – sometime the open source community make me glad to be alive! J.

 

Thumbs up also for Regina/Leo and the PostGIS in action book, Ch10 had me using PL/R in no time – so now I only have to learn postgresql, postgis and R  - sounds like some fun days ahead. No doubt I’ll be back…

 

Darrel

 

 

 

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Volkmar Herbst
Sent: 30 January 2012 07:18
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Installation of PL/R

 

HI,

I did install R several times and run also often into this issue. Try the 32bit  one and set the path C:\Program Files\R\R-2.13.1\bin\i386  in your environment. Create new variable R_HOME  value->C:\Program Files\R\R-2.13.1 Make sure that plr.dll is in C:\Program Files (x86)\PostgreSQL\9.0\lib. Restart postgres after that. If you receive errors check if you did not install it already by using plr_environ() in postgres. These are the few things I can think of. May be you have already tried them all..

Volkmar

 

Von: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] Im Auftrag von Darrel Maddy
Gesendet: Samstag, 28. Januar 2012 18:45
An: postgis-users <at> postgis.refractions.net
Betreff: [postgis-users] Installation of PL/R

 

Apologies if this is not the right mail list for this but my confusion arises because of my 32 bit PostGIS install!

 

I have postgis2SVN sitting on top of postgresql 9.1 (32 bit) on a 64 bit version of windows (working fine).  I installed R-2.14.1 and tried to follow the instructions given here

 

http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01

 

Now I tried both the 32bit and 64bit dll from http://www.joeconway.com/plr/

 

I ran the sql script supplied but get  ERROR:  could not load library "C:/Program Files (x86)/PostgreSQL/9.1/lib/plr.dll": The specified procedure could not be found.

 

Needless to say plr.dll is in that location (I have tried both versions).

 

Any suggestions would be welcome (and apologies if this is a dumb question).

 

Thanks

 

Darrel

 

 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 0 comments |
headers
Andreas Forø Tollefsen | 1 Feb 10:02
Picon

Re: raster2pgsql loader error

Update:


Updated PostGIS, GEOS and GDAL to latest subversions.
Recompiled and installed but no luck.

andreas <at> andreas-priogrid:/$ /usr/lib/postgresql/9.1/bin/raster2pgsql -s 4326 -I /home/nils/postgis/lspop2008/lspop2008.txt public.lspop2008 > /home/andreas/lspop2008.sql
Processing 1/1: /home/nils/postgis/lspop2008/lspop2008.txt
raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed.
Aborted


2012/1/31 Andreas Forø Tollefsen <andreasft <at> gmail.com>
I now see that the Warning 6 message is always present but the data are still converted to sql.
However, the 
lt-raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed. 
message aborts the conversion.


2012/1/31 Andreas Forø Tollefsen <andreasft <at> gmail.com>
Hi all,

Updated to latest subversion and tried the new loader for the first time.
However, i recieve the error below. 
Never seen this error before using raster2pgsql.py script, but apparently, quite some changes have occured since then.

andreas <at> andreas-priogrid:/mnt/pc258/prio_grid/source/access/access_50k/acc_50k$ raster2pgsql -s 4326 -I w001001.adf poptest > /home/andreas/poptest1.sql
Processing 1/1: w001001.adf
Warning 6: A dataset opened by GDALOpenShared should have the same filename (w001001.adf) and description (.)
lt-raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed.
Aborted
andreas <at> andreas-priogrid:/mnt/pc258/prio_grid/source/access/access_50k/acc_50k$

Any ideas?



_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 8 comments |
headers
mdoakes42 | 1 Feb 17:41
Picon

postgis install on solaris

Hello,
I am installing PostGIS 1.5 on a solaris 10 machine.  In the documentation to install PostGIS it says
"A complete installation of PostgreSQL (including server headers) is required. PostgreSQL is available from http://www.postgresql.org . "
 
 
When I installed postgresql initially I used pre-built binaries that I downloaded from postgresql.org.   Is this considered "complete installation"   or do I need to get the postgresql source code in order to install postGIS.
 
 
Thank you.
 
Mike
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 1 comment |
headers
Greg Troxel | 1 Feb 18:17
Picon

Re: postgis install on solaris


> Hello,I am installing PostGIS 1.5 on a solaris 10 machine.  In the
> documentation to install PostGIS it says"A complete installation of
> PostgreSQL (including server headers) is required. PostgreSQL is
> available from http://www.postgresql.org/. "  When I installed
> postgresql initially I used pre-built binaries that I downloaded from
> postgresql.org.  Is this considered "complete installation" or do I
> need to get the postgresql source code in order to install postGIS.

What you really need are the headers and pgxs makefiles.  Depending on
the packaging system, they may or may not be present.

pkgsrc (www.pkgsrc.org) runs on solaris, and (on NetBSD) postgresql
built from pkgsrc is adequate to build postgis (and postgis is
packaged).

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 0 comments |
headers
Paul Ramsey | 1 Feb 18:41
Favicon
Gravatar

postgis-2.0.0alpha3

Available for download and testing at

http://postgis.org/download/postgis-2.0.0alpha3.tar.gz

Thanks!

P.
Permalink | Reply | 2 comments |
headers
Brian Wilson | 1 Feb 20:40

Problem building postgis-2.0.0alpha3

I am stuck trying to build alpha3... I am trying to build from the SVN repo (yes, I did an update this morning) and also just tried the tarball alpha3
I wanted to try it out before our local open source GIS meeting tonight so I could give an update.

I am getting this in the loader directory

/bin/bash ../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall -Wmissing-prototypes    shpopen.o dbfopen.o getopt.o shp2pgsql-core.o shpcommon.o shp2pgsql-cli.o safileio.o ../liblwgeom/liblwgeom.la -o shp2pgsql  -lc
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes shpopen.o dbfopen.o getopt.o shp2pgsql-core.o shpcommon.o shp2pgsql-cli.o safileio.o -o .libs/shp2pgsql  ../liblwgeom/.libs/liblwgeom.so -lc
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSGeom_extractUniquePoints'
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSGeom_createEmptyPolygon'
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSSharedPaths'
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSSnap'
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSOffsetCurve'
../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSUnaryUnion'
collect2: ld returned 1 exit status
make: *** [shp2pgsql] Error 1

I have install geos both from current tarball and svn, same results

I have done builds on this server of svn from 2.0 svn repository before (successfully)

It looks related to geos. I used this for my configure line

./configure  --with-pgconfig=/usr/local/pgsql/bin/pg_config  --with-geosconfig=/usr/local/bin/geos-config  --with-jsondir=/usr  --with-topology --with-raster

and /usr/local/bin/geos-config --version says "3.3.2"

Thanks for any suggestions

--
Brian Wilson
Corvallis Oregon

"My life has been full of terrible misfortunes most of which never happened."
-Michel de Montaigne, essayist (1533-1592) 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 2 comments |
headers
Paul Ramsey | 1 Feb 21:05
Favicon
Gravatar

Re: Problem building postgis-2.0.0alpha3

Willing to bet you have an old version of GEOS hiding on your system
somewhere. Run 'locate libgeos.so'
P.

On Wed, Feb 1, 2012 at 11:40 AM, Brian Wilson <brian <at> wildsong.biz> wrote:
> I am stuck trying to build alpha3... I am trying to build from the SVN repo
> (yes, I did an update this morning) and also just tried the tarball alpha3
> I wanted to try it out before our local open source GIS meeting tonight so I
> could give an update.
>
> I am getting this in the loader directory
>
> /bin/bash ../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes    shpopen.o dbfopen.o getopt.o shp2pgsql-core.o
> shpcommon.o shp2pgsql-cli.o safileio.o ../liblwgeom/liblwgeom.la -o
> shp2pgsql  -lc
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes shpopen.o
> dbfopen.o getopt.o shp2pgsql-core.o shpcommon.o shp2pgsql-cli.o safileio.o
> -o .libs/shp2pgsql  ../liblwgeom/.libs/liblwgeom.so -lc
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to
> `GEOSGeom_extractUniquePoints'
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to
> `GEOSGeom_createEmptyPolygon'
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSSharedPaths'
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSSnap'
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSOffsetCurve'
> ../liblwgeom/.libs/liblwgeom.so: undefined reference to `GEOSUnaryUnion'
> collect2: ld returned 1 exit status
> make: *** [shp2pgsql] Error 1
>
> I have install geos both from current tarball and svn, same results
>
> I have done builds on this server of svn from 2.0 svn repository before
> (successfully)
>
> It looks related to geos. I used this for my configure line
>
> ./configure  --with-pgconfig=/usr/local/pgsql/bin/pg_config
> --with-geosconfig=/usr/local/bin/geos-config  --with-jsondir=/usr
> --with-topology --with-raster
>
> and /usr/local/bin/geos-config --version says "3.3.2"
>
> Thanks for any suggestions
>
> --
> Brian Wilson
> Corvallis Oregon
>
> "My life has been full of terrible misfortunes most of which never
> happened."
> -Michel de Montaigne, essayist (1533-1592)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users <at> postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
Permalink | Reply | 1 comment |
headers
Robert Buckley | 1 Feb 21:07
Picon
Favicon

..


How are you doing?
http://waterultracare.zymichost.com/httpworkathome19385.php?ysipidname=100

            Wed, 1 Feb 2012 21:07:08
______________
"Hooper, while a rough-and-ready old chap, with a big fortune made in cattle dealing, is really an uncut
diamond; a fine old fellow at heart, as you will see.Two busy days followed during which Bill and Gus went to
the city with Professor Gray to purchase materials in full for the power plant." (c) Ananda whigham3
Permalink | Reply | 0 comments |
headers
Brian Wilson | 1 Feb 21:27

Re: Problem building postgis-2.0.0alpha3

Thanks Paul

You win the bet, and are now entitled to free beer whenever you attend the Corvallis open source GIS meetings.

It was hding under /usr/local/LizardTech/GeoExpress8 (buggy commercial Linux version built on Proj.4 and GEOS).
Not sure how the build was finding it but removing the directory fixed it.

On Wed, Feb 1, 2012 at 12:05 PM, Paul Ramsey <pramsey <at> opengeo.org> wrote:
Willing to bet you have an old version of GEOS hiding on your system
somewhere. Run 'locate libgeos.so'
P.

Will let you know if I turn up any REAL bugs.

Brian
 
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 0 comments |
headers
Andreas Forø Tollefsen | 2 Feb 09:38
Picon

Re: raster2pgsql loader error

Hi people, 


Sorry for spamming, but i simply cant find a solution to this.
Has no one ever experienced this issue with the raster loader?

Andreas

2012/2/1 Andreas Forø Tollefsen <andreasft <at> gmail.com>
Update:

Updated PostGIS, GEOS and GDAL to latest subversions.
Recompiled and installed but no luck.

andreas <at> andreas-priogrid:/$ /usr/lib/postgresql/9.1/bin/raster2pgsql -s 4326 -I /home/nils/postgis/lspop2008/lspop2008.txt public.lspop2008 > /home/andreas/lspop2008.sql
Processing 1/1: /home/nils/postgis/lspop2008/lspop2008.txt
raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed.
Aborted


2012/1/31 Andreas Forø Tollefsen <andreasft <at> gmail.com>
I now see that the Warning 6 message is always present but the data are still converted to sql.
However, the 
lt-raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed. 
message aborts the conversion.


2012/1/31 Andreas Forø Tollefsen <andreasft <at> gmail.com>
Hi all,

Updated to latest subversion and tried the new loader for the first time.
However, i recieve the error below. 
Never seen this error before using raster2pgsql.py script, but apparently, quite some changes have occured since then.

andreas <at> andreas-priogrid:/mnt/pc258/prio_grid/source/access/access_50k/acc_50k$ raster2pgsql -s 4326 -I w001001.adf poptest > /home/andreas/poptest1.sql
Processing 1/1: w001001.adf
Warning 6: A dataset opened by GDALOpenShared should have the same filename (w001001.adf) and description (.)
lt-raster2pgsql: rt_api.c:4281: rt_raster_set_srid: Assertion `((void *)0) != raster' failed.
Aborted
andreas <at> andreas-priogrid:/mnt/pc258/prio_grid/source/access/access_50k/acc_50k$

Any ideas?




_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 7 comments |

Gmane