Thread
-
Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor
Henshall, Stuart - WCP <shenshall@westcountrypublications.co.uk> — 2001-10-24T12:40:23Z
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 -
Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor
Steven Vajdic <steven.vajdic@motorola.com> — 2001-10-25T02:31:33Z
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 >