Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms - Mailing list pgsql-hackers
From | Steven Vajdic |
---|---|
Subject | Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms |
Date | |
Msg-id | 001501c15bbd$717c4280$4500a8c0@Steven Whole thread Raw |
List | pgsql-hackers |
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 > 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 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 > >---------------------------------------- > > > >*********************************************** > > > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 6: Have you searched our list archives? > > > >http://archives.postgresql.org >
pgsql-hackers by date:
Previous
From: "Ron de Jong"Date:
Subject: Re: Is there no "DESCRIBE