Thread: block a database
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 Get it now!
Atentamente,
Alexander Angel
DBA
058-02128018316
Connect to the next generation of MSN Messenger Get it now!
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