Blocking access by remote users for a specific time period

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Blocking access by remote users for a specific time period
Date: 2014-12-14 04:13:32
Message-ID: CAOzAquJ8ot+fPtL2OX=cMjgNtn2ks6UE_7B2cEHAXWWQh3tSEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2014-12-14 04:45:29 Re: Blocking access by remote users for a specific time period
Previous Message wetter wetterana 2014-12-14 04:03:39 Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac