Skip site navigation (1) Skip section navigation (2)

Re: RE: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl

From: s0lao(at)netscape(dot)net (S(dot) L(dot))
To: rsharma(at)bigstep(dot)net
Cc: s0lao(at)netscape(dot)net, Jason(dot)Tishler(at)dothill(dot)com, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: RE: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl
Date: 2001-06-12 05:29:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin
Rishi Sharma <rsharma(at)Bigstep(dot)net> wrote:
> SLao,
> Let me try to clarify...the perl scripts try to load the module by
> stating "use Pg".  You say this should be a binary file?  I found a few
> copies of under .../perl/src or something like that, but it was ascii
> text, I didn't dig too deep in to what it was doing.

Ok, then it's clear your scripts are using the Pg driver bundled with PostgreSQL. 

> I've found this from
> symbolstone (
> hopefully it's all I need.

From the point the above affirmation was made, any reference to DBI/DBD drivers becomes redundant. If your scripts use the Pg driver, migrating to DBI/DBD::Pg driver could be difficult, as they should be (quite some more than) batch changed.

> If I install postgresql-7.1.2 from Jason and drop in the libpq.dll and
> Pg.dll in my winnt/system32 should I be able to access my database from cgi
> scripts with simply stating "use Pg"??
> There seems to be something missing here...

Maybe yet another comment :) You must not forget to place somewhere so that Perl is able to find it. I think the layout with libpq.dll and pg.dll in winnt/system32 is viable. But, anyway, for any eventual problems, here's what "make install" in "src/interfaces/perl" produces:

$ ls -lR /usr/local/lib/perl5/site_perl/5.6.0/cygwin/
total 9
-r--r--r--   1 lao      544         18124 Sep 27  1998
drwxr-xr-x   3 lao      544             0 Jun 11 08:57 auto

total 0
drwxr-xr-x   2 lao      544             0 Jun 11 08:57 Pg

total 83
-r--r--r--   1 lao      544             0 Jun 11 08:57
-r-xr-xr-x   1 lao      544         73728 Jun 11 08:57 Pg.dll
-r--r--r--   1 lao      544            81 Jun 11 08:57 autosplit.ix
-r--r--r--   1 lao      544         93106 Jun 11 08:57 libPg.a

I think that a link to winnt/system32/Pg.dll in /usr/local/lib/perl5/site_perl/5.6.0/cygwin/auto/Pg could solve any (eventual) Perl instalation issues.

Good luck!

Get your own FREE, personal Netscape Webmail account today at

In response to

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-06-12 12:14:02
Subject: Re: tourble migrating from linux/Apache/postgresql/perl to win200 0/II S/postgresql/perl
Previous:From: Robby SlaughterDate: 2001-06-12 00:52:27
Subject: RE: Getting started on W2K installation of postgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group