[postgis-users] Install problem

[Eric Knappe]

Hello,

I'm new to Postgis, trying to install on Red Hat. I'm getting a variation of
an error that shows up a lot in message boards.

I'm getting an error running lwpostgis.sql.
I configured postgresql with LDFLAGS=-lstdc++.
I ran ldconfig after updating /etc/ld.so.conf.

The error is:
[mydir][~]$ psql -d gistest -f share/lwpostgis.sql
BEGIN
psql:share/lwpostgis.sql:53: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:share/lwpostgis.sql:53: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
psql:share/lwpostgis.sql:53: connection to server was lost
[mydir][~]$

When I try to run statements alone in phppgadmin, I see this for a create
function using a library:

*SQL error:*

server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

*In statement:*

CREATE OR REPLACE FUNCTION ST_histogram2d_in(cstring)
	RETURNS histogram2d
	AS '/home/mydir/lib/liblwgeom', 'lwhistogram2d_in'
	LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);

The Log on the server has:
[mydir][~]$ NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
LOG:  server process (PID 4889) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
L

Here is the postgresql configuration

[mydir][~]$ pg_config
BINDIR = /usr/home/mydir/bin
DOCDIR = /usr/home/mydir/doc/postgresql
INCLUDEDIR = /usr/home/mydir/include
PKGINCLUDEDIR = /usr/home/mydir/include/postgresql
INCLUDEDIR-SERVER = /usr/home/mydir/include/postgresql/server
LIBDIR = /usr/home/mydir/lib
PKGLIBDIR = /usr/home/mydir/lib/postgresql
LOCALEDIR =
MANDIR = /usr/home/mydir/man
SHAREDIR = /usr/home/mydir/share/postgresql
SYSCONFDIR = /usr/home/mydir/etc/postgresql
PGXS = /usr/home/mydir/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/home/mydir' 'LDFLAGS=-lstdc++'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -lstdc++ -Wl,-rpath,'/home/mydir/lib'
LDFLAGS_SL =
LIBS = -lpgport -lz -lreadline -lncurses -lcrypt -ldl -lm
VERSION = PostgreSQL 8.2.6
[mydir][~]$



Any help would be greatly appreciated
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080114/e3e2060d/attachment.html>