pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
To: amrit@health2.moph.go.th
To: pgsql-performance@postgresql.org
To: markir@coretech.co.nz
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
Date: Wed, 23 Feb 2005 14:50:16 -0300 (GMT+3)
Message-ID: <20050223175016.8A0016C8B2@honorio.sinectis.com.ar> (raw)

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




view thread (12+ messages)  latest in thread

Message-ID: <20050223175016.8A0016C8B2@honorio.sinectis.com.ar>
Permalink:  ../20050223175016.8A0016C8B2@honorio.sinectis.com.ar/
Also on:    postgresql.org/message-id/20050223175016.8A0016C8B2@honorio.sinectis.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gbarosio@uolsinectis.com.ar, amrit@health2.moph.go.th, markir@coretech.co.nz
  Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
  In-Reply-To: <20050223175016.8A0016C8B2@honorio.sinectis.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox