Thread

  1. Postgres 7.1.3. installation on Windows platforms

    Steven Vajdic <svajdic@asc.corp.mot.com> — 2001-10-23T01:50:55Z

    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
    ----------------------------------------
    
    ***********************************************