I had the same problem, it took me 2 days to figure it out.
My problem was the enviroment variable in windows (CYGWIN=server). When you
install cyrserver it writes out thet he needs this variable. So put this
enviroment variable.
Look in the document: /usr/share/doc/cygwin/postgresql-7.4.3.README at the
special instructions(chmod for the temp dir and /usr/bin etc).
Hope this helps.
Andy.
----- Original Message -----
From: "Jean-François Trevien" <jftrevien@free.fr>
To: <pgsql-cygwin@postgresql.org>
Sent: Tuesday, July 06, 2004 9:06 PM
Subject: [CYGWIN] problem installing postgresql
> Hello,
>
> After digging a lot, i discover that the initdb fail to do his job:
>
> $ initdb -U postgres -D /usr/share/postgresql/data2 -W -E LATIN1 -d
> Running in debug mode.
>
> initdb: internal variables:
> PGDATA=/usr/share/postgresql/data2
> datadir=/usr/share/postgresql
> PGPATH=/usr/bin
> ENCODING=LATIN1
> ENCODINGID=8
> POSTGRES_SUPERUSERNAME=postgres
> POSTGRES_BKI=/usr/share/postgresql/postgres.bki
> POSTGRES_DESCR=/usr/share/postgresql/postgres.description
> POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
> PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
> PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
> The files belonging to this database system will be owned by user "jeff".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> fixing permissions on existing directory /usr/share/postgresql/data2... ok
> creating directory /usr/share/postgresql/data2/base... ok
> creating directory /usr/share/postgresql/data2/global... ok
> creating directory /usr/share/postgresql/data2/pg_xlog... ok
> creating directory /usr/share/postgresql/data2/pg_clog... ok
> selecting default max_connections... Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> 10
> selecting default shared_buffers... Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> 50
> creating configuration files... ok
> creating template1 database in /usr/share/postgresql/data2/base/1...
> DEBUG: invoking IpcMemoryCreate(size=1081344)
> Signal 12
>
> initdb: failed
>
> Anyone as an idea?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings