Re: Postgres 7.1.3. installation on Windows platforms

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(at)pobox(dot)com>
To: <svajdic(at)asc(dot)corp(dot)mot(dot)com>
Sent: Tuesday, October 23, 2001 1:32 AM
Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms

> 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(at)postgresql(dot)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 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(dot)Vajdic(at)motorola(dot)com
> >email: svajdic(at)asc(dot)corp(dot)mot(dot)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(at)ivillage(dot)com
> >Home address: 6 Allawah Av., Glen Osmond SA 5064, Australia
> >----------------------------------------
> >
> >***********************************************
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >http://archives.postgresql.org
>