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@mhs.mphasis.com
> ---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@mphasis.com 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.
