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.marlowe@gmail.com]
Sent: Thursday, September 11, 2008 5:35 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] connection timeouts and "killing" users
On Thu, Sep 11, 2008 at 2:27 PM, Gauthier, Dave
<dave.gauthier@intel.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.