[postgis-users] 'server closed the connection unexpectedly' problem

Ionut Iordache ionut at eps.berkeley.edu
Thu Jan 27 12:48:37 PST 2005


I recently loaded large quantities of point data (close to half a
billion records) into postgresql-7.4.6 with postgis-cvs version 1.0.0
(as of 2005/01/13) and although the geometry creation and table
loading went smoothly, I can't use any of the postgis functions on the
POINT geometry columns!

For example, when I try to run something like SELECT X(point_geom)
FROM raw_data LIMIT 10; , I get the following error message:

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

The same thing happens when I try to execute the Distance function for
example. But if I do a SELECT AsText(point_geom), the records show up
just fine...

The log is not showing anything suspicious, except reporting that the
child process was terminated by signal 10.
I compiled postgres with LDFLAGS = -lstdc++ -lgcc and enabled geos and
proj4 in postgis.

Thanks for you assistance!

Best regards,
Dorel Ionut Iordache - <ionut at eps.berkeley.edu>
UC Berkeley - Earth & Planetary Science Dept.

More information about the postgis-users mailing list