Rainer,
I used the standard /var/lib/pgsql/data/pg_hba.conf provided
with the RHEL4/CentOS4 RPM's... the only non-commented line is:
local all all ident sameuser
I must confess I don't fully understand the entries here, but I didn't touch
them and the comments say this gives everyone local access. Also since
the unixODBC driver works it seems like pg_hba.conf can't be the problem...
Another possibility I don't understand at all is that this is some byproduct
of Security Enhanced Linux (SEL) preventing the 2nd driver from running...
anybody know enough to comment on this?
Greg Martin
gamartin@shout.net
On Mon, 17 Oct 2005, Rainer Hochreiter wrote:
>
> > Hello,
> > I have utterly failed getting the postgreSQL ODBC driver working
> > with unixODBC on Red Hat Enterprise Linux 4 for Intel (actually CentOS4
> > but it's supposed to be the same thing) using the standard RPM packages.
> > However, the driver provided with the unixODBC package works fine.
> > I have tried lots of different tweaks in the config files and have
> > concluded
> > I must be missing something basic.
> > I would simply shrug and use the unixODBC-provided driver, except
> > that I'd like to use the most current ODBC driver and my understanding
> > is the unixODBC-provided driver is somewhat out of date. Plus it's
> > pretty damn annoying that I can't get it to work at all with the
> > PostgreSQL-provided driver.
> > Here's what I'm using:
> >
> > postgresql-server-7.4.8-1.RHEL4.1
> > postgresql-odbc-7.3-8.RHEL4.1
> > postgresql-libs-7.4.8-1.RHEL4.1
> > postgresql-7.4.8-1.RHEL4.1
> >
> > unixODBC-devel-2.2.9-1
> > unixODBC-2.2.9-1
> >
>
> hi,
> have the same problem the other way around?!
> here is what i have:
> postgresql-7.3.4-3.rhl9.i386.rpm
> postgresql-devel-7.3.4-3.rhl9.i386.rpm
> postgresql-libs-7.3.4-3.rhl9.i386.rpm
> postgresql-odbc-7.3-4.i386.rpm
> postgresql-server-7.3.4-3.rhl9.i386.rpm
>
> unixODBC-2.2.11-1.i386.rpm
> unixODBC-devel-2.2.11-1.i386.rpm
>
> BTW, how does your /var/lib/pgsql/data/pg_hba.conf look like?
>
> ;-) rainer