X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D71938B9CF2 for ; Wed, 23 Feb 2005 17:50:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79712-01 for ; Wed, 23 Feb 2005 17:50:19 +0000 (GMT) Received: from honorio.sinectis.com.ar (honorio.sinectis.com.ar [216.244.192.201]) by svr1.postgresql.org (Postfix) with ESMTP id 98CA78B9B9A for ; Wed, 23 Feb 2005 17:50:18 +0000 (GMT) Received: by honorio.sinectis.com.ar (Postfix, from userid 99) id 8A0016C8B2; Wed, 23 Feb 2005 14:50:16 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.5.1 From: G u i d o B a r o s i o To: amrit@health2.moph.go.th, pgsql-performance@postgresql.org, markir@coretech.co.nz Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20050223175016.8A0016C8B2@honorio.sinectis.com.ar> Date: Wed, 23 Feb 2005 14:50:16 -0300 (GMT+3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200502/328 X-Sequence-Number: 10657 Sorry, just a fool tip, cause I haven't seen that you already done the pg_ctl stop && pg_ctl start ... (I mean, did you reload your conf settings?) Regards, Guido > > > I used you perl script and found the error => > > > [root@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 > After being a detector I found that > [root@samba ~]# rpm -qa|grep -i postgres > postgresql-7.4.5-3.1.tlc > postgresql-python-7.4.5-3.1.tlc > postgresql-jdbc-7.4.5-3.1.tlc > postgresql-tcl-7.4.5-3.1.tlc > postgresql-server-7.4.5-3.1.tlc > postgresql-libs-7.4.5-3.1.tlc > postgresql-docs-7.4.5-3.1.tlc > postgresql-odbc-7.3-8.1.tlc > postgresql-pl-7.4.5-3.1.tlc > postgresql-test-7.4.5-3.1.tlc > postgresql-contrib-7.4.5-3.1.tlc > [root@samba ~]# > > no other pg installation except the pgsql for windows in samba folder which I > think it isn't matter ,is it? > No other pg being run. > [root@samba ~]# ps ax|grep postmaster > 2228 ? S 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data > 3308 pts/0 S+ 0:00 grep postmaster > [root@samba ~]# > > Is it possible that it is related to pg_ident.conf ? > > Any comment please. > Amrit,Thailand > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings