Re: PG vs MySQL

On Mon, 29 Mar 2004, Joshua D. Drake wrote:

> > I also wonder how well the pg_hba.conf method will scale. What happens
> > if there are hundreds of client databases or thousands of entries in
> > pg_hba.conf?
>
> Although I personally would like to see a pg_hba table instead of the
> file, I would have to seariously question your implementation if you had
> hundreds of databases on a single machine.
>
> If you need separate data spaces for each customer but the application
> uses the same schema, use namespaces within a single database.

since the purpose of the pg_hba.conf file is to ensure that you never
manage to lock yourself out of your database, might it make sense to have
a pg_hba table in each database that can be / will be / should be(???)
overidden by the pg_hba.conf file, thus ensuring you never get locked out,
but allowing the vast majority of connection configuration to be handled
by tables, with the pg_hba.conf as an emergency procedure used to get the
warp engines online in case some drunken ensign starts singing "I'll take
you home Kathleen" and shuts them down. (i.e. "delete from pg_hba" or
something like it.)???