From: Bruce Momjian <bruce@momjian.us>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: ALEXANDER JOSE <aangelj@hotmail.com>
Cc: postgres admin <pgsql-admin@postgresql.org>
Subject: Re: block a database
Date: Wed, 14 Apr 2010 20:12:56 -0400 (EDT)
Message-ID: <201004150012.o3F0CvR10337@momjian.us> (raw)
In-Reply-To: <4BBDFCA10200002500030604@gw.wicourts.gov>
Kevin Grittner wrote:
> ALEXANDER JOSE <aangelj@hotmail.com> wrote:
>
> > As I can block a database so users can not connect without
> > affecting the other databases.
>
> You probably want to use the pg_hba.conf file:
>
> http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html
or:
ALTER DATABASE ... CONNECTION LIMIT connlimit
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, Kevin.Grittner@wicourts.gov, aangelj@hotmail.com
Subject: Re: block a database
In-Reply-To: <201004150012.o3F0CvR10337@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox