[Qgis-user] Database Manager and service configuration

[Andreas Neumann]

Hi Giuseppe,

This is much appreciated - thanks!

Let me know when I can test something.

Andreas

On 02/18/2012 04:51 PM, Giuseppe Sucameli wrote:
> Hi Andreas,
> 
> On Thu, Feb 16, 2012 at 5:59 PM, Andreas Neumann <a.neumann at carto.net> wrote:
>> 1.
>> One issue I have is that opening db-manager takes 1-2 minutes (on a
>> rather fast machine). Why is it taking so long to open the connnection?
>> In main QGIS the connection opens quickly. My db has hundreds of spatial
>> tables and views in about 50 schemas. Is it scanning all schemas and
>> tables at the initial connection?
> 
> I'm noticing the same, it's slow when the db has a lot of tables.
> I'm going deep inside the problem, I hope to fix it soon.
> 
>> 2.
>> I get an error message after the connection:
>> -------------------
>> Error:
>> database "an" does not exist
>> Query:
>> SELECT has_database_privilege('an', 'CREATE'),
>> has_database_privilege('an', 'TEMP')
>> -------------------
>>
>> Why is it looking for a database named after the user connecting to the db?
> 
> Because DBManager is trying to display information about the database
> (permissions), but you have no dbname as you're using a service to
> connect to it.
> 
> Tickets opened for both the problems ([1] and [2]),
> Regards.
> 
> [1] http://hub.qgis.org/issues/5044
> [2] http://hub.qgis.org/issues/5045
>