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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
