Matt Quackenbush wrote: >> This is a bad combination because they result in a cleartext communication >> and even a cleartext password. Best would be to install a certificate and >> use hostssl instead of host, but at least you should use md5 instead of >> psssword. > > Thank you for the tip on the ssl/md5/password issue. At the moment, I am > setting this up on a server purely for my testing purposes, and the server > in question does not have an SSL cert. I did however change it to 'md5'.
Generate your own certificate with OpenSSL. > I ran the 'pg_ctl reload' command, and it returned the following message: > > pg_ctl: no database directory specified and environment variable PGDATA > unset > > I then ran the 'pg_ctl --help' command (as instructed), but I'm not > intelligent enough to figure out what the issue is from the info that it > responded with. ;-) It needs to know which PostgreSQL instance to reload. The directory it wants is the directory with your pg_hba.conf in it. From there it can figure out the rest. > LOG: invalid IP mask "password" in file "C:/Program > Files/PostgreSQL/8.2/data/pg_hba.conf" line 72: Unknown host You are missing a column in your pg_hba.conf. Do you have the real one somewhere? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4