Thread: Easy pg_hba.conf question.

Easy pg_hba.conf question.

From
Robert
Date:
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


Re: Easy pg_hba.conf question.

From
Bruno Wolff III
Date:
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.

Re: Easy pg_hba.conf question.

From
Robert
Date:
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.


Re: Easy pg_hba.conf question.

From
Bruno Wolff III
Date:
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.