[BALU] Determining log-on rights/permissions on SuSE 11.3

Walker Haddock whaddock at mac.com
Thu Apr 14 17:11:25 CDT 2011


Andrew,

I understand your question to be:
How do I change the network address that users are allowed to connect to the PostgreSQL database from?

The PostgreSQL database uses the pg_hba.conf file to authorize network (and local) connections to the database.  You have 5 types of authentication methods to select, the database, the user and the host address (or network).

After modifying the pg_hba.conf file, you can issue a "pg_ctl reload" (as documented in the pg_hba.conf file) as a database superuser.

Walker

On Apr 14, 2011, at 4:10 PM, Andrew Edson wrote:

> I've recently been informed that the official location for one of the servers we maintain will be picking up a branch location.  (Offices have an internal pattern of '###.###.N.###' for their IP combos; the new branch has a different value of N from the main office.)  I've been requested to verify that the systems from the branch site will be able to log into the main office's server.  I know how to check and verify the login IP values for the mysql database, and I'm fairly confident I can figure out what I'll need to permit the postgres system to accept the new branches, but where do I need to look and reset in order to ensure that the systems can actually log into the server itself?
> _______________________________________________
> Members mailing list
> Members at lists.bham-lug.org
> http://lists.bham-lug.org/cgi-bin/mailman/listinfo/members

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://bham-lug.org/pipermail/members/attachments/20110414/59bc4bed/attachment.html>


More information about the Members mailing list