how do you kill the process?
Regards,
Guido
> > Thanks for ur reply...
> Actually I can set the tcpipsocket option in postgresql.conf file to false. This
> will block all further remote connection to my server. But what will happen to
> already existing remote connection? I want to disconnect this also .. �
>
> Sorry I can't change the firewall settings...
>
> Regards
> Srini
>
> On Fri, 20 Aug 2004 Olivier Hubaut wrote :
> >On 20 Aug 2004 12:05:47 -0000, bala srini <[EMAIL PROTECTED]> wrote:
> >
> >>Hi
> >> �I want to disconnect all already established REMOTE DB connections from the
> >> server without restarting the Postmaster daemon. Requirement is that diconnect
> >> should be done from the server side. Actually I tried to kill the corresponding
> >> process(Remote Db connection) in the server. But server is automatically
> >> respawning the connection. Can you please help me out in this?
> >>
> >>Regards
> >>Srini.
> >>
> >In fact, I think it's not the server that respawn the connection but simply the
> >client that make a new connection when it goes disconnected. Can't you use any
> >firewall to simply block remote connection on the postmaster host (or simply on
> >the 5432 port)?
> >
> >
> >-- Downloading signature ... 99%
> >*CRC FAILED*
> >signature aborted
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
