The best way is to turn on logs (logging connections and disconnetciona). but you can also check it from database just check the pg_stat_activity table. Naomi Walker-3 wrote: > > I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris > 10 OS), but someone is connected to > the database. What is the best way to find out exactly who is connected? > > Thanks, > Naomi > > -- > ------------------------------------------------------------------------ > Naomi Walker Chief Information Officer > Mphasis Healthcare Solutions nwalker@xxxxxxxxxxxxxxx > ---An EDS Company 602-604-3100 > ------------------------------------------------------------------------ > "Intellectuals solve problems; geniuses prevent them." > -- Albert Einstein > ------------------------------------------------------------------------ > > -- CONFIDENTIALITY NOTICE -- > > Information transmitted by this e-mail is proprietary to MphasiS and/or > its Customers and is intended for use only by the individual or entity to > which it is addressed, and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If you are > not the intended recipient or it appears that this e-mail has been > forwarded to you without proper authority, you are notified that any use > or dissemination of this information in any manner is strictly prohibited. > In such cases, please notify us immediately at mailmaster@xxxxxxxxxxx and > delete this mail from your records. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > -- View this message in context: http://www.nabble.com/Find-who-is-connected-to-a-database-tf4700115.html#a13452689 Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
