[postgis-users] Building with mingw32, configure for PostgreSQL

[Romi Hardiyanto]

TECHER Jean David wrote:
> Hi Romi
> 
> Do you get errors about 'create index using gist...' on large tables???

I dump my database on Linux and then upload them on mingw version.  Some 
table consists of hundred thousand rows of point, nearly 20.000 rows 
multilinestring (road). They are all indexed using gist (are they large 
enough?), but no error happened. Are there any PostgreSQL's log available?

Romi H

> 
> TECHER JEAN DAVID
> - Responsable Informatique 01MAP -
> e-mail:davidtecher at yahoo.fr
> Tél: 06 85 37 36 75
> Site PostGIS: http://techer.pascal.free.fr/postgis/index.htm
> 
> -----Message d'origine-----
> De : postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]De la part de Romi
> Hardiyanto
> Envoyé : mardi 18 mai 2004 02:02
> À : PostGIS Users Discussion
> Objet : Re: [postgis-users] Building with mingw32, configure for
> PostgreSQL
> 
> 
> My solution is to add include directory to postgis Makefile like:
> 
> override CFLAGS += -g -fexceptions
> override CFLAGS += -I$(srcdir) -DFRONTEND -DSYSCONFDIR='"$(sysconfdir)"'
> -I/mingw/include
> override CFLAGS += -DUSE_VERSION=$(USE_VERSION)
> 
> The MinGW header files is not on search path (/include in MSys).
> 
> Romi H
> 
> 
> Craig Miller wrote:
> 
>>I was able to get everything to compile except PostGIS with GEOS support.
>>PostGIS w/o GEOS support works, and the GEOS compile works good too.  I
> 
> saw
> 
>>in your notes that you said you had to copy the GEOS header files to
>>/include.  This directory does not exist in a default msys installation.
>>Did you add it?
>>
>>Thanks,
>>--Craig
>>
>>
>>-----Original Message-----
>>From: David TECHER [mailto:davidtecher at yahoo.fr]
>>Sent: Monday, May 17, 2004 5:36 AM
>>To: PostGIS Users Discussion
>>Subject: RE: [postgis-users] Building with mingw32, configure for
>>PostgreSQL
>>
>>
>> Hi Craig
>>
>>can you give me the file or the URL where you have
>>seen this?
>>
>>Did you succeed in compiling?
>>
>>
>>
>>>I remember that you posted a message about having
>>>trouble creating indexes
>>>on large datasets with the mingw version of postgis
>>>you compiled.  I read a
>>>note in the postgresql compile notes that said to be
>>>sure to run postgres
>>
>>>from a normal DOS cmd prompt and not an rxvt shell
>>
>>>due to some sort of
>>>memory limitation.  Perhaps this is what is causing
>>>the trouble with large
>>>datasets?
>>>
>>>--Craig
>>>
>>>
>>>-----Original Message-----
>>>From: David TECHER [mailto:davidtecher at yahoo.fr]
>>>Sent: Thursday, May 13, 2004 8:30 AM
>>>To: PostGIS Users Discussion
>>>Subject: Re: [postgis-users] Building with mingw32,
>>>configure for
>>>PostgreSQL
>>>
>>>
>>> Dear Romi
>>>
>>>thanks thanks very much I succeed I succeed after
>>>two
>>>weeks of work
>>>
>>>I'm happy...You know I'm happy :)
>>>
>>>
>>>
>>>
>>>
>>>
>>>Yahoo! Mail : votre e-mail personnel et gratuit qui
>>>vous suit partout !
>>>Créez votre Yahoo! Mail sur
>>>http://fr.benefits.yahoo.com/
>>>
>>>Dialoguez en direct avec vos amis grâce à Yahoo!
>>>Messenger !Téléchargez
>>>Yahoo! Messenger sur http://fr.messenger.yahoo.com
>>>_______________________________________________
>>>postgis-users mailing list
>>>postgis-users at postgis.refractions.net
>>>
>>
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>>
>>>
>>>_______________________________________________
>>>postgis-users mailing list
>>>postgis-users at postgis.refractions.net
>>>
>>
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>>
>>
>>Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout !
>>Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/
>>
>>Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez
>>Yahoo! Messenger sur http://fr.messenger.yahoo.com
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
>