Re: user to database restriction?

On Sun, 10 Feb 2002, Jon August wrote:

>
> That seems like a lot of work. . . and could become easily outdated.  No?
>
> How about in pg_hba.conf?  There's no way to say only user xyz can connect
> to database abc?
>
> I tried something like this in my pg_hba.conf, but now nobody can connect
> to it.
>
> local     all                                       password    postgres
> host      all     xxx.xxx.xxx.xxx  255.255.255.255  password    postgres
> local     shopdb                                    password        mark
> host      shopdb  xxx.xxx.xxx.xxx  255.255.255.255  password        mark
>
> I was hoping this config would permit user "postgres" to connect to any
> database, but limit user "mark" to shopdb.

The final argument goes to an external file in $PGDATA that lists users
(and optionally passwords) for the users that are allowed into the db.