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

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)

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

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)
>
>


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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



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