> > I used you perl script and found the error => > > [EMAIL PROTECTED] 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 [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]#
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. [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]# 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