Compile and run Postgres under Cygwin

From: "Torstein Meland" <torstein(dot)meland(at)mintra(dot)no>
To: <pgsql-cygwin(at)postgresql(dot)org>
Cc: Øystein Berg <oystein(dot)berg(at)mintra(dot)no>
Subject: Compile and run Postgres under Cygwin
Date: 2004-04-28 13:03:58
Message-ID: 553FAB4E43B1834F97C87A0B095563A412EE08@MAILSERVER.mintra.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hey,

I need to install a patched postgres on a Window 2003 server.

The patch I use allows PgSQL to make hierarchical queries as Oracle do.
Read http://gppl.terminal.ru/ for more information.

Postgres source code:
7.4.1

Patch:
hier-Pg7.4-0.5.2.tar.gz

What we did:
1. Installed cygwin _without_ postgres
2. Set up ipc-daemon2 service
3. uzipped postgres source code
4. patch -p0 < hier.diff
5. ./configure --with-java
6. make (as stated in postgresql-7.4/doc/FAQ_MSWIN)
7. make install
8. Log on as postgres:
9. initdb (parameters in /home/postgres/.bashrc)
--> Fail:
> postgres(at)campus-server /usr/local/pgsql
> $ initdb
> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> fixing permissions on existing directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... ok
> creating directory /usr/local/pgsql/data/pg_xlog... ok
> creating directory /usr/local/pgsql/data/pg_clog... ok
> selecting default max_connections... 10
> selecting default shared_buffers... 50
> creating configuration files... ok
> creating template1 database in /usr/local/pgsql/data/base/1... FATAL: semctl(18
> , 16, SETVAL, 536) failed: Invalid argument
>
> initdb: failed

The same error happens when we try the same thing without the patch.

Best regards
Torstein Meland
Mintra as
Storgata 1
P.O. Box 8945 Youngstorget
N-0028 Oslo
Tel: +47 24 15 55 00
Fax: +47 22 41 60 61
http://www.mintra.no

Med vennlig hilsen
Torstein Meland

Direct: +47 24 15 55 51
Mobile: +47 48 11 29 11
Mintra as
Storgata 1
P.O. Box 8945 Youngstorget
N-0028 Oslo
Tel: +47 24 15 55 00
Fax: +47 22 41 60 61
http://www.mintra.no

Browse pgsql-cygwin by date

  From Date Subject
Next Message Mike Preston 2004-04-29 16:32:35 postgresql date time at Cygwin On Windows 2000 - workaround available?
Previous Message Loren Betts 2004-04-27 22:31:10 pilot debug issue "localhost:2000: Operation not permitted"