itney <[EMAIL PROTECTED]>
Subject: [ADMIN] Stop connections to a specific database
To: pgsql-admin@postgresql.org
Date: Friday, July 18, 2008, 10:07 AM
I'm migrating a pg server (v 8.1.4) this weekend, and I have 2 dbs left on
it. One cannot be shut down until tomorrow. The last remaining o
>>> "Scott Whitney" <[EMAIL PROTECTED]> wrote:
> I just want to stop connections to this
> one particular database.
>
> Is there a simple, preferred method for doing so?
It sounds like pg_hba.conf might be your ticket:
http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html
-
I'm migrating a pg server (v 8.1.4) this weekend, and I have 2 dbs left on
it. One cannot be shut down until tomorrow. The last remaining one, I can
migrate today.
However, the software that talks to it is somewhat "hinky" and has several
places that connect -- there is no overall consolidated con