Postgres Pro
Downloads
Home   >   mailing lists

pg_hba.conf authorization question - Mailing list pgsql-general

From Reid Thompson
Subject pg_hba.conf authorization question
Date
Msg-id 64AE3D5B518E3648ACC823FBCB0B7375B6CB5A@sr002-2kexc.ateb.com
Whole thread Raw
Responses Re: pg_hba.conf authorization question  (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
List pgsql-general
Tree view
Could someone give me guidance on the following.
I would like to configure the DB such that connections will only be allowed to users created using createuser verified by the password that was set during the creatuser process.  The user and password do NOT correlate to system users(linux host).  Connections will be both local and TCP based. 
Rather than the open to everyone entries that I have in pg_hba.conf below, what should the entries look like under
 
# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARGUMENT
local      all                                          trust
host       all         127.0.0.1     255.255.255.255    trust
host       all         192.168.100.0 255.255.255.0      trust
 
Thanks,
reid

pgsql-general by date:

Previous
From: "Ken Godee"
Date:
Subject: Re: Copy/foreign key contraints
Next
From: Stephan Szabo
Date:
Subject: Re: Copy/foreign key contraints