0

I’m trying to connect my database postgresql/postgis to mapguide maestro but it send me a error message.

Do you have some idea about this, or can you help me about how can I connect it with my database postgis? I’m using postgresql 9.4, mapguide open source 2.6.1 and mapguide maestro 6.0

enter image description here

Tom-db
  • 6,528
  • 3
  • 30
  • 44
welliam
  • 13
  • 4
  • 1
    Probably you just have to create the POSTGIS extension in the database: `CREATE EXTENSION postgis;` – Tom-db Feb 16 '16 at 15:43
  • what?? can you explain me? – welliam Feb 16 '16 at 16:00
  • Connect to your database with a client (in example psql) and execute the command above – Tom-db Feb 16 '16 at 16:02
  • yes i'm doing it but it can't compiled !!! have you use mapguide maestro? – welliam Feb 16 '16 at 16:18
  • Use [psql](http://www.postgresql.org/docs/current/static/app-psql.html) to connect to a PostgreSql database. Maybe a online tutorial can be useful for you: http://www.postgresqltutorial.com/ – Tom-db Feb 16 '16 at 16:44

1 Answers1

1

You are probably connecting to a PostgreSQL database without PostGIS installed.

Either install PostGIS to that database (e.g. CREATE EXTENSION postgis), or modify your connection settings to the correct host/port/dbname with an existing PostGIS installation.

Mike T
  • 41,085
  • 18
  • 152
  • 203
  • excuse me but i have installed the postgis extension – welliam Feb 17 '16 at 13:27
  • @welliam a database enabled with postgis has `geometry_columns` but the error message says it not there (assuming that it was installed in a schema in your `search_path`, usually `public`). You might have installed it to one database and are connecting to another. – Mike T Feb 17 '16 at 17:34