#81 Compatibility issue when trying to install PostGres-XL with PostGis

[Kaxil Naik]

We get the following issue while trying to install PostGis 2.3.2 with Postgres-xl-9.5r1.5:

Our Setup with 3 Nodes using pgxc_ctl:
Node 1: GTM
Node 2: Coordinator
Node 3: Data Node

postgres=# \c gis2.3.2
You are now connected to database "gis2.3.2" as user "postgres".
gis2.3.2=# CREATE EXTENSION postgis;
ERROR:  type "gidx" does not exist
CONTEXT:  SQL statement "CREATE OPERATOR && (
  LEFTARG    = gidx,
  RIGHTARG   = geography,
  PROCEDURE  = overlaps_geog,
  COMMUTATOR = &&
)"
PL/pgSQL function inline_code_block line 8 at SQL statement

When we try to run CREATE EXTENSION postgis; as above on the coordinator node, if get the above error message.

We then tried to install the extension using the PostGis 2.3.1 which worked perfectly well.

So I don't know why Postgres-xl-9.5r1.5 is not compatible with PostGis 2.3.2 but would be good to know the reason or how we can fix this ??

Thanks.

[Pavan Deolasee]

Can you please attach server logs from coordinator and datanode?

The way extensions are created in XL is by sending "CREATE EXTENSION" command to all nodes. The coordinator makes sure that none of the DDLs are sent down to the remote nodes, but if there are DMLs (such as a SELECT query or an anonymous block) that are dependent on the objects created by the extension, that can cause problems since those objects may not exist yet on the datanodes. I wonder if something changed in that area between 2.3.1 and 2.3.2. Can you please check? I don't have a PostGIS ready to test here.

Thanks,
Pavan