Re: "template0" is not currently accepting conn - Mailing list pgadmin-support

From Dave Page
Subject Re: "template0" is not currently accepting conn
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00C86@dogbert.vale-housing.co.uk
Whole thread Raw
List pgadmin-support

> -----Original Message-----
> From: Chris Lee [mailto:Chrislee@centurycity.com.hk]
> Sent: 14 November 2001 08:07
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] "template0" is not currently
> accepting connections
>
>
> Dear All,
>
> Sometimes, I got the following error at log when using pgAdminII.
>
> FATAL 1:  Database "template0" is not currently accepting connections

pgAdmin attempts to connect to all databases it finds when you open the
Databases collection node (as you've recently found :-) ). template0 never
accepts connections from users so the attempt fails. pgAdmin/pgSchema detect
this and mark the database as innaccessible (hence the red cross through the
icon). This will also occur if pg_hba.conf prevents you from connecting.

There is a *slightly* cleaner way to do this - I'll add it to the To-Do
list.

Regards, Dave.

pgadmin-support by date:

Previous
From: Chris Lee
Date:
Subject: "template0" is not currently accepting connections
Next
From: "Erkelens, Erik HDi"
Date:
Subject: cannot drop a trigger