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:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: backup server - how to disconnect
Date: 2008-10-15 21:48:18
Message-ID: 48F66522.4000104@dbseller.com.br (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all,

Sorry, but I found a little bug in the command line...

To solve just replace "$i" for "$pid":

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

Sorry... :-)

Fabrízio de Royes Mello escreveu:
> 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.
> 

Cordialmente,

-- 
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

pgsql-admin by date

Next:From: Bruce MomjianDate: 2008-10-16 02:17:58
Subject: Re: postgres seems to ignore log_min_duration_statement
Previous:From: Fabrízio de Royes MelloDate: 2008-10-15 21:25:20
Subject: Re: backup server - how to disconnect

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