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
local is for all local connections, phppgadmin i guess is local, if
run on the same computer could be local, depending on your
configuration.
is access and odbc on a different computer? in that case you could add
host all all ipnumber mask trust
to allow access to all databeses as any user for
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 phppgad
I had this working once before, but restarted the database and things
went to hell. This user authentication for postgresql I will have to say
is the most complex I have seen. Need a block diagram of how it works to
understand it.
Have .pgpass in postgres home directory, data directory is
/hom
Mike Withers wrote:
>
> My apologies if the answer(s) to my questions are obvious to others. I'm
> still quite new to Linux and PostgreSQL.
>
> I have set up a database to be used by hundreds of students. Within psql I
> set GRANT SELECT ON database TO PUBLIC on the database but have found that
>
