Just a little more info for you:
When trying to build the latest postgresql-7.1.2 I get the following error:
make -C doc all
make: Entering directory `/usr/src/postgresql-7.1.2/doc'
make: Nothing to be done for `all'.
make: Leaving directory `/usr/src/postgresql-7.1.2/doc'
make -C src all
make: Entering directory `/usr/src/postgresql-7.1.2/src'
make -C backend all
make: 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: Entering directory `/usr/src/postgresql-7.1.2/src/backend/utils'
CPP='gcc -E' AWK='gawk' /bin/sh.exe Gen_fmgrtab.sh
-nThe system cannot find the file specified.
cpp0.exe: output pipe has been closed
make: *** [fmgroids.h] Error 1
make: Leaving directory `/usr/src/postgresql-7.1.2/src/backend/utils'
make: *** [utils/fmgroids.h] Error 2
make: Leaving directory `/usr/src/postgresql-7.1.2/src/backend'
make: *** [all] Error 2
make: Leaving directory `/usr/src/postgresql-7.1.2/src'
make: *** [all] Error 2
where is fmgroids.h?
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
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
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?
- 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
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
# -*- perl -*- to tell emacs that this is a perl script
# Include any additional modules
#also trying forward slash...
$q = new CGI;
# Enable access to the SQL database
print "INC=" . "@INC\n";
## Close the current script
#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.
pgsql-cygwin by date
|Next:||From: Jason Tishler||Date: 2001-06-10 12:24:06|
|Subject: Re: tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl|
|Previous:||From: Rishi Sharma||Date: 2001-06-10 00:15:12|
|Subject: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl|