| Lists: | pgsql-admin |
|---|
| From: | ALEXANDER JOSE <aangelj(at)hotmail(dot)com> |
|---|---|
| To: | postgres admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | block a database |
| Date: | 2010-04-08 20:52:30 |
| Message-ID: | BAY145-w6511492B9D3D673A4CCC87A5160@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
As I can block a database so users can not connect without
affecting the other databases.
Atentamente,
Alexander Angel
DBA
058-02128018316
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "ALEXANDER JOSE" <aangelj(at)hotmail(dot)com>, "postgres admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: block a database |
| Date: | 2010-04-08 20:56:17 |
| Message-ID: | 4BBDFCA10200002500030604@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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
-Kevin
| 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 |
| 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