administering connections to a database?

Started by Andy Krigerabout 23 years ago1 messagesgeneral
Jump to latest
#1Andy Kriger
akriger@greaterthanone.com

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