Search code examples
postgresqlpostgispostgres-xl

PostGIS extension on Postgres-xl

I'm trying to deploy a PostGIS cluster using Postgres-XL on AWS, for this I have the next architecture:

SO: ubuntu
1 GTM (172.31.45.190)
1 Coordinator (172.31.45.191)
2 Datanodes (172.31.45.192 and 172.31.45.193)

I had my cluster running but I can't manage to make PostGIS work, I tried the installation with sudo apt-get install postgis but when I try to create the extension inside my db (CREATE EXTENSION postgis;) I got the next error:

ERROR:  could not open extension control file "/usr/local/pgsql/share/extension/postgis.control": No such file or directory

The postgis.control file installed by apt-get is in: "/usr/share/postgresql/9.5/extension/postgis.control" so I think is just a problem with the paths but I'm a little lost on that configuration

Thank you in advance for any help!

Solution

  • In case anyone is running in this issue, I solved following this steps:

    1. Install Postgres-xl and PostGIS dependencies to compile (Be sure to install the package postgresql-server-dev-9.5 in this step, otherwise it's going to brake your postgres-xl installation)
    2. Build and install Postgres-XL with ./configure -prefix=/usr/lib/postgresql/9.5
    3. Build and install PostGIS
    4. Start your cluster