[Geoserver-devel] PostGIS TIP...

GeoServer GeoServer Developer
,
1

Hi...

I do think to post an application in production enviroment on linux Fedora S.O. Can anybody tell me which is the best combination of Fedora, Geoserver, Postgres, Proj4, GEOS and PostGIS versions???

Thanks in advance... Excuseme for my poor English...

2

Hi Fernando,

I am running the latest versions (or pretty darn close) of all the following and have had no problems.

Fedora core 4
postgresql-8.0.4
geos-2.1.4
postgis-1.0.4
proj-4.4.9
geoserver-1.3.0-RC4

-Justin

Fernando Avalos García wrote:

Hi...

I do think to post an application in production enviroment on linux Fedora S.O. Can anybody tell me which is the best combination of Fedora, Geoserver, Postgres, Proj4, GEOS and PostGIS versions???

Thanks in advance... Excuseme for my poor English...

-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

3

Hi Justin:

I has been trying to install:

Fedora core 4
postgresql-8.0.4
geos-2.1.4
postgis-1.0.4
proj-4.4.9

but, I have a problem and I can`t solve it.

Can you say me what`s wrong??? or what`s missing???

Thanks in advance!!!

Here is the list of instruccions, that I execute:

#cp proj-4.4.9.tar.gz /opt/proj-4.4.9.tar.gz
#cd /opt
#tar -xzvf proj-4.4.9.tar.gz
#rm proj-4.4.9.tar.gz
#cd proj-4.4.9/
#./configure
#make
#make install

#cp geos-2.1.4.tar.bz2 /opt/geos-2.1.4.tar.bz2
#cd /opt
#tar -xjvf geos-2.1.4.tar.bz2
#rm geos-2.1.4.tar.bz2
#cd geos-2.1.4/
#./configure
#make
#make install

#cp postgresql-8.0.6.tar.gz /opt/postgresql-8.0.6.tar.gz
#cd /opt/
#tar -xzvf postgresql-8.0.6.tar.gz
#rm postgresql-8.0.6.tar.gz
#cd postgresql-8.0.6/
#./configure
#make
#make install

#cd /usr/local/pgsql/
#mkdir data
#chown postgres:postgres data
#su - postgres
#cd /usr/local/pgsql/bin
#./initdb -D ../data
#./postmaster -D ../data
#./createdb test
#./psql test
test=# select version();
                                              version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8)
(1 row)

test-# \q
#exit
#cp postgis-1.0.6.tar.gz /opt/postgresql-8.0.6/contrib/postgis-1.0.6.tar.gz
#cd /opt/postgresql-8.0.6/contrib/
#tar -xzvf postgis-1.0.6.tar.gz
#rm postgis-1.0.6.tar.gz
#cd postgis-1.0.6/
#vi Makefile.config
#make
#make install
#su - postgres
#cd /usr/local/pgsql/bin/
#./createlang plpgsql test
#./psql -f ../share/contrib/lwpostgis.sql -d test
BEGIN
psql:../share/contrib/lwpostgis.sql:30: NOTICE: type "histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
psql:../share/contrib/lwpostgis.sql:30: ERROR: could not load library "/usr/local/pgsql/lib/liblwgeom.so.1.0": libgeos.so.2: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
...

4

Looks like the geos library cant be found. I beleive the postgis configuration file will try to find it in the default location, if not you might have to specify using the --with-geos=PATH option when you compile postgis.

It looks like you stuck with the default for geos, which i think is /usr/local/lib, can you verify the library exists there.

-Justin

Fernando Avalos García wrote:

Hi Justin:

I has been trying to install:

Fedora core 4
postgresql-8.0.4
geos-2.1.4
postgis-1.0.4
proj-4.4.9

but, I have a problem and I can`t solve it.

Can you say me what`s wrong??? or what`s missing???

Thanks in advance!!!

Here is the list of instruccions, that I execute:

#cp proj-4.4.9.tar.gz /opt/proj-4.4.9.tar.gz
#cd /opt
#tar -xzvf proj-4.4.9.tar.gz
#rm proj-4.4.9.tar.gz
#cd proj-4.4.9/
#./configure
#make
#make install

