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

Re: psql: FATAL: database "template1" is not currently accepting

From
stig erikson
Date:
stig erikson wrote:
> 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


my main concern is with pg_dumpall.

pg_dumpall: could not connect to database "template1": FATAL:  database
"template1" is not currently accepting connections


postgresql 7.4.8