Postgres 7.1.3. installation on Windows platforms
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
****************
--
***********************************************
Steven Vajdic (BSc/Hon, MSc)
Senior Software Engineer
Motorola Australia Software Centre (MASC)
2 Second Avenue, Technology Park
Adelaide, South Australia 5095
email: Steven.Vajdic@motorola.com
email: svajdic@asc.corp.mot.com
Ph.: +61-8-8168-3543
Fax: +61-8-8168-3501
Front Office (Ph): +61-8-8168-3500
----------------------------------------
mobile: +61 (0)419 860 903
AFTER WORK email: steven_vajdic@ivillage.com
Home address: 6 Allawah Av., Glen Osmond SA 5064, Australia
----------------------------------------
***********************************************
Thanks, but latest Cygwin installation (using internet "setup.exe"),
although saying it includes PostgreSQL, does NOT.
There is a "nmake /f win32.mak" to be run under Visual C++ explained in
PostgreSQL Docs=Windows installation in order to build "libpq.dll" which
needs to be placed into "windows/system" dir under Win98/95/ME.
Yet, some installation procedures suggest that file "pq.dll" is placed into
/usr/local/pgsql/bin. That file already exists in
"../src/interfaces/libpq/".
What is the difference between "pq.dll" and "libpq.dll"?
I have found "libpq.dll" in PHP installation, copied it to
"windows/system" - psql is not working (not built properly due to "make"
error).
Everything in my installation is fine except "make" and "make install"
(make[3]: *** [psql] Error 1, etc...).
It seems that "psql.exe" is not built properly.
"ipc-daemon" is running,
"initdb" finishes properly,
BUT "psql -l" or "psql template1" says:
pg_flush: send() failed: The descriptor is a file, not a socket
pg_recvbuf: recv() failed: The descriptor is a file, not a socket
AND (although "php.ini" file allows "extension php_pgsql.dll" and the file
is copied to "windows/system") "pg_connect" as the first command to connect
to
PostgreSQL data base is not recognised.
????
----- Original Message -----
From: tek1 <tek1@pobox.com>
To: <svajdic@asc.corp.mot.com>
Sent: Tuesday, October 23, 2001 1:32 AM
Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms
Show quoted text
try using the postgresql version (7.1.3) that comes with cygwin to avoid
the complicated installation, which a lot of people have been having
problems with.also, there's a postgresql cygwin mailing list:
pgsql-cygwin@postgresql.org
At 11:20 01/10/23 +0930, you wrote:
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 psqltab-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
****************
--
***********************************************Steven Vajdic (BSc/Hon, MSc)
Senior Software Engineer
Motorola Australia Software Centre (MASC)
2 Second Avenue, Technology Park
Adelaide, South Australia 5095
email: Steven.Vajdic@motorola.com
email: svajdic@asc.corp.mot.com
Ph.: +61-8-8168-3543
Fax: +61-8-8168-3501
Front Office (Ph): +61-8-8168-3500----------------------------------------
mobile: +61 (0)419 860 903
AFTER WORK email: steven_vajdic@ivillage.com
Home address: 6 Allawah Av., Glen Osmond SA 5064, Australia
----------------------------------------***********************************************
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Import Notes
Reference msg id not found: 4.3.2-J.20011023010101.021728d8@mail.rdc1.pa.home.com | Resolved by subject fallback