> But in the pg_hba.conf file there is this line: > local all all ident sameuser > which I thought would allow any type of connection to the postgres server > from the local machine. >
Ok, I changed the above line to: local all all trust and that did not work but this line did: host all all 127.0.0.1 255.255.255.255 true ------------------------- I can see, now, why "local all all ident sameuser" wouldn't work. But why doesn't "local all all trust" work when "host all all 127.0.0.1 255.255.255.255 true" does? Thanks, Kevin ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match