pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
when to modify..
4+ messages / 3 participants
[nested] [flat]

* when to modify..
@ 2005-05-10 23:34 Lori <lorid@dri.edu>
  2005-05-10 23:40 ` Re: when to modify.. Joshua D. Drake <jd@commandprompt.com>
  2005-05-11 01:22 ` Re: when to modify.. Chris Travers <chris@travelamericas.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Lori @ 2005-05-10 23:34 UTC (permalink / raw)
  To: pgsql-admin

Either Im tired or the documentation is confusing,
when do I need to modify pg_hba.conf
vs just doing a
createuser
thanks

lori



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

* Re: when to modify..
  2005-05-10 23:34 when to modify.. Lori <lorid@dri.edu>
@ 2005-05-10 23:40 ` Joshua D. Drake <jd@commandprompt.com>
  2005-05-11 17:35   ` Re: when to modify.. Lori <lorid@dri.edu>
  1 sibling, 1 reply; 4+ messages in thread

From: Joshua D. Drake @ 2005-05-10 23:40 UTC (permalink / raw)
  To: Lori <lorid@dri.edu>; +Cc: pgsql-admin

Lori wrote:
> Either Im tired or the documentation is confusing,
> when do I need to modify pg_hba.conf
> vs just doing a
> createuser
> thanks

Well that entirely depends but in general if the user is connecting
to the same database from the same network or machine that others users 
already use you only need to create user.

However if the user is on a different network and you haven't allowed 
access from that network you may need to modify the pg_hba.conf

Sincerely,

Joshua D. Drake
Command Prompt, Inc.


> 
> lori
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




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

* Re: when to modify..
  2005-05-10 23:34 when to modify.. Lori <lorid@dri.edu>
  2005-05-10 23:40 ` Re: when to modify.. Joshua D. Drake <jd@commandprompt.com>
@ 2005-05-11 17:35   ` Lori <lorid@dri.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Lori @ 2005-05-11 17:35 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin

thank you ,
this makes sense.
lori
Joshua D. Drake wrote:

> Lori wrote:
>
>> Either Im tired or the documentation is confusing,
>> when do I need to modify pg_hba.conf
>> vs just doing a
>> createuser
>> thanks
>
>
> Well that entirely depends but in general if the user is connecting
> to the same database from the same network or machine that others 
> users already use you only need to create user.
>
> However if the user is on a different network and you haven't allowed 
> access from that network you may need to modify the pg_hba.conf
>
> Sincerely,
>
> Joshua D. Drake
> Command Prompt, Inc.
>
>
>>
>> lori
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster





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

* Re: when to modify..
  2005-05-10 23:34 when to modify.. Lori <lorid@dri.edu>
@ 2005-05-11 01:22 ` Chris Travers <chris@travelamericas.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Chris Travers @ 2005-05-11 01:22 UTC (permalink / raw)
  To: Lori <lorid@dri.edu>; pgsql-admin

Lori wrote:

> Either Im tired or the documentation is confusing,
> when do I need to modify pg_hba.conf
> vs just doing a
> createuser
> thanks

create user creates a database user account.

pg_hba.conf provides a set of access permissions regarding where and how 
users and/or computers can connect to the database.

You MUST have both permission in the pg_hba.conf AND a valid user 
account to log in.

Does that make sense?

Best Wishes,
Chris Travers
Metatron Technology Consulting

>
> lori
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>




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


end of thread, other threads:[~2005-05-11 17:35 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-10 23:34 when to modify.. Lori <lorid@dri.edu>
2005-05-10 23:40 ` Joshua D. Drake <jd@commandprompt.com>
2005-05-11 17:35   ` Lori <lorid@dri.edu>
2005-05-11 01:22 ` Chris Travers <chris@travelamericas.com>

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