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
From: "Christian Jullien" <Eligis AT wanadoo DOT fr>
To: <cygwin AT sourceware DOT cygnus DOT com>
Subject: Postgresql 6. 5 runs on cygwin (the complete story)
Date: Sat, 19 Jun 1999 12:26:43 +0200
Message-ID: <000101beba3e$39dac590$020039c1@eligis.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I can confirm that Postgresql 6.5 works on NT. With all cards in hand, it's
not so complex.
I've heard that the current snapshot contains a README.nt which is not on
the official release, here is the roadmap that I used to make it run.

1) Prerequisit:
   Postgresql requires the following tools:

	cygwin B20.1 (I guess you know where to get full.exe :->)
	cygwin32_ipc-1.03.tar.gz (can't remember where I downloaded mine).
	libcrypt-cygwin-b20.1.tar.bz2
		ftp://sourceware.cygnus.com/pub/cygwin/xfree (~8Kbytes)
      or 	ftp://ftp.xemacs.org/pub/xemacs/aux/cygwin-b20-local.tar.bz2
(~4.5Mbytes for just libcrtpt.a)

   ./configure should test that those packages are already installed.

2) launch bash

   Check if you have a valid /etc/passwd with your user entry.

   Check if you have a valid /usr/local directory

   bash$ mkdir /usr
   bash$ mkdir /usr/local

3) uncompress postgresql using tar and gzip (winzip does not create empty
dummy.s file)

   bash$ gzip -d -c postgresql-6.5.tar.gz | tar xvf -

3) check that MAKE_MODE is set to UNIX otherwise 'if' shell command will try
to
   execute cmd.exe but not /bin/sh 'if' shell.

   bash$ export MAKE_MODE=UNIX

4) inform the user to change or check Makefile.global to reflect its current
   installation. For example; my system didn't defined /sw directory for
bison files

5) Try configure

   bash$ sh configure

5) call the build process using 'make'

   bash$ make

   If this one hangs after fews minutes after try to find libcrypt.a check
that libcrypt.a in in your path.

8) Install the software

   bash$ make install

   Everything goes to /usr/local/pqsql

9) Setup environment variables in your .bashrc

   PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin:/usr/local/pgsql/lib
   PGDATA=/usr/local/pgsql/data
   PGLIB=/usr/local/pgsql/lib
   LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib
   export LD_LIBRARY_PATH PATH PGDATA PGLIB

   bash$ source .bashrc

10) initialize the system

   initdb --username=<login>

   where <login> is already set in /etc/passwd (see point 2)

11) Edit the file /usr/local/pgsql/data/pg_hba.conf, such as:

   host        all     163.17.11.109   255.255.255.0   trust

12) Launch /usr/local/bin/ipc-daemon.exe and postmaster in background

    bash$ ipc-daemon.exe&
    bash$ postmaster -i&

    you're ready to play with postgresql

    bash$ psql -h host_name template1

    Then I got :

    Error semaphore semaphore not equal 0
    Error semaphore semaphore not equal 0
    Error semaphore semaphore not equal 0
    Error semaphore semaphore not equal 0

    But I can create, insert, select, drop a new database

Thanks, to all people that helps me to understand what's was needed by this
port and specially Joost Kraaijeveld

Eligis: Christian Jullien (OOP consultant)
10, RUE REJANE - 95120 ERMONT (France)
Eligis AT wanadoo DOT fr - +33 130.72.98.20


--
Want to unsubscribe from this list?
Send a message to cygwin-unsubscribe AT sourceware DOT cygnus DOT com