postgis

Hi

I installed enterprisedb (edbpg-824-linux-x32-b1.tar.gz) on centos 5.0 (i386). I try to use postgis but it does not work for me...
According to http://www.postgis.org/documentation/ first I issued 'createlang plpgsql DBNAME' then I tried 'psql -d yourtestdatabase -f lwpostgis.sql' and that is the problem.
First I tried to use /opt/edb-postgres/8.2/8.2.4/share/lwpostgis.sql but that file contains a stupid path (/home/buildfarm/buildfarm/builds/postgres-8.2.4/070806-21.52.05/install/lib/liblwgeom.so.1.2).
I changed the path to /opt/edb-postgres/8.2/8.2.4/lib/liblwgeom.so.1.2 and now I get

psql.bin:/tmp/lwpostgis.sql:4225: ERROR: could not find function "coveredby" in file "/opt/edb-postgres/8.2/8.2.4/lib/liblwgeom.so.1.2"

Please help, thanks
Gabor

agdolla wrote:Hi

I installed enterprisedb (edbpg-824-linux-x32-b1.tar.gz) on centos 5.0 (i386). I try to use postgis but it does not work for me...
According to http://www.postgis.org/documentation/ first I issued 'createlang plpgsql DBNAME' then I tried 'psql -d yourtestdatabase -f lwpostgis.sql' and that is the problem.
First I tried to use /opt/edb-postgres/8.2/8.2.4/share/lwpostgis.sql but that file contains a stupid path (/home/buildfarm/buildfarm/builds/postgres-8.2.4/070806-21.52.05/install/lib/liblwgeom.so.1.2).
I changed the path to /opt/edb-postgres/8.2/8.2.4/lib/liblwgeom.so.1.2 and now I get

psql.bin:/tmp/lwpostgis.sql:4225: ERROR: could not find function "coveredby" in file "/opt/edb-postgres/8.2/8.2.4/lib/liblwgeom.so.1.2"

Please help, thanks
Gabor

Please look forward t see this fixed in the beta2 of Linux installer which will be released in a weeks time.

I compiled postgres, postgis, geos and proj from source and it just works.
I wonder why I'd use enterprisedb instead of the original ?

Anonymous wrote:I compiled postgres, postgis, geos and proj from source and it just works.
I wonder why I'd use enterprisedb instead of the original ?

For geos IIRC, I would probably need to update the Makefile such that instead of expanding the path the .sql files start making use of $libpath

The purpose of this installer is that you wouldn't have to compile it yourself and it would be pre-configured to use. I appreciate the time taken out to test these installers and reporting issues back to us for fixing and making them better.

I am not sure what you meant by "original", the installer contains binaries that are built from the latest stable sources pulled from the respective project websites.

Hi
I did not want to be mean, sorry if my words hurted you (I'm not native English)

Could you please publish your work so that we could see what your system does and how the product is built ? What extra is added ?

also, instead of the fancy java installer an rpm repository from which I could install/upgrade with yum would be far more usable

regards

Gabor

Anonymous wrote:
also, instead of the fancy java installer an rpm repository from which I could install/upgrade with yum would be far more usable

We are currently working on cross-platform RPMs and a .DEB distribution for users that prefer the platform-standard package manager over the GUI installer.

The file lwpostgis.sql contains some error functions and they need to be fixed.
I changed lwpostgis.sql file with the EDB's Installer file and it will work fine

ooober

Can you please mention a few changes you had to do in order to make it work?

Thanks,

compare edb-postgres lwpostgis.sql file with EDB lwpostgis.sql file and u will find the differece

I was actually asking if you modified the sql file and then used that or you just used the one that was available with EnterpriseDB installation. I know comparing the two files can always give the difference

but I wanted to ask what exactly were the steps you did in the process...

This message was edited 1 time. Last update was at 5 Sep 2007 07:40:51

Just replace lwpostgis.sql file with edb installer and it will work

and update the path 2!!!!

Linux 32 Build 2 Installers are now available, can you try out this issue on the new build.