patternsqlMinor
RDS raising unwanted PostGIS NOTICEs
Viewed 0 times
noticesraisingpostgisunwantedrds
Problem
I have an Amazon RDS instance that is producing unwanted
I have never seen this behaviour before.
Now, if I ask for geometry column... I get the
Setting
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.
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.