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

From: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: psql: FATAL: database "template1" is not currently accepting connections
Date: 2005-06-17 07:19:30
Message-ID: d8tti8$14un$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stig erikson 2005-06-17 07:30:51 Re: psql: FATAL: database "template1" is not currently accepting
Previous Message Hans-Jürgen Schönig 2005-06-17 07:16:16 Re: Autovacuum in the backend