Thread: template Database

template Database

From
"Bob T"
Date:
Yeah, I am using template1..
I notice the error....
FATAL 1:  Database "template0" is not currently accepting connections
 
only when using pgAdmin II not  when using psql terminal..
The circumstance occurs when you first mouse click the Databases container. After the container is chosen it then has a plus sign next to it
and by clicking on the plus you can see the individual databases.
 If at any time I click on the primary container (Databases) I will get the
above error as pgAdmin II attempts to open all datesbases including template0.
 
Anyone else using pgAdimin II experience this behavior..
 
Bob T

Re: template Database

From
Tom Lane
Date:
"Bob T" <rjtalbo@attglobal.net> writes:
> I notice the error....
> FATAL 1:  Database "template0" is not currently accepting connections

> only when using pgAdmin II not  when using psql terminal..
> The circumstance occurs when you first mouse click the Databases container.=
>  After the container is chosen it then has a plus sign next to it
> and by clicking on the plus you can see the individual databases.
>  If at any time I click on the primary container (Databases) I will get the
> above error as pgAdmin II attempts to open all datesbases including templat=
> e0.

This is evidently a bug in pgAdmin II --- it should ignore pg_database
entries that are marked not datallowconn.

            regards, tom lane

Re: [INTERFACES] template Database

From
"Dave Page"
Date:
Tom Lane allegedly said:
> "Bob T" <rjtalbo@attglobal.net> writes:
>> I notice the error....
>> FATAL 1:  Database "template0" is not currently accepting connections
>
>> only when using pgAdmin II not  when using psql terminal..
>> The circumstance occurs when you first mouse click the Databases
>> container.=
>>  After the container is chosen it then has a plus sign next to it
>> and by clicking on the plus you can see the individual databases.
>>  If at any time I click on the primary container (Databases) I will
>>  get the
>> above error as pgAdmin II attempts to open all datesbases including
>> templat= e0.
>
> This is evidently a bug in pgAdmin II --- it should ignore pg_database
> entries that are marked not datallowconn.

The CVS code does as of earlier this afternoon. This code was originally
written with 7.0 when (iirc) the datallowconn column didn't exist.

Regards, Dave.