block a database

--_2686d98c-a8d7-47e1-8799-040753203032_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


As I can block a database so users can not connect without
affecting the other databases.


Atentamente=2C

Alexander Angel
DBA
058-02128018316

____________________________________________________________ _____
Connect to the next generation of MSN Messenger=A0
http://imagine-msn.com/messenger/launch80/default.aspx?local e=3Den-us&sourc=
e=3Dwlmailtagline=

--_2686d98c-a8d7-47e1-8799-040753203032_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
<span id=3D"result_box" class=3D"short_text"><span style=3D"background-colo=
r: rgb(255=2C 255=2C 255)=3B" title=3D"Como puedo bloquear una base de dato=
s para
que los usuarios no puedan conectarse sin afectar a las otras bases de
datos.">As I can block a database so users can not connect without
affecting the other databases.<br><br><br>Atentamente=2C<br><br>Alexander A=
ngel<br>DBA<br>058-02128018316<br></span></span>
<hr />Con=
nect to the next generation of MSN Messenger=A0 <a href=3D'http://imagine-=
msn.com/messenger/launch80/default.aspx?locale=3Den-us&sourc e=3Dwlmailtagli=
ne' target=3D'_new'>Get it now! </a></body>
</html>=

--_2686d98c-a8d7-47e1-8799-040753203032_--
ALEXANDER JOSE [ Do, 08 April 2010 22:52 ] [ ID #2038150 ]

Re: block a database

ALEXANDER JOSE <aangelj [at] 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-c onf.html

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Do, 08 April 2010 22:56 ] [ ID #2038151 ]

Re: block a database

Kevin Grittner wrote:
> ALEXANDER JOSE <aangelj [at] 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-c onf.html

or:

ALTER DATABASE ... CONNECTION LIMIT connlimit

--
Bruce Momjian <bruce [at] momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Bruce Momjian [ Do, 15 April 2010 02:12 ] [ ID #2039024 ]
Datenbanken » gmane.comp.db.postgresql.admin » block a database

Vorheriges Thema: AIX Postgres Compile Error
Nächstes Thema: autoscale cluster