Skip site navigation (1) Skip section navigation (2)

Re: backup server - how to disconnect

From: Fabrízio de Royes Mello <fmello(at)dbseller(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: backup server - how to disconnect
Date: 2008-10-15 21:25:20
Message-ID: 48F65FC0.4040000@dbseller.com.br (view raw or flat)
Thread:
Lists: pgsql-admin
Hello Mark,

I don't know a command in postgres to do that, but if you're running 
postgres on Linux try it on the command line:

for pid in `psql -A -t -c "select procpid from pg_stat_activity"`; do 
pg_ctl kill TERM $i; done


Best regards.

Ps: Sorry, but my english isn't so good.

-- 
Fabrízio de Royes Mello
Coordenador Desenvolvimento de Software
fmello(at)dbseller(dot)com(dot)br
DBSeller Informática Ltda. - http://www.dbseller.com.br
(51) 3076-5101

In response to

Responses

pgsql-admin by date

Next:From: Fabrízio de Royes MelloDate: 2008-10-15 21:48:18
Subject: Re: backup server - how to disconnect
Previous:From: Emmanuel BERTHOULEDate: 2008-10-15 20:10:24
Subject: Re: backup server - how to disconnect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group