Re: Installing postgresql on Windows question

From: "Wei Wang" <ww220(at)cam(dot)ac(dot)uk>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Installing postgresql on Windows question
Date: 2004-02-06 23:01:38
Message-ID: 001801c3ed05$2d3ba990$e164e880@weiwang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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(at)sollentuna(dot)net>
To: "Wei Wang" <ww220(at)cam(dot)ac(dot)uk>; <pgsql-hackers-win32(at)postgresql(dot)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

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Ronald Kuczek 2004-02-07 00:10:14 Psql linking
Previous Message Magnus Hagander 2004-02-06 22:32:06 Re: [PATCHES] win32 signals, part 5