Thread: psql: FATAL: database "template1" is not currently accepting connections

when i try to do:

psql -l
psql: FATAL:  database "template1" is not currently accepting connections


but if i first connect to some other database, ie:
psql -d database
\l

then it shows all the databases.


how can i resolve the issu with template1?

the problem might have been coused by a client that hang and was closed with
kill -9. the database has been restarted and there are no active connections
hanging around.


/stig

On Fri, Jun 17, 2005 at 09:19:30AM +0200, stig erikson wrote:
>
> psql -l
> psql: FATAL:  database "template1" is not currently accepting connections

Did somebody set datallowconn to false for template1?  If you connect
to another database, what's the output of the following query?

SELECT datname, datallowconn FROM pg_database;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/