On February 26, 2005 03:35 pm, Shawn wrote: > Thanks Aaron. > > I had been in the /var/lib/pgsql/data folder, to get at the pg_hba.conf > file - but I had focused on that one file, I totally missed the > postgresql.conf file sitting there as well. Funny though, doing whereis > and locate on it didn't find it. (I guess the lesson learned is to NOT be > doing sysadmin work in the wee hours of the morning after a long day... > <grins>) > > I do need TCP/IP as this will be a DB server to one or more web servers. I > might be able to disable tcp/ip access for now seeing as the first web > server will be on the same box. > > After seeing your message, I took another look at the default "local" line > in pg_hba.conf. It was set up with the "sameuser" option, which isn't > applicable in this case. Once I removed it, leaving the line as > local all all trust > all worked as expected. If I didn't have control over who can access the > box locally then I would be changing the "trust" part. Otherwise, I'm on > my way. > > Thanks again Aaron, Szemir, and others that helped out. > > Shawn >
I just want to point out that you can even use the 'local' on a multiuser machine if you use the normal unix user/group permissions on the unix domain socket to restrict its use. _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
