Re: initdb failing - Mailing list pgsql-cygwin

From Leeuw van der, Tim
Subject Re: initdb failing
Date
Msg-id BF88DF69D9E2884B9BE5160DB2B97A85010D6CC7@nlshl-exch1.eu.uis.unisys.com
Whole thread Raw
In response to initdb failing  ("Hussein Badakhchani" <hussein@xensia.com>)
List pgsql-cygwin
Hi,

As Mike G said, remove ipc-daemon (all versions). Perhaps re-install cygwin-1.5.10-3 afterwards (only that package);
therehave been some conflicts between executable names in cygipc and the ipc of cygwin-server. 

Then check that the cygserver is actually really truly running. Either you forgot to start it, or it fails to start due
topermission problems. 

--Tim

-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Hussein
Badakhchani
Sent: donderdag 5 augustus 2004 14:54
To: pgsql-cygwin@postgresql.org
Subject: [CYGWIN] initdb failing


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

pgsql-cygwin by date:

Previous
From: "Leeuw van der, Tim"
Date:
Subject: Re: Help with initdb
Next
From: "Leeuw van der, Tim"
Date:
Subject: Re: PostgreSQL in Windows2000 PRO