Обсуждение: block a database

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

-Kevin

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