#cp geos-2.1.4.tar.bz2 /opt/geos-2.1.4.tar.bz2
#cd /opt
#tar -xjvf geos-2.1.4.tar.bz2
#rm geos-2.1.4.tar.bz2
#cd geos-2.1.4/
#./configure
#make
#make install

#cp postgresql-8.0.6.tar.gz /opt/postgresql-8.0.6.tar.gz
#cd /opt/
#tar -xzvf postgresql-8.0.6.tar.gz
#rm postgresql-8.0.6.tar.gz
#cd postgresql-8.0.6/
#./configure
#make
#make install

#cd /usr/local/pgsql/
#mkdir data
#chown postgres:postgres data
#su - postgres
#cd /usr/local/pgsql/bin
#./initdb -D ../data
#./postmaster -D ../data
#./createdb test
#./psql test
test=# select version();
                                             version
---------------------------------------------------------------------------------------------------

PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8)
(1 row)

test-# \q
#exit
#cp postgis-1.0.6.tar.gz /opt/postgresql-8.0.6/contrib/postgis-1.0.6.tar.gz
#cd /opt/postgresql-8.0.6/contrib/
#tar -xzvf postgis-1.0.6.tar.gz
#rm postgis-1.0.6.tar.gz
#cd postgis-1.0.6/
#vi Makefile.config
#make
#make install
#su - postgres
#cd /usr/local/pgsql/bin/
#./createlang plpgsql test
#./psql -f ../share/contrib/lwpostgis.sql -d test
BEGIN
psql:../share/contrib/lwpostgis.sql:30: NOTICE: type "histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
psql:../share/contrib/lwpostgis.sql:30: ERROR: could not load library "/usr/local/pgsql/lib/liblwgeom.so.1.0": libgeos.so.2: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
...

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com

5

Add /usr/local/lib to /etc/ld.so.conf

P

On 7-Apr-06, at 9:13 AM, Justin Deoliveira wrote:

Looks like the geos library cant be found. I beleive the postgis configuration file will try to find it in the default location, if not you might have to specify using the --with-geos=PATH option when you compile postgis.

It looks like you stuck with the default for geos, which i think is /usr/local/lib, can you verify the library exists there.

-Justin

Fernando Avalos García wrote:

Hi Justin:
I has been trying to install:
Fedora core 4
postgresql-8.0.4
geos-2.1.4
postgis-1.0.4
proj-4.4.9
but, I have a problem and I can`t solve it.
Can you say me what`s wrong??? or what`s missing???
Thanks in advance!!!
Here is the list of instruccions, that I execute:
#cp proj-4.4.9.tar.gz /opt/proj-4.4.9.tar.gz
#cd /opt
#tar -xzvf proj-4.4.9.tar.gz
#rm proj-4.4.9.tar.gz
#cd proj-4.4.9/
#./configure
#make
#make install
#cp geos-2.1.4.tar.bz2 /opt/geos-2.1.4.tar.bz2
#cd /opt
#tar -xjvf geos-2.1.4.tar.bz2
#rm geos-2.1.4.tar.bz2
#cd geos-2.1.4/
#./configure
#make
#make install
#cp postgresql-8.0.6.tar.gz /opt/postgresql-8.0.6.tar.gz
#cd /opt/
#tar -xzvf postgresql-8.0.6.tar.gz
#rm postgresql-8.0.6.tar.gz
#cd postgresql-8.0.6/
#./configure
#make
#make install
#cd /usr/local/pgsql/
#mkdir data
#chown postgres:postgres data
#su - postgres
#cd /usr/local/pgsql/bin
#./initdb -D ../data
#./postmaster -D ../data
#./createdb test
#./psql test
test=# select version();
                                             version
--------------------------------------------------------------------------------------------------- PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8)
(1 row)
test-# \q
#exit
#cp postgis-1.0.6.tar.gz /opt/postgresql-8.0.6/contrib/postgis-1.0.6.tar.gz
#cd /opt/postgresql-8.0.6/contrib/
#tar -xzvf postgis-1.0.6.tar.gz
#rm postgis-1.0.6.tar.gz
#cd postgis-1.0.6/
#vi Makefile.config
#make
#make install
#su - postgres
#cd /usr/local/pgsql/bin/
#./createlang plpgsql test
#./psql -f ../share/contrib/lwpostgis.sql -d test
BEGIN
psql:../share/contrib/lwpostgis.sql:30: NOTICE: type "histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
psql:../share/contrib/lwpostgis.sql:30: ERROR: could not load library "/usr/local/pgsql/lib/liblwgeom.so.1.0": libgeos.so.2: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
...

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

6

Fernando Avalos García fernandroide@anonymised.com escribió:

Hi Justin:

I has been trying to install:

Fedora core 4
postgresql-8.0.4
geos-2.1.4
postgis-1.0.4
proj-4.4.9

but, I have a problem and I can`t solve it.

