I was trying to get postgresql to run / build on a windows system.
Following the instructions to get Mingw32 and MSys as directed on the site -
http://momjian.postgresql.org/main/writings/pgsql/project/win32.html
These are the steps I followed.
I downloaded MINGW32 and MSys and installed then.
Then downloaded postgresql-7.4.3.tar.gz from the ftp site.
uncompresses it and ran configure.
Ran configure --without-zlib
At this point configure completed successfully.
then ran make
This ran for a while then failed and said there was no native spinlock
support on the system and to rerun configure with --disable-spinlocks
So I reran configure.
It completed.
I reran make.
It failed again. the last output before and including the errors was :
C:/msys/1.0/mingw/mingw32/bin/ld.exe -r -o SUBSYS.o fmgrtab.o adt/SUBSYS.o
cache/SUBSYS.o error/SUBSYS.o fmgr/SUBSYS.o hash/SUBSYS.o init/SUBSYS.o
misc/SUBSYS.o mmgr/SUBSYS.o sort/SUBSYS.o time/SUBSYS.o mb/SUBSYS.o
make[3]: Leaving directory
`/home/Owner/psql/postgresql-7.4.3/src/backend/utils'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -L../../src/port access/SUBSYS.o
bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o
optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o
rewrite/SUBSYS.o storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o -lreadline
-lwsock32 -lm -lpgport -o postgres
bootstrap/SUBSYS.o(.text+0x3f02):bootstrap.c: undefined reference to
`sigsetmask'
commands/SUBSYS.o(.text+0x372e):async.c: undefined reference to `kill'
libpq/SUBSYS.o(.text+0x63c4):pqsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63d2):pqsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63e0):pqsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63ee):pqsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63fc):pqsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x640a):pqsignal.c: more undefined references to
`sigmask'
follow
port/SUBSYS.o(.text+0x6db):pg_sema.c: undefined reference to `kill'
port/SUBSYS.o(.text+0x16ba):pg_shmem.c: undefined reference to `kill'
postmaster/SUBSYS.o(.text+0xf36):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x12f6):postmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x1b55):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x1b88):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x1c53):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2c66):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2c80):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2e29):postmaster.c: more undefined references to
`sigsetmask' follow
postmaster/SUBSYS.o(.text+0x30be):postmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x30cd):postmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x3192):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x34d5):postmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x360a):postmaster.c: undefined reference to
`WIFEXITED'
postmaster/SUBSYS.o(.text+0x3645):postmaster.c: undefined reference to
`WEXITSTATUS'
postmaster/SUBSYS.o(.text+0x3675):postmaster.c: undefined reference to
`WIFSIGNALED'
postmaster/SUBSYS.o(.text+0x36a1):postmaster.c: undefined reference to
`WTERMSIG'
postmaster/SUBSYS.o(.text+0x3769):postmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x384c):postmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x3cf9):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x3e16):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x431b):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x43a5):postmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x466e):postmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x2a0b):postmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x4fd0):pgstat.c: undefined reference to `pipe'
postmaster/SUBSYS.o(.text+0x51c4):pgstat.c: undefined reference to `fork'
postmaster/SUBSYS.o(.text+0x6103):pgstat.c: undefined reference to `pipe'
postmaster/SUBSYS.o(.text+0x6113):pgstat.c: undefined reference to `fork'
postmaster/SUBSYS.o(.text+0x6906):pgstat.c: undefined reference to
`sigsetmask'
storage/SUBSYS.o(.text+0x30c2):fd.c: undefined reference to `fsync'
storage/SUBSYS.o(.text+0x30e2):fd.c: undefined reference to `fsync'
storage/SUBSYS.o(.text+0x41c0):fd.c: undefined reference to `ftruncate'
storage/SUBSYS.o(.text+0x7718):pmsignal.c: undefined reference to `getppid'
storage/SUBSYS.o(.text+0x7720):pmsignal.c: undefined reference to `kill'
storage/SUBSYS.o(.text+0xc283):proc.c: undefined reference to `kill'
storage/SUBSYS.o(.text+0xeff6):md.c: undefined reference to `sync'
storage/SUBSYS.o(.text+0xf004):md.c: undefined reference to `sync'
tcop/SUBSYS.o(.text+0x339d):postgres.c: undefined reference to `sigsetmask'
tcop/SUBSYS.o(.text+0x4e76):postgres.c: undefined reference to `sigmask'
tcop/SUBSYS.o(.text+0x4e8e):postgres.c: undefined reference to `sigsetmask'
tcop/SUBSYS.o(.text+0x50d1):postgres.c: undefined reference to `sigsetmask'
utils/SUBSYS.o(.text+0x76b64):miscinit.c: undefined reference to `kill'
../../src/port/libpgport.a(random.o)(.text+0x5):random.c: undefined
reference to `lrand48'
../../src/port/libpgport.a(getaddrinfo.o)(.text+0x185):getaddrinfo.c:
undefined reference to `gethostbyname@4'
../../src/port/libpgport.a(getaddrinfo.o)(.text+0x1c0):getaddrinfo.c:
undefined reference to `WSAGetLastError@0'
../../src/port/libpgport.a(getaddrinfo.o)(.text+0x3d0):getaddrinfo.c:
undefined reference to `inet_ntoa@4'
../../src/port/libpgport.a(srandom.o)(.text+0x5):srandom.c: undefined
reference to `srand48'
make[2]: *** [postgres] Error 1
make[2]: Leaving directory `/home/Owner/psql/postgresql-7.4.3/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/Owner/psql/postgresql-7.4.3/src'
make: *** [all] Error 2
BTW running on a windows XP home OS, 2.4ghz
I hope this is a useful error report.
If you'd like any further info or clarifications email me back and i'll try
to help.
For now I'm just going to try the Win32 install using Cygwin instructions.
CHeers.
Chris
_________________________________________________________________
Open an Online Savings Account today & collect a bonus $30*!
http://clk.atdmt.com/1DG/go/hsb005000991dg/direct/01/
