Art,
On Feb 8, 2005, at 11:51 PM, Art Fore wrote:
More confused than ever. The pg_hba.conf file shown below was what I had originaly to get phppgadmin to work. Changed the
local all all ident md5
to
local all all trust
and it started to working again with phppgadmin, but now, access via ODBC (with MSAccess)does not work. All I get is #DELETED for every oolumn and every row.
could someone explain that to me?
I assume phpPgAdmin now works because the web server is on the same machine as the database. Accepting the connection has nothing to do with the machine the browser is running on. Setting this to trust and using phpPgAdmin is not good from a security standpoint. You should look at the FAQ and INSTALL files in the pgpPgAdmin installation for further details on setting this up.
With ODBC, do you see authentication errors in your PostgreSQL log? This might provide the clue you need to fix the problem.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
