RE: Postgresql 6. 5 cygwin ports available ?

[Horak Daniel <horak@mmp.plzen-city.cz>]

> Looking for a good SQL Database, I was waiting for Posgresql 6.5 that
> authors claim to be compatible with cygwin. It's _not_ ! or 
> at an expensive
> port cost.

I have to say that it works (but sometimes it dies when it tries to run a
new process). I am one of the authors.

> 
> See http://www.postgresql.org/index.html
> 
> Using cygwin 20.1 on NT4 SP5 it fails on the very first steps 
> (./configure
> !!)
> 
> First, it requires cygwin32_ipc otherwise ./configure stops 
> saying that gcc
> does not work.
> 
> After a _lot_ of patches in Makefile distrib, I finally give 
> up on an error
> in sem.h
> 
> Is there somewhere a _working_ port available in binary form 
> or a diff that
> makes the distribution works?

Binaries are not yet available. But for compiling you don't need any
additional patches, I have tested 6.5beta1.

There is a step-by-step manual at
http://members.tripod.com/~kevlo/postgres/portNT.html. But when you mount
all your disks in binary mode it is a bit simpler:
- install Cygwin from full.exe
- install cygipc package and crypt library, headers and libs into the cygwin
tree (links are at the metioned URL)
- install additional headers from src/win32 as described in src/win32/README
- run ./configure; make; make install; ... as described in docs for
PostgreSQL


this is README.NT from the latest development snapshot (after release of
6.5)
----------------------------------------------------------------------------
--
From: "Joost Kraaijeveld" <JKraaijeveld@askesis.nl>
To: "Pgsql-Ports@Postgresql. Org" <pgsql-ports@postgreSQL.org>
Subject: RE: [PORTS] Re: psql under win32
Date: Wed, 21 Apr 1999 07:07:47 +0200
Message-ID: <000001be8bb4$e59b0ab0$0300a8c0@abraracourcix.askesis.nl>
MIME-Version: 1.0

Installing PostgreSQL on NT:

---------------------------------------------------------------------------

It can be done by done by typing configure, make and make install.

1. Install the Cygwin package
2. Update to EGCS 1.1.2

1. Install the Andy Piper Tools

1. Download the Cygwin32 IPC Package by Ludovic LANGE.
2. Untar the package and follow the readme instructions.
3. I tested 1.03.
4. I used the \cygwin-b20\h-i568-cygwin32\i586-cygwin32\lib and
\cygwin-b20\h-i568-cygwin32\i586-cygwin32\include\sys instead of the
/usr/local/lib and usr/local/include/sys.

1. Download the current snapshot.tar.gz (24-3-98).
2. Untar the package.
3. Copy the files from \pgsql\src\win32 according to the readme file.
3. Edit \pgsql\src\template\cygwin32 if needed (I had to adjust the YFLAGS
path).
4. ./configure
5. make
6. create the directory /usr/local/pgsql manually: the mkdir cannot create a
directory 2 levels deep in one step.
7. make install
8. cd /usr/lical/pgsql/doc
9. make install
10. Set the environmental data
11. Initdb --username=jkr (do not run this command as administrator)

12. Open a new Cygwin command prompt
13. Start "ipc-deamon&" (background proces)
14. Start "postmaster -i 2>&1 > /tmp/postgres.log &" (background proces)
15. Start "tail -f /tmp/postgres.log" to see the messages

16. cd /usr/src/pgsql/src/test/regress
17. make all runtest
----------------------------------------------------------------------------
--

			Dan

--
Want to unsubscribe from this list?
Send a message to cygwin-unsubscribe@sourceware.cygnus.com