pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Find who is connected to a database
3+ messages / 3 participants
[nested] [flat]

* Find who is connected to a database
@ 2007-10-26 22:25 Naomi Walker <nwalker@mhs.mphasis.com>
  2007-10-28 12:04 ` Re: Find who is connected to a database rski <robertski@o2.pl>
  2007-10-31 14:42 ` Re: Find who is connected to a database Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Naomi Walker @ 2007-10-26 22:25 UTC (permalink / raw)
  To: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Find who is connected to a database
  2007-10-26 22:25 Find who is connected to a database Naomi Walker <nwalker@mhs.mphasis.com>
@ 2007-10-28 12:04 ` rski <robertski@o2.pl>
  1 sibling, 0 replies; 3+ messages in thread

From: rski @ 2007-10-28 12:04 UTC (permalink / raw)
  To: pgsql-admin


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.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Find who is connected to a database
  2007-10-26 22:25 Find who is connected to a database Naomi Walker <nwalker@mhs.mphasis.com>
@ 2007-10-31 14:42 ` Scott Marlowe <scott.marlowe@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2007-10-31 14:42 UTC (permalink / raw)
  To: Naomi Walker <nwalker@mhs.mphasis.com>; +Cc: pgsql-admin

On 10/26/07, Naomi Walker <nwalker@mhs.mphasis.com> 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?

select * from pg_stat_activity;



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-10-31 14:42 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-26 22:25 Find who is connected to a database Naomi Walker <nwalker@mhs.mphasis.com>
2007-10-28 12:04 ` rski <robertski@o2.pl>
2007-10-31 14:42 ` Scott Marlowe <scott.marlowe@gmail.com>

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