From: | "Mark Sargent" <coolboarderguy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | psql: FATAL: missing or erroneous pg_hba.conf file |
Date: | 2006-04-21 11:11:00 |
Message-ID: | 3de5eb120604210411h7dd285a0q2ea168185c353781@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Agent M | 2006-04-21 11:20:45 | Re: sudo-like behavior |
Previous Message | Jim C. Nasby | 2006-04-21 05:54:51 | Re: Query to check existence of stored procedure? |