Re: "template0" is not currently accepting conn

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Chris Lee'" <Chrislee(at)centurycity(dot)com(dot)hk>, pgadmin-support(at)postgresql(dot)org
Subject: Re: "template0" is not currently accepting conn
Date: 2001-11-14 08:35:00
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00C86@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Chris Lee [mailto:Chrislee(at)centurycity(dot)com(dot)hk]
> Sent: 14 November 2001 08:07
> To: pgadmin-support(at)postgresql(dot)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.

Browse pgadmin-support by date

  From Date Subject
Next Message Erkelens, Erik HDi 2001-11-14 20:16:46 cannot drop a trigger
Previous Message Chris Lee 2001-11-14 08:07:01 "template0" is not currently accepting connections