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

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>
To: Michael Nolan <htfoot@gmail.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2014-12-14T04:45:29Z
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@gmail.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