Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Who's attac...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 12 Topic 5118 of 5549
Post > Topic >>

Re: Who's attached to the database?

by lennin.caro@[EMAIL PROTECTED] (Lennin Caro) Jul 4, 2008 at 06:50 AM

try this

select pg_cancel_backend(<processid_db>);

if the command not work kill the process in os

kill -9 proccessid_os



--- On Thu, 7/3/08, Carol Walter <walterc@[EMAIL PROTECTED]
> wrote:

> From: Carol Walter <walterc@[EMAIL PROTECTED]
>
> Subject: Re: [ADMIN] Who's attached to the database?
> To: "Kevin Grittner" <Kevin.Grittner@[EMAIL PROTECTED]
>
> Cc: pgsql-admin@[EMAIL PROTECTED]
> Date: Thursday, July 3, 2008, 8:07 PM
> Thanks, guys,
> 
> This told me that the user that has it open is the
> interface user  
> called db_user.  Is there a command to disconnect this
> user?
> 
> Carol
> 
> On Jul 3, 2008, at 3:53 PM, Kevin Grittner wrote:
> 
> >>>> Carol Walter <walterc@[EMAIL PROTECTED]
>
> wrote:
> >> I'm trying to drop a database and I'm
> getting an error that says that
> >
> >> the database is being accessed by other users.  Is
> there a way I can
> >
> >> find out who these users are or if there really is
> a user accessing
> > it?
> >
> > select * from pg_stat_activity where datname =
> 'yourdb';
> >
> > -Kevin
> 
> 
> -- 
> Sent via pgsql-admin mailing list
> (pgsql-admin@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


      


-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 12 Posts in Topic:
Who's attached to the database?
walterc@[EMAIL PROTECTED]  2008-07-03 15:45:45 
Re: Who's attached to the database?
Kevin.Grittner@[EMAIL PRO  2008-07-03 14:53:57 
Re: Who's attached to the database?
walterc@[EMAIL PROTECTED]  2008-07-03 16:07:23 
Re: Who's attached to the database?
walterc@[EMAIL PROTECTED]  2008-07-03 17:23:50 
Re: Who's attached to the database?
banderson@[EMAIL PROTECTE  2008-07-03 14:17:30 
Re: Who's attached to the database?
lennin.caro@[EMAIL PROTEC  2008-07-04 06:50:43 
Re: Who's attached to the database?
postgresql@[EMAIL PROTECT  2008-07-04 18:41:02 
Re: Who's attached to the database?
tgl@[EMAIL PROTECTED] (T  2008-07-03 15:54:25 
Re: Who's attached to the database?
jeff@[EMAIL PROTECTED] (  2008-07-03 12:55:14 
Re: Who's attached to the database?
pawel.socha@[EMAIL PROTEC  2008-07-03 21:55:41 
Re: Who's attached to the database?
Kevin.Grittner@[EMAIL PRO  2008-07-03 17:04:11 
Re: Who's attached to the database?
lennin.caro@[EMAIL PROTEC  2008-07-04 06:47:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 17:10:07 CST 2008.