pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Easy pg_hba.conf question.
4+ messages / 2 participants
[nested] [flat]

* Easy pg_hba.conf question.
@ 2004-01-24 17:23 Robert <rjyoung@scs.carleton.ca>
  2004-01-24 18:26 ` Re: Easy pg_hba.conf question. Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 4+ messages in thread

From: Robert @ 2004-01-24 17:23 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Easy pg_hba.conf question.
  2004-01-24 17:23 Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
@ 2004-01-24 18:26 ` Bruno Wolff III <bruno@wolff.to>
  2004-01-24 19:18   ` Re: Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruno Wolff III @ 2004-01-24 18:26 UTC (permalink / raw)
  To: Robert <rjyoung@scs.carleton.ca>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Easy pg_hba.conf question.
  2004-01-24 17:23 Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
  2004-01-24 18:26 ` Re: Easy pg_hba.conf question. Bruno Wolff III <bruno@wolff.to>
@ 2004-01-24 19:18   ` Robert <rjyoung@scs.carleton.ca>
  2004-01-24 20:22     ` Re: Easy pg_hba.conf question. Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 4+ messages in thread

From: Robert @ 2004-01-24 19:18 UTC (permalink / raw)
  To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Easy pg_hba.conf question.
  2004-01-24 17:23 Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
  2004-01-24 18:26 ` Re: Easy pg_hba.conf question. Bruno Wolff III <bruno@wolff.to>
  2004-01-24 19:18   ` Re: Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
@ 2004-01-24 20:22     ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruno Wolff III @ 2004-01-24 20:22 UTC (permalink / raw)
  To: Robert <rjyoung@scs.carleton.ca>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-01-24 20:22 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-24 17:23 Easy pg_hba.conf question. Robert <rjyoung@scs.carleton.ca>
2004-01-24 18:26 ` Bruno Wolff III <bruno@wolff.to>
2004-01-24 19:18   ` Robert <rjyoung@scs.carleton.ca>
2004-01-24 20:22     ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox