Re: Problem with 7.4.5 and webmin 1.8 in grant function

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(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
> After being a detector I found that
> [root(at)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(at)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(at)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(at)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