From gelles@inter.net.il Sun Sep  12 16:37:47 1999
Received: from mail.inter.net.il (parker.inter.net.il [192.116.192.53])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA81345
	for <pgsql-interfaces@postgresql.org>;
	Sun, 12 Sep 1999 12:37:47 -0400 (EDT)
	(envelope-from gelles@inter.net.il)
Received: from amdpc (Ramat-Gan-5-148.access.net.il [213.8.5.148] (may be
	forged)) by mail.inter.net.il (8.9.3/8.8.6/PA) with SMTP id SAA01320
	for <pgsql-interfaces@postgresql.org>;
	Sun, 12 Sep 1999 18:36:31 +0200 (IST)
Message-ID: <001301befd68$6f964de0$940508d5@amdpc>
From: "Dan" <gelles@inter.net.il>
To: <pgsql-interfaces@postgresql.org>
Subject: Perl
Date: Sun, 12 Sep 1999 18:47:38 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0010_01BEFD4F.496EE280"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01BEFD4F.496EE280
Content-Type: text/plain;
	charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

Hello all.

1. Where can i find documntetion and examples for using postgresql from =
Perl?

Regards,
Dan

------=_NextPart_000_0010_01BEFD4F.496EE280
Content-Type: text/html;
	charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1255" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d8d0c8>
<DIV><FONT face=3DArial size=3D2>Hello all.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>1. Where can i find documntetion and =
examples for=20
using postgresql from Perl?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Dan</FONT></DIV></BODY></HTML>

------=_NextPart_000_0010_01BEFD4F.496EE280--




From jason@intekom.co.za Sun Sep  19 13:31:20 1999
Received: from mail.intekom.com (smtp.intekom.com [196.25.69.22])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA52369;
	Sun, 19 Sep 1999 09:31:20 -0400 (EDT)
	(envelope-from jason@intekom.co.za)
