[postgis-tickets] [PostGIS] #2985: server crash when analyzing small tables

[PostGIS]

#2985: server crash when analyzing small tables
-----------------------+------------------------------------------
  Reporter:  nkiraly   |      Owner:  pramsey
      Type:  defect    |     Status:  closed
  Priority:  critical  |  Milestone:  PostGIS 2.2.3
 Component:  postgis   |    Version:  2.2.x
Resolution:  fixed     |   Keywords:  analyze server crash freebsd
-----------------------+------------------------------------------

Comment (by robe):

 No I wasn't using the ports source files. What I did was this exactly.


 {{{
 sudo bash
 freebsd-update fetch
 freebsd-update install
 #to get PostGIS and PostgreSQL for binary ports
 pkg install postgresql93-server postgresql93-contrib
 sysrc postgresql_enable=yes
 service postgresql initdb
 service postgresql start
 pkg install postgis (this gave me PostGIS 2.1.7 which consistently
 crashed)

 ## to install PostGIS from source
 pkg install subversion
 pkg install autoconf automake libtool git gmake wget libxslt
 pkg install gdal geos #this got already installed if I did postgis install
 first from ports
 }}}

 To compile PostGIS 2.2.2

 {{{
 wget http://download.osgeo.org/postgis/source/postgis-2.2.2.tar.gz
 tar -xvzf postgis-2.2.2.tar.gz
 cd postgis-2.2.2
 #apply patch from r15130
 #apply patch from r15135

 ./configure
 make
 make install
 }}}

 This gave me a perfectly nice PostGIS 2.2.2 in my PostgreSQL 9.3
 Which I installed this way

 {{{
 psql -U pgsql -d postgres
 CREATE DATABASE postgis222;
 \connect postgis222
 CREATE EXTENSION postgis VERSION "2.2.2";
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2985#comment:35>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.