Re: Installing postgresql on Windows question

Magnus,

Thanks a lot for your detailed reply. 2 more questions:

How do I apply the patch? (I've got the SIGCHLD handling one and the
readdir() one. )

For the initdb:ing problem (stat/inode issue), on the win32 status page
there is a link "submitted" that's supposed to point
to a patch by claudio? But it's actually pointing to
http://momjian.postgresql.org/main/writings/pgsql/.

ps. So supposedly all 3 patched should be applied before "make", right?

Many thanks,

Wei

----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Wei Wang" <ww220@cam.ac.uk>; <pgsql-hackers-win32@postgresql.org>
Sent: Friday, February 06, 2004 10:22 PM
Subject: RE: [pgsql-hackers-win32] Installing postgresql on Windows question


>Now I did "configure --without-zlib --enable-debug
>--enable-cassert" and
>then "make".
>psql  will run under CMD.EXE.  psql does not work using the
>Msys console
>application because of buffering problems.
>
>Now I'm confused it didn't say anything about "make install".
>Does that mean
>it is not needed in Windows installation?
>But I cannot find where the database is. Can anyone give me
>some direction?

Those parts are the same as for unix. Meaning you just run "make
install" and it will end up in "/usr/local/pgsql" (in the mingw
environment). Depending on exactly how your environment is, you will
probably have to tweak around the PATH variable so the postmaster can
find it's backend executable.

You will then have to run initdb just as on Unix. See the win32 status
page for either a patch or a workaround around the problem of
initdb:ing. You can pick whatever data directory you chose. Also, the
readdir() workaround/patch is required to get anything working at all.

Finally, start the postmaster manually from the directory where it was
installed.

Note that if you haven't applied the signals handling patches to your
tree, the system will not shut down correctly. So after each shut down,
you will have to manually kill any remaining backends from the task
manager.


Expect a non-trivial amount of manual things that are not documented
still, since this port is still very much under early development.


//Magnus