Re: initdb failing

Ensure that you have the following set before starting
the cygserver:

export CYGWIN=server

That should fix the problem. I had a problem similar
to yours and Daniel Secomb provided that solution and
that got me up and running with the PostgreSQL db.

Good luck.
-SR
--- Hussein Badakhchani <hussein(at)xensia(dot)com> wrote:

> Hello
>
> My platform is:
>
> Windows 2000 sp4
> Cygwin 1.5.10-3
> Postgresql 7.4.3.1
>
> As per the instructions I start cygserver in the
> background and then run
> initdb:
>
> v&p(dot)test(at)DOW2K00028396 ~
> $ initdb -d -D /usr/local/pgsql/data
> Running in debug mode.
>
> initdb: internal variables:
> PGDATA=/usr/local/pgsql/data
> datadir=/usr/share/postgresql
> PGPATH=/usr/bin
> ENCODING=
> ENCODINGID=0
> POSTGRES_SUPERUSERNAME=v&p.test
> 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 "v&p.test".
> This user must also own the server process.
>
> The database cluster will be initialized with locale
> C.
>
> creating 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... 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/local/pgsql/data/base/1... DEBUG:
> invoking
> IpcMemoryCreate(size=1081344)
> Signal 12
>
> initdb: failed
> initdb: removing data directory
> "/usr/local/pgsql/data"
>
> Cygcheck:
>
> Cygwin Package Information
> Package Version Status
> _update-info-dir 00227-1 OK
> ash 20040127-1 OK
> base-files 2.6-1 OK
> base-passwd 1.1-1 OK
> bash 2.05b-16 OK
> bzip2 1.0.2-5 OK
> crypt 1.1-1 OK
> cygipc 2.03-2 OK
> cygrunsrv 1.0-1 OK
> cygutils 1.2.5-1 OK
> cygwin 1.5.10-3 OK
> cygwin-doc 1.3-7 OK
> diffutils 2.8.7-1 OK
> editrights 1.01-1 OK
> fileutils 4.1-2 OK
> findutils 4.1.7-4 OK
> gawk 3.1.4-3 OK
> gdbm 1.8.3-7 OK
> grep 2.5-1 OK
> groff 1.18.1-2 OK
> gzip 1.3.5-1 OK
> less 381-1 OK
> libbz2_1 1.0.2-5 OK
> libgdbm 1.8.0-5 OK
> libgdbm-devel 1.8.3-7 OK
> libgdbm3 1.8.3-3 OK
> libgdbm4 1.8.3-7 OK
> libgettextpo0 0.14.1-1 OK
> libiconv2 1.9.2-1 OK
> libintl1 0.10.40-1 OK
> libintl2 0.12.1-3 OK
> libintl3 0.14.1-1 OK
> libncurses5 5.2-1 OK
> libncurses6 5.2-8 OK
> libncurses7 5.3-4 OK
> libpcre 4.1-1 OK
> libpcre0 4.5-1 OK
> libpopt0 1.6.4-4 OK
> libreadline4 4.1-2 OK
> libreadline5 4.3-5 OK
> login 1.9-7 OK
> man 1.5k-3 OK
> mktemp 1.5-3 OK
> ncurses 5.3-4 OK
> openssl 0.9.7d-1 OK
> postgresql 7.4.3-1 OK
> readline 4.3-5 OK
> sed 4.0.9-2 OK
> sh-utils 2.0.15-4 OK
> tar 1.13.25-5 OK
> termcap 20021106-2 OK
> terminfo 5.3_20030726-1 OK
> texinfo 4.2-4 OK
> textutils 2.0.21-1 OK
> vim 6.3-1 OK
> which 1.5-2 OK
> zlib 1.2.1-1 OK
>
> I have installed postgresql on cygwin in the past no
> problem, this is the
> first time have come across this error. When I
> installed cygwin I had some
> jip regarding users and had to update my /etc/passwd
> file:
>
> SYSTEM:*:18:544:,S-1-5-18::
> Administrators:*:544:544:,S-1-5-32-544::
>
bacs_admin:unused_by_nt/2000/xp:500:513:U-DOW2K00028396\bacs_admin,S-1-5-21-2016
>
221598-611480373-1244091144-500:/home/bacs_admin:/bin/bash
>
bacs_guest:unused_by_nt/2000/xp:501:513:U-DOW2K00028396\bacs_guest,S-1-5-21-2016
>
221598-611480373-1244091144-501:/home/bacs_guest:/bin/bash
> v&p.test:*:502:545:/home/v&p.test:/bin/bash
>
> Thaks
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail