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(at)westcountrypublications(dot)co(dot)uk>
To: <steven_vajdic(at)ivillage(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>; <pgsql-cygwin(at)postgresql(dot)org>
Sent: Wednesday, October 24, 2001 10:10 PM
Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor

> pgsql-cygwin(at)postgresql(dot)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(at)ivillage(dot)com [SMTP:steven_vajdic(at)ivillage(dot)com]
> > Sent: Tuesday, October 23, 2001 1:31 PM
> > To: pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> > Subject: Fwd: Re: [GENERAL] Postgres 7.1.3. installation on Windows
> > platforms
> >
> > ------- Start of forwarded message -------
> >
> > To: <svajdic(at)asc(dot)corp(dot)mot(dot)com>, "tek1" <tek1(at)pobox(dot)com>,
> > <steven_vajdic(at)ivillage(dot)com>
> > Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
> > Subject: Re: [GENERAL] Postgres 7.1.3. installation on Windows platforms
> > From: "Steven Vajdic" <Steven(dot)Vajdic(at)motorola(dot)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(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
> > >
> >
> > ------- 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(at)postgresql(dot)org
>