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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
