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@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
