473,224 Members | 1,534 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Pg module for Perl

If this is the wrong list, let me know...
I am trying to install the Pg DBD module for Perl DBI and am having a
problem. It keeps coming up asking if I read the README file, which i have
several times. The perl Makefile.PL and make seem to run without
problems, but the make test fails. I have confirmed that Postgres is
running fine. I've been able to create schema and tables and load data.
I have re-built Perl 5.8.2, I have installed PostgreSQL v7.4 and DBI-1.38.
Then I tried installing pgsql_perl5-1.9.0 and it just wont work. Have I
picked up the wrong module? Are there some specific configs required for
any of these to support the Pg DBD?
Any help appreciated.
Barb

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
5 2081
Barbara Lindsey wrote:
I have re-built Perl 5.8.2, I have installed PostgreSQL v7.4 and DBI-1.38.
Then I tried installing pgsql_perl5-1.9.0 and it just wont work. Have I
picked up the wrong module? Are there some specific configs required for
any of these to support the Pg DBD?


IIRC, the Pg module for Perl is quite distinct to DBD::Pg. You might be
trying to install the wrong module.

What do you mean by "it just won't work"? If, after installing
pgsql_perl5-1.9.0, you get a message about not being able to find
"DBD::Pg in @INC", you've probably got the Pg module installed instead.
Try "man Pg", see if you've actually got the Pg module installed.

HTH
Alex
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2
Barbara Lindsey <bl******@cog.ufl.edu> wrote:
If this is the wrong list, let me know... I am trying to install the Pg DBD module for Perl DBI and am having
a problem. It keeps coming up asking if I read the README file,
which i have several times. The perl Makefile.PL and make seem to
run without problems, but the make test fails. I have confirmed
that Postgres is running fine. I've been able to create schema and
tables and load data. I have re-built Perl 5.8.2, I have installed
PostgreSQL v7.4 and DBI-1.38. Then I tried installing
pgsql_perl5-1.9.0 and it just wont work. Have I picked up the wrong
module? Are there some specific configs required for any of these
to support the Pg DBD? Any help appreciated.
Barb


Barb,

Try setting $DBI_DSN to something like dbi:Pg:test before trying to
install DBD::Pg

in bash, that reads

export DBI_DSN=dbi:Pg:test

in (t)csh, it's

setenv DBI_DSN dbi:Pg:test

HTH :)

Cheers,
David.
--
David Fetter da***@fetter.org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778

On two occasions I have been asked [by members of Parliament], 'Pray,
Mr. Babbage, if you put into the machine wrong figures, will the
right answers come out?' I am not able rightly to apprehend the kind
of confusion of ideas that could provoke such a question.
Charles Babbage
Nov 12 '05 #3

I think you are right!
I originally went to the Perl Module list on CPAN and looked for DBD and Pg.
It gave me the pgsql_perl5.1.9.0 link

However, when I searched for DBD Pg on Google, it led me to a DBD-Pg-1.22

I think that is what I was looking for. Will give it a try tonight.
Thanks!
Barb

Alex Satrapa wrote:
Barbara Lindsey wrote:
I have re-built Perl 5.8.2, I have installed PostgreSQL v7.4 and
DBI-1.38.
Then I tried installing pgsql_perl5-1.9.0 and it just wont work. Have I
picked up the wrong module? Are there some specific configs required for
any of these to support the Pg DBD?

IIRC, the Pg module for Perl is quite distinct to DBD::Pg. You might be
trying to install the wrong module.

What do you mean by "it just won't work"? If, after installing
pgsql_perl5-1.9.0, you get a message about not being able to find
"DBD::Pg in @INC", you've probably got the Pg module installed instead.
Try "man Pg", see if you've actually got the Pg module installed.

HTH
Alex
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org


--
Barbara E. Lindsey,
COG RDC
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162

----
CONFIDENTIALITY NOTICE: The information contained in this electronic
message is legally privileged and confidential and intended only for the
use of the individual(s) or entity(ies) named above. If the reader of
this message is not the intended recipient, you are hereby notified that
any dissemination, distribution, or copying of this email or any of it's
components is strictly prohibited. If you have received this email in
error, please contact the sender.
----
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #4
On Mon, 1 Dec 2003, Barbara Lindsey wrote:
However, when I searched for DBD Pg on Google, it led me to a DBD-Pg-1.22


Try

http://search.cpan.org/~rudy/DBD-Pg-1.31/Pg.pm

Not sure if there are a lot of dependency issues going to Pg 7.4 as I'm in
the process upgrading to 7.4 and all it's friends.

One other issue that comes when installing DBI and/or DBD is the from the
current (1.31) README file.

....

INSTALLATION:
-------------

