| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | ALEXANDER JOSE <aangelj(at)hotmail(dot)com>, postgres admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: block a database |
| Date: | 2010-04-15 00:12:56 |
| Message-ID: | 201004150012.o3F0CvR10337@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Kevin Grittner wrote:
> ALEXANDER JOSE <aangelj(at)hotmail(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-04-15 02:06:30 | Re: PostgreSQL with SSL |
| Previous Message | Vitaly Burshteyn | 2010-04-14 22:02:27 | Re: amazon ec2 |