We are trying to setup a managed database to be used as a datasource for QGIS a Spatial GUI for Geologic data.
We manage to setup a database on a droplet under linux and installed postgres manually. On that system we get very good results. We can connect and import data from different sources to the database through the GUI.
We want to have a managed database in production. But we haven’t bean able to get a smooth running service in place.
The errors start when trying to import data. Since QGIS is open source it uses GDAL library to do this.
Our approach to narrow down the error was as follows. We used the tool ogr2ogr to achieve more verbose error output while doing the import.
with this command line tool we where able to import the data into the managed postgres cluster. But!!
We no are not able to access the data through pgadmin4
We get the following error message when trying to select through the imported table:
The application has lost the database connection: ⁃ If the connection was idle it may have been forcibly disconnected. ⁃ The application server or database server may have been restarted. ⁃ The user session may have timed out. Do you want to continue and establish a new session
Even though the application has not lost the connection.
When I write a custom select where I do not query for the geom column it will go through. If I then add the geom column to my query it will work properly.
My guess is that there is something not entirely enabled for the user trying to access the database.
With the postgis extension only working half way through this service is not an option for us.