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