By default Makefile.PL uses App:Info to find the location of the
PostgreSQL library and include directories. However, if you want to
control it yourself, define the environment variables POSTGRES_INCLUDE
and POSTGRES_LIB, or POSTGRES_HOME. Note that if you've compiled
PostgreSQL with SSL support, you must define the POSTGRES_LIB
environment varable and add "-lssl" to it, like this:

export POSTGRES_LIB="/usr/local/pgsql/lib -lssl"

....

Good luck to us both.
Rod
--
"Open Source Software - Usually you get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #5
This was perfect. I also had to set the DBI_* envs. See test results
below. I then installed and successfully ran my own test.
Thanks to all who replied!
Barb

Test Results:
$ make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00basic...........ok
t/01connect.........ok 2/2#
# Package Version
# DBD::Pg 1.31
# DBI 1.38
# Postgres 7.4
t/01connect.........ok
t/01constants.......ok
t/01setup...........ok
t/02prepare.........ok
t/03bind............ok
t/04execute.........ok
t/04rows............ok
t/05fetch...........ok
t/06disconnect......ok
t/07reuse...........ok
t/08txn.............ok
t/09autocommit......ok
t/10chopblanks......ok
t/11quoting.........ok
t/12placeholders....ok
t/13pgtype..........ok
t/15column_info.....ok
t/15funct...........ok
t/15table_attrs.....ok
t/15table_info......ok
t/16pgbooltf........# DBD::Pg version: 1.31
t/16pgbooltf........ok
t/17arrays..........ok
t/99_pod............skipped
all skipped: Test::Pod 1.00 required for testing POD
t/99cleanup.........ok
All tests successful, 1 test skipped.
Files=25, Tests=268, 34 wallclock secs (10.72 cusr + 0.99 csys = 11.71 CPU)

:)
On Mon, 1 Dec 2003, Barbara Lindsey wrote:
However, when I searched for DBD Pg on Google, it led me to a
DBD-Pg-1.22


Try

http://search.cpan.org/~rudy/DBD-Pg-1.31/Pg.pm

Not sure if there are a lot of dependency issues going to Pg 7.4 as I'm
in the process upgrading to 7.4 and all it's friends.

One other issue that comes when installing DBI and/or DBD is the from
the current (1.31) README file.

...

INSTALLATION:
-------------

By default Makefile.PL uses App:Info to find the location of the
PostgreSQL library and include directories. However, if you want to
control it yourself, define the environment variables POSTGRES_INCLUDE
and POSTGRES_LIB, or POSTGRES_HOME. Note that if you've compiled
PostgreSQL with SSL support, you must define the POSTGRES_LIB
environment varable and add "-lssl" to it, like this:

export POSTGRES_LIB="/usr/local/pgsql/lib -lssl"

...

Good luck to us both.
Rod
--
"Open Source Software - Usually you get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: smsabu2002 | last post by:
Hi, I am facing the build problem while installing the DBD-MySql perl module (ver 2.9008) using both GCC and CC compilers in HP-UX machine. For the Build using GCC, the compiler error is...
0
by: Envex Developments | last post by:
Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL...
0
by: Envex Developments | last post by:
Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL...
3
by: sir.linying | last post by:
My php script is to call perl scipt which makes use of Spreadsheet::ParseExcel module to parse Excel file. I am able to launch php script from command line so that perl script can run and properly...
14
by: ccdetail | last post by:
http://www.tiobe.com/index.htm?tiobe_index Python is the 7th most commonly used language, up from 8th. The only one gaining ground besides VB in the top 10. We're glad, our app is written in...
21
KevinADC
by: KevinADC | last post by:
Note: You may skip to the end of the article if all you want is the perl code. Introduction Uploading files from a local computer to a remote web server has many useful purposes, the most...
0
by: UncleRic | last post by:
Environment: Mac OS X (10.4.10) on MacBook Pro I'm a Perl Neophyte. I've downloaded the XML::Parser module and am attempting to install it in my working directory (referenced via PERL5LIB env): ...
1
by: srikantvm | last post by:
Hi All, I am using perl, v5.8.8 built for MSWin32-x86-multi-thread and i tried installing the DBD-Oracle module but unable to install. Please find below the steps followed by me: 1) I first...
3
by: vijayarl | last post by:
Hi everyone, Requirement: Am trying to install the CPAN module : Spreadsheet::Excelsheet through PPM i have downloaded the Spreadsheet-ParseExcel-0.33.tar.gz file & uncompress it Problem: ...
2
by: somsub | last post by:
Hi all, Here is my samle code use strict ; use warnings ; use IO::Uncompress::Unzip ; When I compiled this three lines of code in win32 I got error like below.
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.