Thread: Compiling 7.1.3 pgsql under cygwin 1.3 on W2000 errors

This is my first attempt at using cygwin so that I can try and compile
pgsql for Windows 2000.

pgsql source 7.1.3
cygwin 1.3.9
gcc  2.95.3-5
cygipc 1.09.2
Windows 2000 SP1

I followed the instructions about Win2000 installation of the postmaster at

http://people.freebsd.org/~kevlo/postgres/portNT.html

I had to re-download extra packages for cygwin after I realised there were
dependencies missing in the basic cygwin download.

Anyway I've now got to the point where the 'make' instruction writes errors
to STDERR, see below. nothing appears in /usr/local/pgsql/bin under the
cygwin directory.

I have tried the archives of this email-newsgroup but the server fails
sending me 'unavailable' after I try to search (archives.postgresql.org).

Any pointers on what I am doing wrong, would be much appreciated. I also
include output of configure process underneath (both STDOUT and STDERR).

Please let me know if I have to supply any other info to aid working out
the problems. Thank you in advance for any help you can provide.

Tim Finch, Manchester, UK.

----- make errors :
crypt.c: In function `crypt_verify':
crypt.c:286: warning: implicit declaration of function `crypt'
crypt.c:286: warning: pointer/integer type mismatch in conditional expression
password.c: In function `verify_password':
password.c:88: warning: implicit declaration of function `crypt'
password.c:88: warning: passing arg 1 of `strcmp' makes pointer from
integer without a cast
dlltool: port/SUBSYS.o: no symbols
fe-auth.c: In function `pg_password_sendauth':
fe-auth.c:439: warning: implicit declaration of function `crypt'
fe-auth.c:439: warning: assignment makes pointer from integer without a cast
pgc.c: In function `yylex':
pgc.c:1244: warning: label `find_rule' defined but not used
pgc.l: At top level:
pgc.c:3091: warning: `yy_flex_realloc' defined but not used
pg_passwd.o(.text+0x763):pg_passwd.c: undefined reference to `crypt'
collect2: ld returned 1 exit status
make[3]: *** [pg_passwd] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
-----

------configure output:
loading cache ./config.cache
checking host system type... i686-pc-cygwin
checking which template to use... win
checking whether to build with locale support... no
checking whether to build with recode support... no
checking whether to build with multibyte character support... no
checking whether to build with Unicode conversion support... no
checking for default port number... 5432
checking for default soft limit on number of connections... 32
checking for gcc... (cached) gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
using CFLAGS=-O2
checking whether the C compiler (gcc -O2 ) works... yes
checking whether the C compiler (gcc -O2 ) is a cross-compiler... no
checking for Cygwin environment... (cached) yes
checking for mingw32 environment... (cached) no
checking for executable suffix... (cached) .exe
checking how to run the C preprocessor... (cached) gcc -E
checking whether gcc needs -traditional... (cached) no
checking whether to build with Tcl... no
checking whether to build with Tk... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build Java/JDBC tools... no
checking whether to build the ODBC driver... no
checking whether to build C++ modules... no
using CPPFLAGS=  -I/usr/local/include
using LDFLAGS=  -L/usr/local/lib
checking for mawk... (cached) gawk
checking for flex... (cached) no
checking whether ln -s works... (cached) yes
checking for ld used by GCC... (cached) /usr/i686-pc-cygwin/bin/ld.exe
checking if the linker (/usr/i686-pc-cygwin/bin/ld.exe) is GNU ld...
(cached) yes
checking for ranlib... (cached) ranlib
checking for lorder... no
checking for tar... (cached) /usr/bin/tar
checking for perl... no
checking for bison... (cached) bison -y
checking for readline... (cached) yes (-lreadline)
checking for library containing using_history... (cached) none required
checking for main in -lbsd... (cached) no
checking for setproctitle in -lutil... (cached) no
checking for main in -lm... (cached) yes
checking for main in -ldl... (cached) no
checking for main in -lsocket... (cached) no
checking for main in -lnsl... (cached) no
checking for main in -lipc... (cached) no
checking for main in -lIPC... (cached) no
checking for main in -llc... (cached) no
checking for main in -ldld... (cached) no
checking for main in -lld... (cached) no
checking for main in -lcompat... (cached) no
checking for main in -lBSD... (cached) no
checking for main in -lgen... (cached) no
checking for main in -lPW... (cached) no
checking for main in -lresolv... (cached) no
checking for main in -lunix... (cached) no
checking for library containing crypt... (cached) no
checking for __inet_ntoa in -lbind... (cached) no
checking for inflate in -lz... (cached) yes
checking for crypt.h... (cached) no
checking for dld.h... (cached) no
checking for endian.h... (cached) no
checking for fp_class.h... (cached) no
checking for getopt.h... (cached) yes
checking for ieeefp.h... (cached) yes
checking for pwd.h... (cached) yes
checking for sys/ipc.h... (cached) yes
checking for sys/pstat.h... (cached) no
checking for sys/select.h... (cached) yes
checking for sys/sem.h... (cached) yes
checking for sys/socket.h... (cached) yes
checking for sys/shm.h... (cached) yes
checking for sys/types.h... (cached) yes
checking for sys/un.h... (cached) yes
checking for termios.h... (cached) yes
checking for kernel/OS.h... (cached) no
checking for kernel/image.h... (cached) no
checking for SupportDefs.h... (cached) no
checking for netinet/in.h... (cached) yes
checking for netinet/tcp.h... yes
checking whether string.h and strings.h may both be included... (cached) yes
checking for readline/readline.h... (cached) yes
checking for readline/history.h... (cached) yes
checking for working const... (cached) yes
checking for inline... (cached) inline
checking for preprocessor stringizing operator... (cached) yes
checking for signed types... (cached) yes
checking for volatile... (cached) yes
checking whether struct tm is in sys/time.h or time.h... (cached) time.h
checking for tm_zone in struct tm... (cached) no
checking for tzname... (cached) yes
checking for union semun... (cached) yes
checking for struct sockaddr_un... (cached) yes
checking for int timezone... (cached) no
checking types of arguments for accept()... (cached) int, struct sockaddr
*, int *
checking whether gettimeofday takes only one argument... (cached) no
checking for fcvt... (cached) yes
checking for getopt_long... (cached) yes
checking for memmove... (cached) yes
checking for pstat... (cached) no
checking for setproctitle... (cached) no
checking for setsid... (cached) yes
checking for sigprocmask... (cached) yes
checking for sysconf... (cached) yes
checking for waitpid... (cached) yes
checking for dlopen... (cached) yes
checking for fdatasync... (cached) no
checking for PS_STRINGS... (cached) no
checking for snprintf... (cached) yes
checking for vsnprintf... (cached) yes
checking for isinf... (cached) yes
checking for getrusage... (cached) yes
checking for srandom... (cached) yes
checking for gethostname... (cached) yes
checking for random... (cached) yes
checking for inet_aton... (cached) yes
checking for strerror... (cached) yes
checking for strdup... (cached) yes
checking for strtol... (cached) yes
checking for strtoul... (cached) yes
checking for strcasecmp... (cached) yes
checking for cbrt... (cached) yes
checking for rint... (cached) yes
checking for rl_completion_append_character... yes
checking for rl_completion_matches... (cached) yes
checking for finite... yes
checking for sigsetjmp... yes
checking for optreset... (cached) yes
checking test program... ok
checking whether long int is 64 bits... (cached) no
checking whether long long int is 64 bits... (cached) yes
checking whether snprintf handles 'long long int' as %lld... yes
checking for strtoll... (cached) yes
checking for strtoull... (cached) yes
checking for atexit... (cached) yes
checking size of unsigned long... (cached) 4
checking alignment of short... (cached) 2
checking alignment of int... (cached) 4
checking alignment of long... (cached) 4
checking alignment of long long int... (cached) 8
checking alignment of double... (cached) 8
checking for POSIX signal interface... (cached) yes
checking for onsgmls... no
checking for nsgmls... no
updating cache ./config.cache
creating ./config.status
creating GNUmakefile
creating src/GNUmakefile
creating src/Makefile.global
creating src/backend/port/Makefile
creating src/include/config.h
src/include/config.h is unchanged
linking ./src/backend/port/dynloader/win.c to src/backend/port/dynloader.c
linking ./src/backend/port/dynloader/win.h to src/include/dynloader.h
linking ./src/include/port/win.h to src/include/os.h
linking ./src/makefiles/Makefile.win to src/Makefile.port
linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s
----

----- configure errors
configure: warning:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files.  You can obtain Flex from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
------

Tim,

On Sat, Feb 16, 2002 at 10:51:30AM +0000, Tim Finch, FosterFinch Ltd wrote:
> This is my first attempt at using cygwin so that I can try and compile
> pgsql for Windows 2000.
>
> [snip]

Why don't you just use the pre-built binary that it installable by
Cygwin's setup.exe?

    http://cygwin.com/ml/cygwin-announce/2002/msg00048.html

Jason

Jason

Thanks! I feel a bit of a duffer as I discovered this very option about 10
mins after posting my message. I have indeed used the prebuilt one. However
I have only got as far as trying to start postmaster once, which it did OK,
but then I thought I could exit Cygwin to allow postmaster to run in
background and caused myself no end of grief -- is it true that cygwin must
remain loaded whilst pgsql runs? Anyway to 'hide' the cygwin window (i.e.
not even have it minimised, or sent to the tray for example?)

Thanks

Tim.

At 21:19 16/02/2002 -0500, Jason Tishler wrote:
>Tim,
>
>On Sat, Feb 16, 2002 at 10:51:30AM +0000, Tim Finch, FosterFinch Ltd wrote:
> > This is my first attempt at using cygwin so that I can try and compile
> > pgsql for Windows 2000.
> >
> > [snip]
>
>Why don't you just use the pre-built binary that it installable by
>Cygwin's setup.exe?
>
>     http://cygwin.com/ml/cygwin-announce/2002/msg00048.html
>
>Jason