Postgres Pro
Downloads
Home   >   mailing lists

Thread: when to modify..

when to modify..

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

lori

Re: when to modify..

From
"Joshua D. Drake"
Date:
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)

Re: when to modify..

From
Chris Travers
Date:
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)
>
>

Re: when to modify..

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