Re: template Database - Mailing list pgsql-general

From Tom Lane
Subject Re: template Database
Date
Msg-id 21103.1014651518@sss.pgh.pa.us
Whole thread Raw
In response to template Database  ("Bob T" <rjtalbo@attglobal.net>)
Responses Re: [INTERFACES] template Database  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Robert Treat"
Date:
Subject: Re: How do I make a query return all table names?
Next
From: Doug McNaught
Date:
Subject: Re: Backup & Restore