Received: from ndf53-01-p27.gt.saix.net ([196.15.182.27] helo=pug.galaxy.net)
	by mail.intekom.com with esmtp (Exim 3.02 #4)
	id 11Sh36-00028T-00; Sun, 19 Sep 1999 15:30:37 +0200
Received: from jason ([192.168.1.10])
	by pug.galaxy.net (8.9.3/8.9.3) with SMTP id NAA18627;
	Sun, 19 Sep 1999 13:18:58 +0200
Message-Id: <199909191118.NAA18627@pug.galaxy.net>
From: "Jason Doller" <jason@intekom.co.za>
To: pgsql-interfaces@postgresql.org, hackers@postgresql.org
Date: Sun, 19 Sep 1999 13:17:49 +0200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: PERL
Reply-to: rjd@intekom.co.za
X-Confirm-Reading-To: rjd@intekom.co.za
X-pmrqc: 1
Priority: normal
In-reply-to: <199909182010.QAA18416@candle.pha.pa.us>
References: <35E0ABF0.578694C8@bellatlantic.net> from David Hartwig at "Aug
 23,
	1998 07:55:29 pm"
X-mailer: Pegasus Mail for Win32 (v3.11)

Hi All

I'm a bit lost!  Where can I find documentation on accessing postgres 
from inside PERL (5)?

Any help will be appreciated.  (The thing is, I'm sure I've seen the info 
somewhere, but for the life of me I can't remember where...)

Thanks

Jason Doller



From bmccoy@lan2wan.com Sun Sep  19 14:57:00 1999
Received: from access1.lan2wan.com (root@access1.lan2wan.com [205.177.8.10])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA63463;
	Sun, 19 Sep 1999 10:57:00 -0400 (EDT)
	(envelope-from bmccoy@lan2wan.com)
Received: from dragosani.lan2wan.com (pm1-13.lan2wan.com [205.177.8.53]) by
	access1.lan2wan.com (8.8.5/) with ESMTP id LAA08543;
	Sun, 19 Sep 1999 11:16:12 -0400 (EDT)
Received: from localhost (bmccoy@localhost)
	by dragosani.lan2wan.com (8.8.7/8.8.7) with ESMTP id KAA01041;
	Sun, 19 Sep 1999 10:57:43 -0400
X-Authentication-Warning: dragosani.lan2wan.com: bmccoy owned process doing
 -bs
Date: Sun, 19 Sep 1999 10:57:40 -0400 (EDT)
From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: rjd@intekom.co.za
cc: pgsql-interfaces@postgresql.org, hackers@postgresql.org
Subject: Re: [INTERFACES] PERL
In-Reply-To: <199909191118.NAA18627@pug.galaxy.net>
Message-ID: <Pine.LNX.4.04.9909191054490.890-100000@dragosani.lan2wan.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Sun, 19 Sep 1999, Jason Doller wrote:

> I'm a bit lost!  Where can I find documentation on accessing postgres 
> from inside PERL (5)?
> 
> Any help will be appreciated.  (The thing is, I'm sure I've seen the info 
> somewhere, but for the life of me I can't remember where...)

Under the source tree, go to the interfaces directory, and there is a
directory for the perl interface (Pg.pm).  You have to enable the Perl
option when you run configure, and you will also have to install the
module as root, since it gets installed under the module hierarchy
wherever you have Perl installed.  Then you only need to do a 'perldoc Pg'
to see the documentation on it.  See the build instructions for more
information on the how to install the Perl module.

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Don't let your mind wander -- it's too little to be let out alone.




From giorgio@opla.it Thu Jun  26 09:34:56 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 5FAA930FE82
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 09:34:56 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 28415-06
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 06:34:46 -0300 (ADT)
Received: from smtp1.reteitaly.com (ns2.reteitaly.com [213.144.81.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 159D630FE9C
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 06:34:41 -0300 (ADT)
Received: from smtp.intranet.reteitaly.com (unknown [213.144.73.139])
	by smtp1.reteitaly.com (Postfix) with ESMTP id ABBA3D710A
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 11:34:40 +0200 (CEST)
Received: from pcguru (unknown [213.144.73.174])
	by smtp.intranet.reteitaly.com (Postfix) with SMTP id F005145DF00
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 11:34:39 +0200 (CEST)
Message-ID: <000401c33bc6$29b8dbd0$ae4990d5@pcguru>
From: "Giorgio Ponza" <giorgio@opla.it>
To: <pgsql-interfaces@postgresql.org>
References: <OFD57CC99B.38B2BFA8-ON05256D4B.000F1A3A@int.tp.com.pe>
Subject: Perl
Date: Thu, 26 Jun 2003 11:20:26 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Archive-Number: 200306/76
X-Sequence-Number: 4287

Sorry if i ask you, but reading the past messages didn't help me
I'm trying to configure dbmirror for my PostgreSQL 7.3.3 installation, but
when i try to execute the DBMirror.sql, i get the error:

Can't locate Pg.pm in @INC (@INC contains:
/usr/local/lib/perl5/5.8.0/i686-linux
 /usr/local/lib/perl5/5.8.0 /usr/local/lib/perl5/site_perl/5.8.0/i686-linux
/usr
/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl .) at
./DBMirror
.pl line 76.
BEGIN failed--compilation aborted at ./DBMirror.pl line 76.

I installed PostgreSQL 7.3.3 with the --with-perl (also --with-tcl)
The dbmirror README says to see in src/interfaces/perl5 but i don't have
that dir.
I also see in /usr/local/pgsql/lib and there is the plperl.so file
Can anyone help me?

tx

Giorgio Ponza




From greg@turnstep.com Thu Jun  26 14:00:45 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F60B30E689
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 14:00:45 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 58590-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 11:00:32 -0300 (ADT)
Received: from biglumber.com (biglumber.com [207.228.252.42])
	by svr1.postgresql.org (Postfix) with SMTP id AA34D30FF01
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 11:00:31 -0300 (ADT)
Received: (qmail 25630 invoked from network); 26 Jun 2003 14:00:32 -0000
Received: from biglumber.com (HELO localhost) (207.228.252.42)
	by 0 with SMTP; 26 Jun 2003 14:00:32 -0000
From: greg@turnstep.com
To: pgsql-interfaces@postgresql.org
Subject: Re: Perl
X-PGP-Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
X-Request-PGP: 
 http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
In-Reply-To: <000401c33bc6$29b8dbd0$ae4990d5@pcguru>
Date: Thu, 26 Jun 2003 14:00:32 -0000
X-Mailer: JoyMail 1.37
Message-ID: <f52b228c785a6407e6c024ab155b4e5f@biglumber.com>
X-Archive-Number: 200306/77
X-Sequence-Number: 4288


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Sorry if i ask you, but reading the past messages didn't help me
> I'm trying to configure dbmirror for my PostgreSQL 7.3.3 installation, but
> when i try to execute the DBMirror.sql, i get the error:
>
> Can't locate Pg.pm in @INC (@INC contains:

Pg.pm is the PostgreSQL version of the DBI driver for Perl. You can install 
it from here:

http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?site=ftp.funet.fi;modinfo=4348


Once installed, you should no longer see the error above. If you have any 
problems, feel free to email the list.


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200306260955

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE++vwwvJuQZxSWSsgRAgdPAJoDjwB0DgyGfWh903rC4H7Hyx4H1QCg87tZ
qf2SmFqvDACyua1hG1/VEqc=
=0xrA
-----END PGP SIGNATURE-----





From giorgio@opla.it Thu Jun  26 15:01:57 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id B386330FEFD
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 15:01:57 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 66248-07
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 12:01:47 -0300 (ADT)
Received: from smtp1.reteitaly.com (ns2.reteitaly.com [213.144.81.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 513F230FF79
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 12:01:46 -0300 (ADT)
Received: from smtp.intranet.reteitaly.com (unknown [213.144.73.139])
	by smtp1.reteitaly.com (Postfix) with ESMTP id 21022D710A
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 17:01:45 +0200 (CEST)
Received: from pcguru (unknown [213.144.73.174])
	by smtp.intranet.reteitaly.com (Postfix) with SMTP id A67CC45DF00
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 17:01:44 +0200 (CEST)
Message-ID: <035c01c33bf3$daaedb10$ae4990d5@pcguru>
From: "Giorgio Ponza" <giorgio@opla.it>
To: <pgsql-interfaces@postgresql.org>
References: <f52b228c785a6407e6c024ab155b4e5f@biglumber.com>
Subject: Re: Perl
Date: Thu, 26 Jun 2003 17:01:42 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Archive-Number: 200306/78
X-Sequence-Number: 4289

Tx for the answer, i found also this link
http://gborg.postgresql.org/project/pgperl/projdisplay.php
i installed and now it works (not yet dbmirror, but i am trying)

I will try all the two
Tx again
Giorgio Ponza

You wrote:
> Pg.pm is the PostgreSQL version of the DBI driver for Perl. You can
install
> it from here:
>
>
http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?site=ftp.funet.fi;modinfo=
4348
>
>
> Once installed, you should no longer see the error above. If you have any
> problems, feel free to email the list.





From kkeller-postgres@wombat.san-francisco.ca.us Thu Jun  26 15:02:19 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 9BAD030FF1B
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 15:02:19 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 66491-06
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 12:02:09 -0300 (ADT)
Received: from wombat.san-francisco.ca.us (wombat.san-francisco.ca.us
	[66.92.2.169])
	by svr1.postgresql.org (Postfix) with SMTP id C914030FF6A
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 12:02:04 -0300 (ADT)
Received: (qmail 9979 invoked from network); 26 Jun 2003 15:02:03 -0000
Received: from beluga-air.334ney.net (HELO localhost.localdomain)
	(192.168.1.31)
	by wombat.san-francisco.ca.us with SMTP; 26 Jun 2003 15:02:03 -0000
Date: Thu, 26 Jun 2003 08:02:03 -0700
From: Keith Keller <kkeller-postgres@wombat.san-francisco.ca.us>
To: pgsql-interfaces@postgresql.org
Subject: Re: Perl
Message-ID: <20030626150203.GA2493@wombat.san-francisco.ca.us>
References: <000401c33bc6$29b8dbd0$ae4990d5@pcguru>
	<f52b228c785a6407e6c024ab155b4e5f@biglumber.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <f52b228c785a6407e6c024ab155b4e5f@biglumber.com>
User-Agent: Mutt/1.4i
X-Archive-Number: 200306/79
X-Sequence-Number: 4290

On Thu, Jun 26, 2003 at 02:00:32PM -0000, greg@turnstep.com wrote:
> 
> > Sorry if i ask you, but reading the past messages didn't help me
> > I'm trying to configure dbmirror for my PostgreSQL 7.3.3 installation, but
> > when i try to execute the DBMirror.sql, i get the error:
> >
> > Can't locate Pg.pm in @INC (@INC contains:
> 
> Pg.pm is the PostgreSQL version of the DBI driver for Perl.

Actually, Pg.pm is also a non-DBI interface to PostgreSQL:

http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?site=ftp.funet.fi;modinfo=14303

If the script has "use Pg;", then this is the module you need.  If it
says "use DBI;", then you need the first module Greg mentioned.

--keith

-- 
kkeller@speakeasy.net
alt.os.linux.slackware FAQ:  http://wombat.san-francisco.ca.us/cgi-bin/fom