Re: Blocking access by remote users for a specific time period

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Michael Nolan <htfoot(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Blocking access by remote users for a specific time period
Date: 2014-12-14 04:45:29
Message-ID: 696201F8-B5CB-45C5-944F-D68C3A7FCB70@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <htfoot(at)gmail(dot)com> 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 maintenance tasks.)
>
> There are no time-of-day access limitation parameters in the pg_hba.conf file, are there any simple ways to do this?
> --
> Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-12-14 05:10:18 Re: Blocking access by remote users for a specific time period
Previous Message Michael Nolan 2014-12-14 04:13:32 Blocking access by remote users for a specific time period