Thread: administering connections to a database?

administering connections to a database?

From
"Andy Kriger"
Date:
I'm trying to use pg_dump to backup my database. But I'm getting a
permission denied with (even as postgres user). Is there a way to close all
connections to a specific database (without killing all connections to
postmaster, since there are other databases in use)? Or a way to find out
who is connected to the database?

thx