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?
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
> have the same problem the other way around?!
> here is what i have:
> BTW, how does your /var/lib/pgsql/data/pg_hba.conf look like?
> ;-) rainer
In response to
pgsql-odbc by date
|Next:||From: Tom Hughes||Date: 2005-10-19 14:07:22|
|Subject: EN_Destructor bug?|
|Previous:||From: Greg Campbell||Date: 2005-10-17 12:59:31|
|Subject: Re: vb6 inquiry|