Thread: Setting up DBD for PostgreSQL

The DBD-Pg and DBI provide the database interface mechanism between the SQL-Ledger and PostgreSQL database. The ActivePeri has the OBI package already installed. so we just need to install the PostgreSQL database driver for Perl's OBI module. Since, we are using PerlS.1 0 for this demo, we'll have to use the DBD-Pg version 2.10 which is compliant with Perl's latest version. Copy the DBD-Pg-2.10.0-PerlS.10.ppd file from the DVD to a temporary directory on your computer. The Perl Package Descriptor (PPD) file downloads the necessary Perl drivers for PostgreSQL database. So, it's important that you are connected to the Internet while providing this file to the PPM command. PPM is the ActivePeris' package manager that is used to install, upgrade or for removing packages.



You have to install the DBD-Pg package manually using the PPM install command. So, through the command prompt. go to the root of the temporary directory where you copied this PPD file and enter the following command (for convenience we have renamed the PPD file to just DBD-Pg.ppd):

This will download DBD-Pg-2.10 packages and install them in the site directory of Perl's installation directory. After the DBD-Pg has been installed, again run the "ppm" or "ppm gui" command from the command prompt which will bring Perl's Package Manager window. Here scroll down to see the DBD-Pg package installed and that also in the area 'site' and having version 2.10.