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/w...ect/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)qsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63d2)qsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63e0)qsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63ee)qsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x63fc)qsignal.c: undefined reference to `sigmask'
libpq/SUBSYS.o(.text+0x640a)qsignal.c: more undefined references to
`sigmask'
follow
port/SUBSYS.o(.text+0x6db)g_sema.c: undefined reference to `kill'
port/SUBSYS.o(.text+0x16ba)g_shmem.c: undefined reference to `kill'
postmaster/SUBSYS.o(.text+0xf36)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x12f6)ostmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x1b55)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x1b88)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x1c53)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2c66)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2c80)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x2e29)ostmaster.c: more undefined references to
`sigsetmask' follow
postmaster/SUBSYS.o(.text+0x30be)ostmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x30cd)ostmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x3192)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x34d5)ostmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x360a)ostmaster.c: undefined reference to
`WIFEXITED'
postmaster/SUBSYS.o(.text+0x3645)ostmaster.c: undefined reference to
`WEXITSTATUS'
postmaster/SUBSYS.o(.text+0x3675)ostmaster.c: undefined reference to
`WIFSIGNALED'
postmaster/SUBSYS.o(.text+0x36a1)ostmaster.c: undefined reference to
`WTERMSIG'
postmaster/SUBSYS.o(.text+0x3769)ostmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x384c)ostmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x3cf9)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x3e16)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x431b)ostmaster.c: undefined reference to
`sigsetmask'
postmaster/SUBSYS.o(.text+0x43a5)ostmaster.c: undefined reference to
`sigsetmask'

postmaster/SUBSYS.o(.text+0x466e)ostmaster.c: undefined reference to
`fork'
postmaster/SUBSYS.o(.text+0x2a0b)ostmaster.c: undefined reference to
`kill'
postmaster/SUBSYS.o(.text+0x4fd0)gstat.c: undefined reference to `pipe'
postmaster/SUBSYS.o(.text+0x51c4)gstat.c: undefined reference to `fork'
postmaster/SUBSYS.o(.text+0x6103)gstat.c: undefined reference to `pipe'
postmaster/SUBSYS.o(.text+0x6113)gstat.c: undefined reference to `fork'
postmaster/SUBSYS.o(.text+0x6906)gstat.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)msignal.c: undefined reference to `getppid'
storage/SUBSYS.o(.text+0x7720)msignal.c: undefined reference to `kill'
storage/SUBSYS.o(.text+0xc283)roc.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)ostgres.c: undefined reference to `sigsetmask'
tcop/SUBSYS.o(.text+0x4e76)ostgres.c: undefined reference to `sigmask'
tcop/SUBSYS.o(.text+0x4e8e)ostgres.c: undefined reference to `sigsetmask'
tcop/SUBSYS.o(.text+0x50d1)ostgres.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):getaddrinf o.c:
undefined reference to `gethostbyname@4'
.../../src/port/libpgport.a(getaddrinfo.o)(.text+0x1c0):getaddrinf o.c:
undefined reference to `WSAGetLastError@0'
.../../src/port/libpgport.a(getaddrinfo.o)(.text+0x3d0):getaddrinf o.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/


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

And that's where you went wrong. PostgreSQL for win32 in source form is
(currently) only in cvs head.

Download source from cvs, or download the binaries referred to in the above
link.

Cheers,
Claudio

---
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
<a
href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em
ailpolicy.html</a>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings