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
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
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
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
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
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