On 3/9/10 11:15 AM, drugh10 wrote: > ...and now trying to query the database to get this info, I'm trying to use > Perl (not a whole lot of success with OpenRPT or PGAdmin), but cannot get > DBD::Pg to build (on a remote computer, NOT the InterMapper server) since the > include files it is looking for are missing. I copied pg_config over to the > client computer, but it contains references to your build environment...so > I'm stuck getting this module installed to be able to read the database. > Thoughts? >
Here's an extract from a tech note I've been working which describes what I needed to do to use Perl to query the InterMapper Database. This was done on Mac OS X. Version numbers may have changed at this point. Dartware publishes sample database queries in several formats, including Perl scripts. The steps needed to set up your system to make these queries possible from Perl may not be obvious. The following section of this tech note describes the steps you need to take. 1) Download PostgreSQL, build, and install it. a. Go to http://www.postgresql.org/ftp/source/ b. Choose a version; I chose 8.3.7. c. Choose a download location and download to your local hard drive. d. Build and install i. tar -zxf postgresql-8.3.7.tar.gz ii. cd postgresql-8.3.7 iii. ./configure iv. make v. make check vi. sudo make install 2) Download DBI, build, and install it. a. Go to http://search.cpan.org/~timb/DBI-1.609/DBI.pm (This will give you version 1.609…there may be later versions by the time you read this.) b. Build and install i. tar –zxf DBI-1.609.tar.gz ii. cd DBI-1.609 iii. perl Makefile.PL iv. make v. make test vi. sudo make install 3) Download DBD-Pg, build, and install it. a. Go to http://search.cpan.org/dist/DBD-Pg/Pg.pm. Click the download link at the right to download to your local hard drive. b. Build and install i. tar –zxf DBD-Pg-2.13.1.tar.gz ii. cd DBD-Pg-2.13.1 iii. perl Makefile.PL iv. make v. make test vi. sudo make install -- ================================= Christopher L. Sweeney Director of Software Development Dartware, LLC +1 603 643-9600 x104 http://dartware.com/ ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
