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

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

From: Rishi Sharma <rsharma(at)Bigstep(dot)net>
To: Rishi Sharma <rsharma(at)Bigstep(dot)net>, "''Jason Tishler ' '" <Jason(dot)Tishler(at)dothill(dot)com>
Cc: "''Pgsql-Cygwin ' ' '" <pgsql-cygwin(at)postgresql(dot)org>
Subject: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl
Date: 2001-06-10 00:40:51
Message-ID: F902091518C1D411985D0008C7E6566C01FE05D0@ned.bigstep.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Just a little more info for you:

When trying to build the latest postgresql-7.1.2 I get the following error:
bash-2.05$ make
make -C doc all
make[1]: Entering directory `/usr/src/postgresql-7.1.2/doc'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/src/postgresql-7.1.2/doc'
make -C src all
make[1]: Entering directory `/usr/src/postgresql-7.1.2/src'
make -C backend all
make[2]: Entering directory `/usr/src/postgresql-7.1.2/src/backend'
prereqdir=`cd parser/ >/dev/null && pwd` && \
  cd ../../src/include/parser/ && rm -f parse.h && \
  ln -s $prereqdir/parse.h .
make -C utils fmgroids.h
make[3]: Entering directory `/usr/src/postgresql-7.1.2/src/backend/utils'
CPP='gcc -E' AWK='gawk' /bin/sh.exe Gen_fmgrtab.sh
../../../src/include/catalog/
pg_proc.h
-nThe system cannot find the file specified.
cpp0.exe: output pipe has been closed
Gen_fmgrtab.sh failed
make[3]: *** [fmgroids.h] Error 1
make[3]: Leaving directory `/usr/src/postgresql-7.1.2/src/backend/utils'
make[2]: *** [utils/fmgroids.h] Error 2
make[2]: Leaving directory `/usr/src/postgresql-7.1.2/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/postgresql-7.1.2/src'
make: *** [all] Error 2
bash-2.05$


where is fmgroids.h?
-----Original Message-----
From: Rishi Sharma
To: 'Jason Tishler '
Cc: 'Pgsql-Cygwin ' '
Sent: 6/9/01 5:15 PM
Subject: tourble migrating from linux/Apache/postgresql/perl to
win2000/IIS/postgresql/perl

Hello Jason,

We previously communicated on the following post about a week ago:
http://fts.postgresql.org/db/mw/msg.html?mid=121056

I am still running into setup/config issues with postgresql and perl
under IIS.  I hope this new thread will find answers from people that
have done something similar in the past.

Just to recap: 
- cygwin/cygipc are setup properly.

- I have taken the postgresql7.0 prebuilt NT binaries from
http://www.ca.postgresql.org/ftpsite/binary/v7.0/NT.  (I could not get
the lastest source to compile on our IIS box because some include files
were not part of the tar I downloaded.  Perhaps there are external
dependencies (visual c++?) that were not incluced in the tar.  If
someone has been able to compile the latest source for win32, please
tell me where I can get it prebuilt.)

- the database has been restored from my old linux box over to the IIS
box and I can see data using psql.

- old perl scripts have been moved over and configured to run under IIS

- Fred Yankowski pointed me to www.php.net, however, I belive if I take
that route, the perl cgi's I'm trying to migrate over to win2000 will
need to be re-written using php.  I think it's probabaly best to avoid
re-writing code for this migration - any way to avoid this if I use php?



ISSUES:
- I am not able to load the perl module in my cgi scripts.  There are
many posts regarding this issue... See
http://fts.postgresql.org/db/mw/msg.html?mid=120905 for more
information.

I belive the problem is the prebuilt postgresql7.0 NT binary I
downloaded.  There should be a libpq.dll (win32) library in this package
but I only see a libpq.a (unix) library.  I don't think the Pg.pm module
can be loaded properly w/o this library - but as I noted above, I'm not
able to build it myself on my IIS box.

Another possibility is that my environment may not have the path to
right Pg.pm module.  I can see the Pg.pm module in my
d:\cygin\usr\src\postgresql-7.1.1\src\interfaces\perl5\Pg.pm - Is this
the right place for this module?  If I pring out my the @INC array - the
path seems to be in there.
--------
#here is a test cgi I am testing with
test.cgi:
#!/usr/bin/perl
# -*- perl -*-   to tell emacs that this is a perl script
# Include any additional modules
push (@INC,
"d:\\cygwin\\usr\\src\\postgresql-7.1.1\\src\\interfaces\\perl5");

#also trying forward slash...
#push (@INC,
"d:\/cygwin\/usr\/src\/postgresql-7.1.1\/src\/interfaces\/perl5");

use CGI;
$q = new CGI;
print $q->header;

# Enable access to the SQL database
#use Pg;

print "INC=" . "@INC\n";

## Close the current script
exit (0);

--------
#here is the output
INC=D:/Perl/lib D:/Perl/site/lib .
d:\cygwin\usr\src\postgresql-7.1.1\src\interfaces\perl5 
--------

I also saw some references to building an ODBC driver for postgresql -
do I need ODBC if I'm using cgi's?  I though that is necessary for
clients that are going via TCP/IP to the db (?)...

Can you help?

I will continue trying to find a solution to this in the meantime.

Best Regards,

-rishi

Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-06-10 12:24:06
Subject: Re: tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
Previous:From: Rishi SharmaDate: 2001-06-10 00:15:12
Subject: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl

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