Hi All,
new here, and pgsql in general. I currently use MySQL and now need to know pgsql. I have set it up on my Linux box, CentOS 4-3, using an RPM from Dag Wieer's repos. I am getting the following,
[racket@ibmlap lib]$ psql template1
psql: FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.
after following here,
http://polder-linux.org/modules.php?name=News&file=article&sid=182 as I was eperiencing the same problem as the user at the bottom,
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: IDENT authentication failed for user "arjen"
Refer to PostgreSQL Administrator's guide, Chapter 4: Client Authentication.
You probably have this line in the /var/lib/pgsql/data/pg_hba.conf:
local all ident sameuser
(I know RedHat 8.0 does this). You need to change this into:
local all trust
This tells PostgreSQL to allow any UNIX user to log into the database as any database user on a local socket.
*******************
and here,
http://serghei.net/docs/database/pgresql-7.1-admin/client-authentication.html I'm a little lost. Could someone steer me in the right direction? Cheers.
Mark Sargent.