pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhen to modify..
4+ messages / 3 participants
[nested] [flat]
* when to modify..
@ 2005-05-10 23:34 Lori <lorid@dri.edu>
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:40 Joshua D. Drake <jd@commandprompt.com>
parent: 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-11 01:22 Chris Travers <chris@travelamericas.com>
parent: Lori <lorid@dri.edu>
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
* Re: when to modify..
@ 2005-05-11 17:35 Lori <lorid@dri.edu>
parent: Joshua D. Drake <jd@commandprompt.com>
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
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