Re: [GENERAL] connection timeouts and "killing" users

2008-09-12 Thread Erik Jones
On Sep 11, 2008, at 12:02 PM, Scott Marlowe wrote: I don't think so. What might work best is to have two pg_hba.conf files, and link to each one. so one is pg_hba.conf.lockout and one is pg_hba.conf.normal, let's say. lockout is set to only answer to the postgres user. Switch the pg_hba.co

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
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 > ex

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Scott Marlowe
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_acti

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
andeling remote attaches if I do this? -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 3:03 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] connection timeouts and "killing" users On Thu, Sep 11, 2

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Scott Marlowe
On Thu, Sep 11, 2008 at 10:42 AM, Gauthier, Dave <[EMAIL PROTECTED]> wrote: > Hi: > > > > Here's the problem... > > > > I have a read-only DB that gets reloaded from scratch every night. This > takes several hours and I don't want any late night users to have to wait > for this process to complet

[GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
Hi: Here's the problem... I have a read-only DB that gets reloaded from scratch every night. This takes several hours and I don't want any late night users to have to wait for this process to complete, so I have 2 DBs. The first DB is the one the users access. Call it "main_db". I load