Thread: Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor

Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor

From
"Henshall, Stuart - WCP"
Date:
Hello,
    Did you try the snapshot I mentioned (available at www.cygwin.com )?
I got exactly the same problem with cygwin-1.3.3-2 until I used a snapshot.
This is on a windows 98SE machine. (Of course I only consider it a
development platform and wouldn't actually put a production server on a 9x
machine).
- Stuart

> -----Original Message-----
> From:    Steven Vajdic [SMTP:Steven.Vajdic@motorola.com]
> Sent:    Thursday, October 25, 2001 3:32 AM
> To:    Henshall, Stuart - WCP; steven_vajdic@ivillage.com
> Cc:    pgsql-general@postgresql.org; pgsql-cygwin@postgresql.org;
> pgsql-cygwyn@postgresql.org
> Subject:    Re: [GENERAL] Postgres 7.1.3. installation on Windows
> platfor
>
> Stuart,
>
> Thanks, yet I am not succeeding. I am trying on Win98, I might try on
> Win2000.
>
> Briefly:
>
> 1. cygwin from http://sources.redhat.com/cygwin DOES download and install
> both "postgres.exe" and "psql.exe" version 7.1.3-1 (in BOTH /usr/bin AND
> /bin directories!!!???).
> A symbolic link to run "postgres.exe" via postmaster also exists.
> The PATH first goes to /usr/bin and so it runs both from there.
>
> 2. cigipc-1.10.1.tar.bz2 is "bunzip2"-ed and "untar"-red in "/" (root)
> directory and it installs "ipc-daemon.exe" in "/usr/local/bin".
>
> 3. So, the procedure to instal PostgreSQL from its original form
> "postgresql-7.1.3.tar.gz" is skipped.
>
> 4. Run "ipc-daemon" OK (NOTE you have to run this BEFORE you run "initdb")
>
> 5. mkdir /usr/local/pgsql/data (MUST in order to run "initdb").
>
> 6. "initdb" completes properly
>
> 7. Postmaster -i & runs properly
>
> 8. "psql -l" or "psql template1" fails with:
>  pg_flush: send() failed: The descriptor is a file, not a socket
>  pg_recvbuf: recv() failed: The descriptor is a file, not a socket
>
> Maybe, just maybe, I do not have something at the right place.
>
> It is becoming annoying.
>
> Steven.
>
>
> ----- Original Message -----
> From: Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
> To: <steven_vajdic@ivillage.com>
> Cc: <pgsql-general@postgresql.org>; <pgsql-cygwin@postgresql.org>
> Sent: Wednesday, October 24, 2001 10:10 PM
> Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor
>
>
> > 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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >