[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Fwd: [BUGS] Can we force fully disconnect all client connected to
From:       Gaurav K Srivastav <gauravgkp () gmail ! com>
Date:       2009-12-30 12:48:12
Message-ID: bf0617110912300436m5cc1fdbet71d1463e972fc7f9 () mail ! gmail ! com
[Download RAW message or body]

Sorry Craig,

I am using
PostgreSQL 8.3.8 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-10)
version. and in my case I have to drop database and recreate it without
stop/restart database server.while several client are also running on this
datbase server .As you told pg_terminate_backend() is for 8.4.
Can you please let me know the how I can do this task via shell script.

Guarav Kumar Srivastava

---------- Forwarded message ----------
From: Gaurav K Srivastav <gauravgkp@gmail.com>
Date: Wed, Dec 30, 2009 at 5:57 PM
Subject: Re: [BUGS] Can we force fully disconnect all client connected to
localhost:5432
To: Craig Ringer <craig@postnewspapers.com.au>


Hi Craig Ringer,
I am using
PostgreSQL 8.3.8 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-10)
version. and in my case I have to drop datbase and recreate it without
stop/restart database.while several client are also running on this datbase
server .As you told pg_terminate_backend() is for 8.4.
Can you please let me know the how I can do this task via shell script.

Guarav Kumar Srivastava

  On Wed, Dec 30, 2009 at 5:29 PM, Craig Ringer <craig@postnewspapers.com.au
> wrote:

> On 30/12/2009 2:02 PM, Gaurav K Srivastav wrote:
>
>> Hi,
>> Do we have any command to forcefully disconnet each client in postgres .
>> If we have please let me know.
>>
>
> In 8.4 there's pg_terminate_backend(). Prior versions don't have any truly
> safe method, though sending a SIGTERM to a backend is supposed to be
> somewhat safe.
>
> --
> Craig Ringer
>

[Attachment #3 (text/html)]

<div>Sorry Craig,</div>
<div>
<div> </div>
<div>I am using </div>
<div>PostgreSQL 8.3.8 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 \
20060404 (Red Hat 3.4.6-10)</div> <div>version. and in my case I have to drop \
database and recreate it without stop/restart database server.while several client \
are also running on this datbase server .As you told pg_terminate_backend() is for \
8.4.</div>

<div>Can you please let me know the how I can do this task via shell script.</div>
<div> </div>
<div>Guarav Kumar Srivastava<br><br></div></div>
<div class="gmail_quote">---------- Forwarded message ----------<br>From: <b \
class="gmail_sendername">Gaurav K Srivastav</b> <span dir="ltr">&lt;<a \
                href="mailto:gauravgkp@gmail.com">gauravgkp@gmail.com</a>&gt;</span><br>
                
Date: Wed, Dec 30, 2009 at 5:57 PM<br>Subject: Re: [BUGS] Can we force fully \
disconnect all client connected to localhost:5432<br>To: Craig Ringer &lt;<a \
href="mailto:craig@postnewspapers.com.au">craig@postnewspapers.com.au</a>&gt;<br> \
<br><br> <div>Hi Craig Ringer,</div>
<div>I am using </div>
<div>PostgreSQL 8.3.8 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 \
20060404 (Red Hat 3.4.6-10)</div> <div>version. and in my case I have to drop datbase \
and recreate it without stop/restart database.while several client are also running \
on this datbase server .As you told pg_terminate_backend() is for 8.4.</div> <div>Can \
you please let me know the how I can do this task via shell script.</div> <div> \
</div> <div>Guarav Kumar Srivastava<br><br></div>
<div>
<div></div>
<div class="h5">
<div class="gmail_quote">On Wed, Dec 30, 2009 at 5:29 PM, Craig Ringer <span \
dir="ltr">&lt;<a href="mailto:craig@postnewspapers.com.au" \
target="_blank">craig@postnewspapers.com.au</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: \
#ccc 1px solid"> <div>On 30/12/2009 2:02 PM, Gaurav K Srivastav wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; \
BORDER-LEFT: #ccc 1px solid">Hi,<br>Do we have any command to forcefully disconnet \
each client in postgres .<br>If we have please let me know.<br> \
</blockquote><br></div>In 8.4 there&#39;s pg_terminate_backend(). Prior versions \
don&#39;t have any truly safe method, though sending a SIGTERM to a backend is \
supposed to be somewhat safe.<br><br>--<br><font color="#888888">Craig Ringer<br> \
</font></blockquote></div><br></div></div></div><br>



[prev in list] [next in list] [prev in thread] [next in thread]