Обсуждение: when to modify..
Either Im tired or the documentation is confusing, when do I need to modify pg_hba.conf vs just doing a createuser thanks lori
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)
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) > >
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