HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

RDS raising unwanted PostGIS NOTICEs

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
noticesraisingpostgisunwantedrds

Problem

I have an Amazon RDS instance that is producing unwanted NOTICEs.

I have never seen this behaviour before.

mydb=> select current_setting('client_min_messages');
 current_setting 
-----------------
 notice
(1 row)


Now, if I ask for geometry column... I get the NOTICEs:

mydb=> SELECT id, ST_AsText(geom) FROM mytable limit 1;

NOTICE:  [lwgeom_ogc.c:LWGEOM_asText:833] Called.
NOTICE:  [g_serialized.c:gserialized_get_type:50] entered
NOTICE:  [g_serialized.c:lwgeom_from_gserialized:1137] Got type 1 (Point), srid=4326
NOTICE:  [g_serialized.c:lwgeom_from_gserialized_buffer:1091] Got type 1 (Point), hasz=0 hasm=0 geodetic=0 hasbox=0
NOTICE:  [g_serialized.c:gserialized_get_type:50] entered
NOTICE:  [lwgeom.c:lwgeom_set_srid:1455] entered with srid=4326
NOTICE:  [lwout_wkt.c:lwgeom_to_wkt_sb:590] lwgeom_to_wkt_sb: type Point, hasz 1, hasm 0
NOTICE:  [lwgeom_ogc.c:LWGEOM_asText:841] WKT size = 33, WKT length = 32
  id   |            st_astext             
-------+----------------------------------
 12445 | POINT(-119.67608831 48.15767852)
(1 row)


Setting client_min_messages up one level will suppress then, but then it obviously spoils NOTICEs for all.

mydb=> SET client_min_messages=WARNING;
SET
mydb=> SELECT id, ST_AsText(geom) FROM mytable limit 1;
  id   |            st_astext             
-------+----------------------------------
 12445 | POINT(-119.67608831 48.15767852)
(1 row)


What's going on here? My local and custom installed versions of Postgres never acted this way.

Update: This seems to be isolated to Postgres 9.4.4 - 9.4.1 does not raise these.

Solution

We had the same problem with our RDS instances for a stretch of a week, but AWS support patched it on Sept 16. Now all RDS instances we launch with postgres 9.4.4 have functional and normal-logging postgis 2.1.5 on them. Your instances should be working as expected now too.

Context

StackExchange Database Administrators Q#112790, answer score: 2

Revisions (0)

No revisions yet.