DBI driver name for Postgres

Hello

I am trying to install the Dtabase Plugin and I have largely succeeded having connected to a My SQL test database. Unfortunately the data I wish to access is in a Postgres (8.3) database. I have changed the approrpriate fields in configure but I am unable to find the driver name. I thought it might be pg, which I have tried and also postgres but both return an error. Postgres is installed on the same machine as foswiki so I am fairly sure that the dbi driver will be installed

Can anyone tell me what the driver is called please.

-- RayHojka - 24 Jun 2009

Quick search on the net suggests: Pg. Have you tried already?

-- OliverKrueger - 24 Jun 2009

Thanks for the response. Yes I have tried that already. Also tried postgres. I also installed libdbd-pg-perl so I'm fairly sure I have the driver installed but when I enter use pg I get this response

install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC contains: /var/lib/foswiki/lib /etc/foswiki . /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl) at (eval 220) line 3. at (eval 220) line 3 eval 'package # hide from PAUSE DBI::_firesafe; # just in case require DBD::pg; # load the driver

Perhaps I'm missing something else?

Any help is appreciated.

-- RayHojka - 26 Jun 2009

Problem sorted. Many thanks for the help. I noticed after pasting in the error above that I had used 'pg' and not 'Pg'. ( Cant get used to Linux being case sensitive as I have to use Windows a lot of the time).

Thanks again.

-- RayHojka - 26 Jun 2009