Use a remote PostGIS server

[lucduron]

Dear developers,

I tried to configure Mascaret plugin to a remote PostGIS server (server and client are not on the same machine). I managed to connect it to QGIS but I am facing this error at the creation of the database tables with Mascaret:

Moreover is there a specific reason why the username has to be to postgres? It would be interesting to determine it from the authentication input parameters instead of being hardcoded.

Could it be possible to support spatialite, which is lighter and easier to use on a PC? The database consists indeed in a portable standalone file and it does not rely on a client-server principle. SQL queries and python bindings are probably similar between both RDBMS.

Thank you in advance for your help.
Luc

[lucduron]

Is there a document/file describing the database structure and which tools is modifying what that you could provide us?
I generated quickly an entity–relationship model of the database and I attached it here, if it can be usefull for other users.

[ccoulet]

Dear developers,

I tried to configure Mascaret plugin to a remote PostGIS server (server and client are not on the same machine). I managed to connect it to QGIS but I am facing this error at the creation of the database tables with Mascaret:

Moreover is there a specific reason why the username has to be to postgres? It would be interesting to determine it from the authentication input parameters instead of being hardcoded.

Could it be possible to support spatialite, which is lighter and easier to use on a PC? The database consists indeed in a portable standalone file and it does not rely on a client-server principle. SQL queries and python bindings are probably similar between both RDBMS.

Thank you in advance for your help.
Luc

Hi Luc
On this specific point we worked recently on this subject for another purpose and we solved some issues which are probably related to the encountered problem.
Maybe you could try again with latest version 3.1.0

Regards

[ccoulet]

On the documentation of the data structure, there is nothing existing for the moment.
We will think to add such information on the wiki (at least a view of the model like you shown )