Re: connection timeouts and "killing" users

OK, killing the remote users is fine. Just want ot make sure I'm not
killing some sort of shared remote server process(es) that would prevent
future remotes to connect.

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Thursday, September 11, 2008 5:35 PM
To: Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] connection timeouts and "killing" users

On Thu, Sep 11, 2008 at 2:27 PM, Gauthier, Dave
<dave(dot)gauthier(at)intel(dot)com> wrote:
>
> How do I get the pids? Is there something specific I should look for
in the
> executable name I can see in "ps"?

You can either use a combination of ps and grep:

ps ax|grep postgres|grep dbname

or use the pg_stat_activity table;

> Will I break any remote server processes which are handeling remote
> attaches if I do this?

Yes, they would lose their connection. It's a choice you don't have
anymore if you're renaming databases underneath them.