$Id: README,v 1.8 2001/04/16 12:57:22 jt Exp $

Abstract:

This is the README for the Cygwin PostgreSQL distribution.

Requirements:

The following are required to build and/or execute Cygwin PostgreSQL:

    crypt 1.0.1
    cygipc 1.09
    readline 4.1
    zlib 1.1.3
    Cygwin DLL (i.e., cygwin1.dll) built after 2001/02/05 12:36:41

Install:

The following is the Cygwin PostgreSQL installation procedure:

1. Replace the Cygwin 1.1.8-2 DLL (i.e., cygwin1.dll) with one from a recent
   snapshot.

2. Install the latest cygipc from:

    http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/index.html

3. Install the cygipc ipc-daemon as a service, if appropriate for your platform
   (NT/2000 only):

    $ ipc-daemon --install-as-service

4. Start the cygipc ipc-daemon, as appropriate for your platform:

    $ net start ipc-daemon # NT/2000 or
    $ ipc-daemon &         # 9X/Me

5. Define the following environment variable:

    export PGDATA=/usr/share/postgresql/data

5. Initialize PostgreSQL:

    $ initdb

6. Start the PostgreSQL postmaster:

    $ postmaster &

7. Connect to PostgreSQL:

    $ psql template1

Source:

The PostgreSQL source builds OOTB under Cygwin.  Hence, the source has *not*
been modified in any way.  I only appended the following files to the original
source archive:

    CYGWIN-PATCHES/README
    CYGWIN-PATCHES/build.sh

I also renamed the original source archive to match Cygwin's setup.exe naming
conventions.

Build:

This distribution has been configured as follows:

    configure --with-CXX --prefix=/usr --sysconfdir=/etc --docdir=/usr/doc/postgresql-$version

where $version is the PostgreSQL version (e.g., 7.1).

See CYGWIN-PATCHES/build.sh in the source archive for my exact build
recipe for configuring, making, and packaging this distribution.

Test:

Cygwin PostgreSQL passes all regression tests with one socket related caveat
noted below.

Issues:

1. Cygwin PostgreSQL will *not* function properly with the Cygwin 1.1.8-2.
Replace your cygwin1.dll with one from a recent snapshot.

2. make check can generate spurious regression test failures due to overflowing
the the listen() backlog queue which generates connection refused errors.  Note
that make installcheck does not have this problem since it runs all tests
sequentially instead of in large concurrent groups.

3. The ESQL header file, sqlca.h, does not properly declare struct sqlca which
causes undefined reference errors when trying to link with libecpg.a.  See the
thread that begins at http://cygwin.com/ml/cygwin/2001-04/msg00827.html for
more details.

Homepage:

The primary PostgreSQL web site is:

    http://www.postgresql.org

Download:

The primary PostgreSQL ftp site is:

    ftp://ftp.postgresql.org

Mailing Lists:

Please report problems, suggestions, etc. dependent on their nature to one of
the following:

    pgsql-cygwin@postgresql.org
    cygwin@sources.redhat.com

Maintainer:

    Jason Tishler <Jason.Tishler@dothill.com>