Re: block a database - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: block a database
Date
Msg-id 201004150012.o3F0CvR10337@momjian.us
Whole thread Raw
In response to Re: block a database  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Vitaly Burshteyn"
Date:
Subject: Re: amazon ec2
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL with SSL