Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
Sender: cygwin-owner AT sourceware DOT cygnus DOT com
Delivered-To: mailing list cygwin AT sourceware DOT cygnus DOT com
Message-ID: <2E7F82FAC1FCD2118E1500A024B3BF907DECF9@exchange.mmp.plzen-city.cz>
From: Horak Daniel <horak AT mmp DOT plzen-city DOT cz>
To: "'Christian Jullien'" <Eligis AT wanadoo DOT fr>,
        "'cygwin AT sourceware DOT cygnus DOT com'" <cygwin AT sourceware DOT cygnus DOT com>
Subject: RE: Postgresql 6. 5 cygwin  ports available ?
Date: Thu, 17 Jun 1999 10:00:48 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
	charset="iso-8859-1"

> 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 AT askesis DOT nl>
To: "Pgsql-Ports AT Postgresql. Org" <pgsql-ports AT postgreSQL DOT org>
Subject: RE: [PORTS] Re: psql under win32
Date: Wed, 21 Apr 1999 07:07:47 +0200
Message-ID: <000001be8bb4$e59b0ab0$0300a8c0 AT abraracourcix DOT askesis DOT 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 AT sourceware DOT cygnus DOT com