Can you say me whats wrong??? or whats missing???

Thanks in advance!!!

Here is the list of instruccions, that I execute:

#cp proj-4.4.9.tar.gz /opt/proj-4.4.9.tar.gz
#cd /opt
#tar -xzvf proj-4.4.9.tar.gz
#rm proj-4.4.9.tar.gz
#cd proj-4.4.9/
#./configure
#make
#make install

#cp geos-2.1.4.tar.bz2 /opt/geos-2.1.4.tar.bz2
#cd /opt
#tar -xjvf geos-2.1.4.tar.bz2
#rm geos-2.1.4.tar.bz2
#cd geos-2.1.4/
#./configure
#make
#make install

#cp postgresql-8.0.6.tar.gz /opt/postgresql-8.0.6.tar.gz
#cd /opt/
#tar -xzvf postgresql-8.0.6.tar.gz
#rm postgresql-8.0.6.tar.gz
#cd postgresql-8.0.6/
#./configure
#make
#make install

#cd /usr/local/pgsql/
#mkdir data
#chown postgres:postgres data
#su - postgres
#cd /usr/local/pgsql/bin
#./initdb -D …/data
#./postmaster -D …/data
#./createdb test
#./psql test
test=# select version();
version

PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.0
20050519 (Red Hat 4.0.0-8)
(1 row)

test-# \q
#exit
#cp postgis-1.0.6.tar.gz /opt/postgresql-8.0.6/contrib/postgis-1.0.6.tar.gz
#cd /opt/postgresql-8.0.6/contrib/
#tar -xzvf postgis-1.0.6.tar.gz
#rm postgis-1.0.6.tar.gz
#cd postgis-1.0.6/
#vi Makefile.config
#make
#make install
#su - postgres
#cd /usr/local/pgsql/bin/
#./createlang plpgsql test
#./psql -f …/share/contrib/lwpostgis.sql -d test
BEGIN
psql:…/share/contrib/lwpostgis.sql:30: NOTICE: type “histogram2d” is not
yet defined
DETAIL: Creating a shell type definition.
psql:…/share/contrib/lwpostgis.sql:30: ERROR: could not load library
“/usr/local/pgsql/lib/liblwgeom.so.1.0”: libgeos.so.2: no se puede abrir el
fichero del objeto compartido: No existe el fichero o el directorio

Lo que pasa es que tienes que añadir ademas al archivo que te dice Paul la siguiente linea
/usr/local/pgsql/lib

y ejecutas como root
#ldconfig

y luego
#ldconfig -v | less

y debes revisar que esten todas las bibliotecas cargadas
geos, proj, postgres y las de postgis

Verrifica además que en el archivo makefile.conf tengas en 1 geos y proj

Saludos.

Nahum.

–
Nahum Castro
Leon, Guanajuato, Mexico
http://www.leon-linux.com
e-mail: pedro1_72 [en] yahoo [punto] com

Correo Yahoo! te ofrece 1GB de espacio, ¡gratis! Crea tu cuenta hoy mismo, en http://correo.yahoo.com.mx/