[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] Cannot connect DSN to PostgreSQL



On Wednesday 12 February 2003 22:27, Jason Goodridge wrote:
> As I mentioned the only thing in pg_hba.conf is "local all trust". I'm not
> sure if that means a connection using the IP/Port of the localhost or some
> other type of local connection. Do I need a "host .... 127.0.0.1 ...
> 255.255.255.0 ..... trust" line in there too?
>
# Examples
# --------
#
# TYPE       DATABASE    IP_ADDRESS    MASK                AUTHTYPE  MAP
#
#host         all         127.0.0.1    255.255.255.255     trust
#
# The above allows any user on the local system to connect to any
# database under any username.
#

The above is from pg_hba.conf
All you have to do is uncomment it!
You probably want to change trust to crypt so that the user's password in 
pg_shadow is supplied.
You should also change the DATABASE form 'all'  to an assigned database.

Gerald
-- 
http://frontstreetnetworks.com | http://store.raqware.com
Front Street Networks LLC      |  Phone: 203-785-0699
229 Front Street, Ste #C, New Haven, CT 06513-3203