Обсуждение: Easy pg_hba.conf question.
I want to add a line in a pg_hba.conf file so that the user 'auser' can connect to the database 'aDB' via host based authentication: so far for the line I have: host aDB 134.117.76.10 255.255.255.255 md5 However, I'm not sure how to specify only 'auser' can connect to the database. Thanks for your help, Robert Young
On Sat, Jan 24, 2004 at 12:23:44 -0500, Robert <rjyoung@scs.carleton.ca> wrote: > I want to add a line in a pg_hba.conf file so that the user 'auser' can > connect to the database 'aDB' via host based authentication: so far for > the line I have: > > host aDB 134.117.76.10 255.255.255.255 md5 > > > However, I'm not sure how to specify only 'auser' can connect to the > database. What version of postgres are you using? I think the hba format changed between 7.1 and 7.2 (though it might have been between 7.2 and 7.3) to include a specifation for allowed users.
Bruno Wolff III wrote: >On Sat, Jan 24, 2004 at 12:23:44 -0500, > Robert <rjyoung@scs.carleton.ca> wrote: > > >>I want to add a line in a pg_hba.conf file so that the user 'auser' can >>connect to the database 'aDB' via host based authentication: so far for >>the line I have: >> >>host aDB 134.117.76.10 255.255.255.255 md5 >> >> >>However, I'm not sure how to specify only 'auser' can connect to the >>database. >> >> > >What version of postgres are you using? I think the hba format changed >between 7.1 and 7.2 (though it might have been between 7.2 and 7.3) >to include a specifation for allowed users. > > I'm using 7.2, the one shipped with Debian Stable/3.0.
On Sat, Jan 24, 2004 at 14:18:09 -0500, Robert <rjyoung@scs.carleton.ca> wrote: > Bruno Wolff III wrote: > > >What version of postgres are you using? I think the hba format changed > >between 7.1 and 7.2 (though it might have been between 7.2 and 7.3) > >to include a specifation for allowed users. > > > > > I'm using 7.2, the one shipped with Debian Stable/3.0. Then the change must have been between 7.2 and 7.3 In the older versions you couldn't restrict which users could connect to which databases.