[QGIS-Developer] postgis connection to server instead of individual databases?

[Andreas Neumann]

Hi,

I agree that it would be desirable that all available DBs would be 
listed. As to services: the pg_service.conf file also contains several 
entries, so it would also be possible to list all available service 
configurations.

Just a wish: if we go this route, please, please, don't open all DBs at 
once. Just list the available DBs, let the user choose one of the 
available ones and then open only the DB the user is interested in. 
Otherwise it would be a performance issue. We have DBs with serveral 
hundred tables, sometimes > 1000. If they would be opened all at once, 
it would be really slow.

Andreas

On 27.01.2018 12:19, Paolo Cavallini wrote:
> Il 27/01/2018 10:05, Raymond Nijssen ha scritto:
>
>> It would be very handy if QGIS could remember, for example, my
>> localhost-postgres:postgres connection and update the available
>> databases for me.
>>
>> Would that be possible? (Or is it but am I doing something wrong here?)
> agreed, I always wondered why we chose this approach. Of course, to use
> services we have to ave single connections to individual DBs.
> All the best.
>