Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor - Mailing list pgsql-cygwin

pgsql-cygwin@postgresql.org is probably a better list for this (assuming you
are wanting the server running).
    The instructions on building using MSVC are for the client side
libraries, for the server stuff you need cygwin.
    I just checked and the latest cygwin does seem to come with
postgresql. However its worth noting that it installs to a different place
than the tarball's default.
    I do know that there was a problem with compiling psql against
readline 4.2 in postgresql 7.1.2, but I'm not sure if that is the case with
7.1.3 .
    Also I can't remeber the exact error but the socket error does look
vaguely familiar from when I upgraded to cygwin v1.3.3. I'm currently using
the following snapshot:
cygwin1-20011020.dll.bz2
which seems to be working for me.
hope this helps,
- Stuart

> -----Original Message-----
> From:    steven_vajdic@ivillage.com [SMTP:steven_vajdic@ivillage.com]
> Sent:    Tuesday, October 23, 2001 1:31 PM
> To:    pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
> Subject:    Fwd: Re: [GENERAL] Postgres 7.1.3. installation on Windows
> platforms
>
> ------- Start of forwarded message -------
>
> To: <svajdic@asc.corp.mot.com>, "tek1" <tek1@pobox.com>,
>     <steven_vajdic@ivillage.com>
> Cc: <pgsql-hackers@postgresql.org>, <pgsql-general@postgresql.org>
> Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms
> From: "Steven Vajdic" <Steven.Vajdic@motorola.com>
> Date: Tue, 23 Oct 2001 21:52:51 +0930
>
> 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
> >
>
> ------- End of forwarded message -------
>
> _________________________________________________________________
> iVillage.com: Solutions for Your Life
> Check out the most exciting women's community on the Web
> http://www.ivillage.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster