pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (3+ messages)  latest in thread

Message-ID: <13452689.post@talk.nabble.com>
Permalink:  ../13452689.post@talk.nabble.com/
Also on:    postgresql.org/message-id/13452689.post@talk.nabble.com

 · 

reply

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