[postgis-devel] Regarding Sp-gist implementation in postgis

mohit kumar mohitkharb at gmail.com
Wed Jul 23 04:16:55 PDT 2014

Hi strk,
As my system crashed and I had to build everything again. Now Even I am
getting the same error.
test1=# create index on points using spgist(g);
The connection to the server was lost. Attempting reset: Failed.

While using valgrind debuging the following error comes :
mohit at mohit-Inspiron-1545:~/builds/source/postgis$ echo "create index on
points using spgist(g);" | valgrind --leak-check=yes --log-file=valgrindlog
/usr/local/pgsql/bin/postgres -D /usr/local/pgdata --single postgis
FATAL:  --single requires a value

Also what is the "path/to/database" to be used for pg_ctl?

On Fri, Jul 18, 2014 at 1:24 PM, Sandro Santilli <strk at keybit.net> wrote:

> On Thu, Jul 17, 2014 at 10:20:17PM +0530, mohit kumar wrote:
> > I wantedly defined no operators for the opclass. Only functions.
> I understand sp-gist access method _requires_ defining operators to
> implement a set of strategies (numbers 1,5,6,8,10,11).
> Anyway, as the error talks about missing support function instead...
> I tried installing your version of PostGIS [1] and here's what I get:
> spgist=# create table t(g geometry);
> spgist=# create index on t using spgist(g);
> DEBUG:  building index "t_g_idx" on table "t"
> The connection to the server was lost. Attempting reset: Failed.
> !>
> Maybe the message you're getting is just misleading due to a memory
> bug triggering arbitrary pieces of code ?
> I suggest you add more debugging prints in your code, and also it may
> be useful to take a look at what you got so far with valgrind:
> http://blog.cleverelephant.ca/2008/08/valgrinding-postgis.html
> [1] https://github.com/mohitkharb/postgis/tree/spgist
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

Mohit Kumar
Lab For Spatial Informatics
International Institute of Information Technology
Hyderabad, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140723/132be865/attachment.html>

More information about the postgis-devel mailing list