postgres=# CREATE DATABASE pg93_postgis21_trac2985; CREATE DATABASE postgres=# postgres=# \c pg93_postgis21_trac2985 You are now connected to database "pg93_postgis21_trac2985" as user "deployment". pg93_postgis21_trac2985=# pg93_postgis21_trac2985=# CREATE EXTENSION postgis; CREATE EXTENSION pg93_postgis21_trac2985=# pg93_postgis21_trac2985=# SELECT version() || ' ' || postgis_full_version(); ?column? ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 9.3.5 on amd64-portbld-freebsd10.0, compiled by FreeBSD clang version 3.3 (tags/RELEASE_33/final 183502) 20130610, 64-bit POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.9.2" LIBJSON="UNKNOWN" RASTER (1 row) pg93_postgis21_trac2985=# create table foo(g geography(point,4326)); CREATE TABLE pg93_postgis21_trac2985=# insert into foo values(st_setsrid(st_makepoint(1.2, 19.8), 4326)); INSERT 0 1 pg93_postgis21_trac2985=# insert into foo values(st_setsrid(st_makepoint(1.3, 19.8), 4326)); INSERT 0 1 pg93_postgis21_trac2985=# analyze verbose foo; INFO: analyzing "public.foo" INFO: "foo": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows The connection to the server was lost. Attempting reset: WARNING: terminating connection because of crash of another server process 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. HINT: In a moment you should be able to reconnect to the database and repeat your command. Failed. !> pgsql.log shows Nov 5 11:17:34 bludgeon kernel: pid 37842 (postgres), uid 70: exited on signal 10 (core dumped) Nov 5 11:17:34 bludgeon postgres[15724]: [27-1] WARNING: terminating connection because of crash of another server process Nov 5 11:17:34 bludgeon postgres[15724]: [27-2] 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. Nov 5 11:17:34 bludgeon postgres[15724]: [27-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.