Thread: PostgreSQL 7.1.3 installation on Windows platforms

PostgreSQL 7.1.3 installation on Windows platforms

From
"Steven Vajdic"
Date:
Dear all,
 
I am trying to install PostgreSQL 7.1.3 on Win98 with APACHE
and PHP (both installed and running), and
am getting errors with "make" and "make install" (see below).
 
What are the differences in installations for Win98, WinNT and Win2000?
There are so many procedures around and none is working without problems.
 
I installed Cygwin to emulate UNIX environment and Cygwin IPC to
support the linker (ld.exe).
 
I dowloaded "postgresql-7.1.3.tar.gz".
 
"./configure" finished properly with "un.h" and "tcp.h" installed BUT
without "endian.h" (is this important ???)
 
I also copied "libpostgres.a" into "/usr/local/lib".
 
There are some  Windows Makefiles ("../src/win32.mak" and "../src/makefiles/Makefile.win) - Do I need to run some and how and when.
 
I can run "postmaster -i&" after IMPROPER installation BUT "psql" does not work.
 
Also, PHP commands of type "pg_*" are not recognised. I turned ON (I believe) PHP-Postgres in "php.ini" file residing in Windows dir by allowing "extension=php_pgsql.dll".
 
 
What is WRONG?
 
Many thanks,
 
Steven.
 
****************
"make" and "make install" ERRORS:
 
....
 
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o common.o help.o input.o stringutils.o mainloop.o copy.o startup.o prompt.o variables.o large_obj.o print.o describe.o tab-complete.o -L../../../src/interfaces/libpq -lpq -L/usr/local/lib -g -lz -lcrypt -lreadline -lcygipc -o psql
 
tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to `filename_completion_function'
 
collect2: ld returned 1 exit status
 
make[3]: *** [psql] Error 1
 
make[3]: Leaving directory `/usr/src/postgresql-7.1.3/src/bin/psql'
 
make[2]: *** [all] Error 2
 
make[2]: Leaving directory `/usr/src/postgresql-7.1.3/src/bin'
 
make[1]: *** [all] Error 2
 
make[1]: Leaving directory `/usr/src/postgresql-7.1.3/src'
 
make: *** [all] Error 2
 
 
****************