> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins
> Sent: Sunday, December 14, 2014 1:02 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Blocking access by remote users fo
o the change.
Scot Kreienkamp
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins
Sent: Sunday, December 14, 2014 1:02 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Blocking access by remote users
On Dec 13, 2014, at 10:38 PM, Michael Nolan wrote:
> Yeah, a cron job to swap pg_hba.conf files is the best solution I've come up
> with so far. It's not one web app, it's closer to two dozen of them, on
> multiple sites.
If they use persistent connections you'll also have to kill existin
On Sun, Dec 14, 2014 at 1:38 AM, Michael Nolan wrote:
>
> Yeah, a cron job to swap pg_hba.conf files is the best solution I've come
> up with so far. It's not one web app, it's closer to two dozen of them, on
> multiple sites.
>
Use time-based firewall rules to block them?
Yeah, a cron job to swap pg_hba.conf files is the best solution I've come
up with so far. It's not one web app, it's closer to two dozen of them, on
multiple sites.
--
Mike Nolan
On Sat, Dec 13, 2014 at 11:10 PM, Adrian Klaver
wrote:
>
> On 12/13/2014 08:13 PM, Michael Nolan wrote:
>
>> I have s
On 12/13/2014 08:13 PM, Michael Nolan wrote:
I have several web apps that access our Postgresql database that I'd
like to lock out of the database for about an hour during a weekly
maintenance interval. (There are some internal users that do not get
locked out, because they're running the mainten
Turn the app off? Seems that's one of the selling points of web apps. Throw up
a "under maint" page.
Sent from my iPhone
> On Dec 13, 2014, at 9:13 PM, Michael Nolan wrote:
>
> I have several web apps that access our Postgresql database that I'd like to
> lock out of the database for about
