Search Postgresql Archives

Re: PG vs MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Just curious ... restricting \l itself isn't too difficult ... but how
> does MySQL restrict the ability to do something like:
> 
> SELECT datname FROM pg_database;
> 
> or does it not have an equivalent to that?

I'm not much of an expert in MySQL, but on my ISP 'show databases' only 
shows MY databases.  

I find MySQL's security tables arcane and confusing, but it may be that 
I'm just more familiar with the way PG does it, because from the traffic
on the pgsql-general list it seems like questions about how to set up 
the pg_hba.conf and pg_ident.conf are commonplace.

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?
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux