[postgis-users] ST_Intersects(geom, geom) Memory issue
Hi again, I have a issue with the server crashing when running a simple query i have been using together with previous versions of postgis on the same system. The query intersects two tables with geometry. While i never have had problems with this query before, it is now terminates my postgresql server. It used to take ~5 min to complete, but now it terminates after 2 minutes. When running the query i can see using top that memory rises to 96 % before terminating the postgreql service. My setup is Intel(R) Xeon(R) CPU E31270 @ 3.40GHz with 12GB of ram running: version PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit (1 row) postgis_full_version -- POSTGIS=2.0.0alpha4SVN GEOS=3.4.0dev-CAPI-1.8.0 PROJ=Rel. 4.7.1, 23 September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 USE_STATS (1 row) shared_buffers = 4GB# min 128kB temp_buffers = 64MB # min 800kB work_mem = 64MB # min 64kB maintenance_work_mem = 512MB# min 1MB Running the query: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; terminates the server with the below messages. I have used the query previously without problems, but after updating to latest subversion it do not work anymore. I am suspecting there is some memory issue. I tried reducing the shared_buffers and disabling memory overcommit (bottom: http://www.postgresql.org/docs/9.1/static/kernel-resources.html). Any help on this would be very much welcome. All the best, Andreas Log: 2012-02-03 09:27:01 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:27:01 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. 2012-02-03 09:27:02 CET LOG: all server processes terminated; reinitializing 2012-02-03 09:27:03 CET LOG: database system was interrupted; last known up at 2012-02-03 09:25:37 CET 2012-02-03 09:27:04 CET LOG: database system was not properly shut down; automatic recovery in progress 2012-02-03 09:27:04 CET LOG: consistent recovery state reached at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: record with zero length at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: redo is not required 2012-02-03 09:27:04 CET LOG: database system is ready to accept connections 2012-02-03 09:27:04 CET LOG: autovacuum launcher started 2012-02-03 09:30:07 CET LOG: incomplete startup packet 2012-02-03 09:30:08 CET LOG: received fast shutdown request 2012-02-03 09:30:08 CET LOG: aborting any active transactions 2012-02-03 09:30:09 CET LOG: autovacuum launcher shutting down 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET STATEMENT: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; 2012-02-03 09:31:09 CET LOG: received immediate shutdown request 2012-02-03 09:31:09 CET WARNING: terminating connection because of crash of another server process 2012-02-03 09:31:09 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:31:09 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ST_Intersects(geom, geom) Memory issue
Hi again... Downgraded to revision 8001 and the query works. Query returned successfully: 162082 rows affected, 114992 ms execution time. Andreas 2012/2/3 Andreas Forø Tollefsen andrea...@gmail.com Hi again, I have a issue with the server crashing when running a simple query i have been using together with previous versions of postgis on the same system. The query intersects two tables with geometry. While i never have had problems with this query before, it is now terminates my postgresql server. It used to take ~5 min to complete, but now it terminates after 2 minutes. When running the query i can see using top that memory rises to 96 % before terminating the postgreql service. My setup is Intel(R) Xeon(R) CPU E31270 @ 3.40GHz with 12GB of ram running: version PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit (1 row) postgis_full_version -- POSTGIS=2.0.0alpha4SVN GEOS=3.4.0dev-CAPI-1.8.0 PROJ=Rel. 4.7.1, 23 September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 USE_STATS (1 row) shared_buffers = 4GB# min 128kB temp_buffers = 64MB # min 800kB work_mem = 64MB # min 64kB maintenance_work_mem = 512MB# min 1MB Running the query: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; terminates the server with the below messages. I have used the query previously without problems, but after updating to latest subversion it do not work anymore. I am suspecting there is some memory issue. I tried reducing the shared_buffers and disabling memory overcommit (bottom: http://www.postgresql.org/docs/9.1/static/kernel-resources.html). Any help on this would be very much welcome. All the best, Andreas Log: 2012-02-03 09:27:01 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:27:01 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. 2012-02-03 09:27:02 CET LOG: all server processes terminated; reinitializing 2012-02-03 09:27:03 CET LOG: database system was interrupted; last known up at 2012-02-03 09:25:37 CET 2012-02-03 09:27:04 CET LOG: database system was not properly shut down; automatic recovery in progress 2012-02-03 09:27:04 CET LOG: consistent recovery state reached at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: record with zero length at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: redo is not required 2012-02-03 09:27:04 CET LOG: database system is ready to accept connections 2012-02-03 09:27:04 CET LOG: autovacuum launcher started 2012-02-03 09:30:07 CET LOG: incomplete startup packet 2012-02-03 09:30:08 CET LOG: received fast shutdown request 2012-02-03 09:30:08 CET LOG: aborting any active transactions 2012-02-03 09:30:09 CET LOG: autovacuum launcher shutting down 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET STATEMENT: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; 2012-02-03 09:31:09 CET LOG: received immediate shutdown request 2012-02-03 09:31:09 CET WARNING: terminating connection because of crash of another server process 2012-02-03 09:31:09 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:31:09 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Kosmo SIG and PostGIS 2.0
Hola, Si alguien está interesado he modificado el driver de Kosmo SIG2.0.1 para que soporte PostGIS 2.0 Para la instalación simplemente hay que sobreescribir el fichero saig.jar que está dentro del directorio bin de la instalación de Kosmo. El fichero [1] solo estará 7 dias disponible en esta página web. Saludos, Jose Carlos --- Hi, If someone is interested I have modified the driver of Kosmo SIG 2.0.1 to support PostGIS 2.0. You just have to overwrite the saig.jar file located in kosmo/bin directory. I changed the driver too for not using the postgis jdbc. The file [1] will be just 7 days available in this website. Cheers, Jose [1] http://intercambio.upv.es/download.php?id=96c193010cf4162d046adcc356f650d0 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ST_Intersects(geom, geom) Memory issue
Something in this chain of changes is probably the cause... P. On Fri, Feb 3, 2012 at 2:44 AM, Andreas Forø Tollefsen andrea...@gmail.com wrote: Hi again... Downgraded to revision 8001 and the query works. Query returned successfully: 162082 rows affected, 114992 ms execution time. Andreas 2012/2/3 Andreas Forø Tollefsen andrea...@gmail.com Hi again, I have a issue with the server crashing when running a simple query i have been using together with previous versions of postgis on the same system. The query intersects two tables with geometry. While i never have had problems with this query before, it is now terminates my postgresql server. It used to take ~5 min to complete, but now it terminates after 2 minutes. When running the query i can see using top that memory rises to 96 % before terminating the postgreql service. My setup is Intel(R) Xeon(R) CPU E31270 @ 3.40GHz with 12GB of ram running: version PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit (1 row) postgis_full_version -- POSTGIS=2.0.0alpha4SVN GEOS=3.4.0dev-CAPI-1.8.0 PROJ=Rel. 4.7.1, 23 September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 USE_STATS (1 row) shared_buffers = 4GB # min 128kB temp_buffers = 64MB # min 800kB work_mem = 64MB # min 64kB maintenance_work_mem = 512MB # min 1MB Running the query: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; terminates the server with the below messages. I have used the query previously without problems, but after updating to latest subversion it do not work anymore. I am suspecting there is some memory issue. I tried reducing the shared_buffers and disabling memory overcommit (bottom: http://www.postgresql.org/docs/9.1/static/kernel-resources.html). Any help on this would be very much welcome. All the best, Andreas Log: 2012-02-03 09:27:01 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:27:01 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. 2012-02-03 09:27:02 CET LOG: all server processes terminated; reinitializing 2012-02-03 09:27:03 CET LOG: database system was interrupted; last known up at 2012-02-03 09:25:37 CET 2012-02-03 09:27:04 CET LOG: database system was not properly shut down; automatic recovery in progress 2012-02-03 09:27:04 CET LOG: consistent recovery state reached at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: record with zero length at 7F/E90EF588 2012-02-03 09:27:04 CET LOG: redo is not required 2012-02-03 09:27:04 CET LOG: database system is ready to accept connections 2012-02-03 09:27:04 CET LOG: autovacuum launcher started 2012-02-03 09:30:07 CET LOG: incomplete startup packet 2012-02-03 09:30:08 CET LOG: received fast shutdown request 2012-02-03 09:30:08 CET LOG: aborting any active transactions 2012-02-03 09:30:09 CET LOG: autovacuum launcher shutting down 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET FATAL: terminating connection due to administrator command 2012-02-03 09:30:09 CET STATEMENT: DROP TABLE IF EXISTS geoepr_cell; SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell, g.geom) AND g.startyear = 1946 AND g.endyear = 1946 GROUP BY a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ; 2012-02-03 09:31:09 CET LOG: received immediate shutdown request 2012-02-03 09:31:09 CET WARNING: terminating connection because of crash of another server process 2012-02-03 09:31:09 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-02-03 09:31:09 CET HINT: In a moment you should be able to reconnect to the database and repeat your command.
[postgis-users] Postgis for Postgres 64 bits
hello, When is Postgis for Postgres in 64 bits? Thank you Carlos J. Muñoz M. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis for Postgres 64 bits
For Linux, it has been available for some years. If you need 64bit support, you might consider upgrading :-) Cheers Brent Wood --- On Sat, 2/4/12, CARLOS MUÑOZ cjmun...@yahoo.com wrote: From: CARLOS MUÑOZ cjmun...@yahoo.com Subject: [postgis-users] Postgis for Postgres 64 bits To: postgis-users@postgis.refractions.net postgis-users@postgis.refractions.net Date: Saturday, February 4, 2012, 8:31 AM hello, When is Postgis for Postgres in 64 bits? Thank you Carlos J. Muñoz M. -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Rv: Postgis for Postgres 64 bits
Great, For windows in 64 bits Its possible Postgis for Postgres? Thank you ;) Carlos J. Muñoz M. Student Master GIS - Mensaje reenviado - De: pcr...@pcreso.com pcr...@pcreso.com Para: CARLOS MUÑOZ cjmun...@yahoo.com; PostGIS Users Discussion postgis-users@postgis.refractions.net Enviado: Viernes, 3 de febrero, 2012 14:37:30 Asunto: Re: [postgis-users] Postgis for Postgres 64 bits For Linux, it has been available for some years. If you need 64bit support, you might consider upgrading :-) Cheers Brent Wood --- On Sat, 2/4/12, CARLOS MUÑOZ cjmun...@yahoo.com wrote: From: CARLOS MUÑOZ cjmun...@yahoo.com Subject: [postgis-users] Postgis for Postgres 64 bits To: postgis-users@postgis.refractions.net postgis-users@postgis.refractions.net Date: Saturday, February 4, 2012, 8:31 AM hello, When is Postgis for Postgres in 64 bits? Thank you Carlos J. Muñoz M. -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Overlapping linestrings
I'm looking for the fastest way to detect whether a given linestring overlaps another linestring. Here's my current approach. Given two tables: r1 and s1, both containing a geo_data column of linestring, first narrow the data (taking advantage of gist index) with r1.geo_data s1.geo_data, then use ST_Contains to see if s1 is overlapping r1, i.e. r1.geo_data s1.geo_data and ST_Contains(ST_Buffer(r1.geo_data,ST_Length(r1.geo_data)*.002),s1.geo_data) This approach works, but it's extremely CPU-intensive and slow. Is there a better approach? Thanks, -- Adam McManus ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS support of Geography data type in java jdbc, driver?
Try hibernate spatial= Disclaimer: This email and any attachments thereof may contain confidential, privileged, proprietary, or otherwise private information. This email is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of the email and its attachments please inform the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any way and delete this e-mail and its attachments from your system. Any views or opinions expressed are solely those of the author. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] enforce_dims_geom change between 1.3.3 and 1.4.0?
I have this geometric is a 1.3.3 PostGIS enabled database: st_npoints | st_astext +--- 3 | POLYGON((-97.288445 39.566748,-97.288188 39.566749,-97.288445 39.566748)) I used pg_dump to move this to a 1.4.0 PostGIS enabled database. And I get this: st_npoints 3 for the number of point, but trying to see the geom ERROR: geometry requires more points I don't see anything else in my psotgres logs. Any ideas? - Brian ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] enforce_dims_geom change between 1.3.3 and 1.4.0?
Crazily, we ended up with a situation for a while where the input checks were looser than the output checks, or could be depending on the output format you used. I hope we fixed it in later minor releases, try a later 1.4 release. P. On Fri, Feb 3, 2012 at 1:39 PM, Brian Peschel bri...@occinc.com wrote: I have this geometric is a 1.3.3 PostGIS enabled database: st_npoints | st_astext +--- 3 | POLYGON((-97.288445 39.566748,-97.288188 39.566749,-97.288445 39.566748)) I used pg_dump to move this to a 1.4.0 PostGIS enabled database. And I get this: st_npoints 3 for the number of point, but trying to see the geom ERROR: geometry requires more points I don't see anything else in my psotgres logs. Any ideas? - Brian ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?
On 30/01/12 08:32, Sandro Santilli wrote: On Mon, Jan 30, 2012 at 07:40:01AM +0100, Stefan Keller wrote: 2012/1/27 Sandro Santillis...@keybit.net: On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: ... Am I missing something? A ticket on the trac system, most likely :) So you think it's not redundant to ticket #660? Oops, It would. Sorry! I've just committed this feature to SVN trunk as r9027. Unfortunately due to the difference in architecture, it's not going to be possible to backport to 1.5. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Rv: Postgis for Postgres 64 bits
Carlos, There is no official 64-bit Windows build of PostGIS (any version including 2.0) available due to build issues with mingw. You could try building it yourself with Visual Studio but you might be on your own. -bborie On 02/03/2012 11:45 AM, CARLOS MUÑOZ wrote: Great, For windows in 64 bits Its possible Postgis for Postgres? Thank you ;) Carlos J. Muñoz M. Student Master GIS - Mensaje reenviado - De: pcr...@pcreso.compcr...@pcreso.com Para: CARLOS MUÑOZcjmun...@yahoo.com; PostGIS Users Discussionpostgis-users@postgis.refractions.net Enviado: Viernes, 3 de febrero, 2012 14:37:30 Asunto: Re: [postgis-users] Postgis for Postgres 64 bits For Linux, it has been available for some years. If you need 64bit support, you might consider upgrading :-) Cheers Brent Wood --- On Sat, 2/4/12, CARLOS MUÑOZcjmun...@yahoo.com wrote: From: CARLOS MUÑOZcjmun...@yahoo.com Subject: [postgis-users] Postgis for Postgres 64 bits To: postgis-users@postgis.refractions.netpostgis-users@postgis.refractions.net Date: Saturday, February 4, 2012, 8:31 AM hello, When is Postgis for Postgres in 64 bits? Thank you Carlos J. Muñoz M. -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Rv: Postgis for Postgres 64 bits
What people are interested in seeing a 64-bit windows build of PostGIS and willing to pay for it? We've heard a lot of people mention it, but unfortunately as Bborie said, we've run into some build issues with getting GEOS and GDAL to compile so its not trivial. A lot of the pieces we do have compiling under mingw-64. I think the issues are not insurmountable, but will take a lot of our time and possibly time of other PostGIS devs to help us out which we'd have to fund. We were thinking of having a pledge drive similar to what Sandro had for topology to collect enough money to focus on the effort. Would people be interested in say putting up $100 each for that? If we get about 20-30 people willing to do that, I think we can jump over the mingw-64 hurdles and then later eventually have a VC++ native build. Perhaps even have some funds to package in pgrouting (for 32bit and 64-bit). We'd be willing to set aside time from our consulting work to work on it, if we could replace the lost consulting income. Would people be interested in it? As it stands I think mingw-64 is still the easiest since there are too many pieces of the PostGIS environment that assume a unix like toolchain. Once we have it working, we'd be willing to do the work of continually making the build available as we currently do with the 32-bit windows stack builder builds. Thanks, Regina and Leo http://www.postgis.us -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Bborie Park Sent: Friday, February 03, 2012 7:51 PM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Rv: Postgis for Postgres 64 bits Carlos, There is no official 64-bit Windows build of PostGIS (any version including 2.0) available due to build issues with mingw. You could try building it yourself with Visual Studio but you might be on your own. -bborie On 02/03/2012 11:45 AM, CARLOS MUÑOZ wrote: Great, For windows in 64 bits Its possible Postgis for Postgres? Thank you ;) Carlos J. Muñoz M. Student Master GIS - Mensaje reenviado - De: pcr...@pcreso.compcr...@pcreso.com Para: CARLOS MUÑOZcjmun...@yahoo.com; PostGIS Users Discussionpostgis-users@postgis.refractions.net Enviado: Viernes, 3 de febrero, 2012 14:37:30 Asunto: Re: [postgis-users] Postgis for Postgres 64 bits For Linux, it has been available for some years. If you need 64bit support, you might consider upgrading :-) Cheers Brent Wood --- On Sat, 2/4/12, CARLOS MUÑOZcjmun...@yahoo.com wrote: From: CARLOS MUÑOZcjmun...@yahoo.com Subject: [postgis-users] Postgis for Postgres 64 bits To: postgis-users@postgis.refractions.netpostgis-users@postgis.refract ions.net Date: Saturday, February 4, 2012, 8:31 AM hello, When is Postgis for Postgres in 64 bits? Thank you Carlos J. Muñoz M. -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users