From: | Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> |
---|---|
To: | amrit(at)health2(dot)moph(dot)go(dot)th |
Cc: | PGsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Problem with 7.4.5 and webmin 1.8 in grant function |
Date: | 2005-02-22 05:45:23 |
Message-ID: | 421AC6F3.5010102@coretech.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
amrit(at)health2(dot)moph(dot)go(dot)th wrote:
>
> I used you perl script and found the error =>
> [root(at)samba tmp]# perl relacl.pl
> DBI connect('dbname=template1;port=5432','postgres',...) failed: FATAL: IDENT
> authentication failed for user "postgres" at relacl.pl line 21
> Error in connect to DBI:Pg:dbname=template1;port=5432:
>
>
Excellent - we know what is going on now!
> And my pg_hba.conf is
>
> # IPv4-style local connections:
> host all all 127.0.0.1 255.255.255.255 trust
> host all all 192.168.0.0 255.255.0.0 trust
>
> trusted for every user.
Ok, what I think has happened is that there is another Pg installation
(or another initdb'ed cluster) on this machine that you are accidentally
talking to. Try
$ rpm -qa|grep -i postgres
which will spot another software installation, you may just have to
search for files called pg_hba.conf to find another initdb'ed cluster....
This other installation should have a pg_hba.conf that looks something
like :
local all all ident
host all all 127.0.0.1 255.255.255.255 ident
So a bit of detective work is in order :-)
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | David Haas | 2005-02-22 06:47:59 | join vs. subquery |
Previous Message | amrit | 2005-02-22 05:00:58 | Re: Problem with 7.4.5 and webmin 1.8 in grant function |