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: (view raw, whole thread or download thread mbox)
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
-nThe system cannot find the file specified.
cpp0.exe: output pipe has been closed 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

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

Hello Jason,

We previously communicated on the following post about a week ago:

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  (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, 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?

- I am not able to load the perl module in my cgi scripts.  There are
many posts regarding this issue... See for more

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 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 module.  I can see the module in my
d:\cygin\usr\src\postgresql-7.1.1\src\interfaces\perl5\ - 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
# -*- perl -*-   to tell emacs that this is a perl script
# Include any additional modules
push (@INC,

#also trying forward slash...
#push (@INC,

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 .

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,



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-2017 The PostgreSQL Global Development Group