From: rski <robertski@o2.pl>
To: pgsql-admin@postgresql.org
Subject: Re: Find who is connected to a database
Date: Sun, 28 Oct 2007 05:04:12 -0700 (PDT)
Message-ID: <13452689.post@talk.nabble.com> (raw)
In-Reply-To: <4722694D.3050109@mhs.mphasis.com>
References: <4722694D.3050109@mhs.mphasis.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robertski@o2.pl
Subject: Re: Find who is connected to a database
In-Reply-To: <13452689.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox