Skip site navigation (1) Skip section navigation (2)

Re: initdb failing

From: "Leeuw van der, Tim" <tim(dot)leeuwvander(at)nl(dot)unisys(dot)com>
To: "Hussein Badakhchani" <hussein(at)xensia(dot)com>,<pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: initdb failing
Date: 2004-08-06 10:14:43
Message-ID: BF88DF69D9E2884B9BE5160DB2B97A85010D6CC7@nlshl-exch1.eu.uis.unisys.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi,

As Mike G said, remove ipc-daemon (all versions). Perhaps re-install cygwin-1.5.10-3 afterwards (only that package); there have 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 to permission problems.

--Tim

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of Hussein
Badakhchani
Sent: donderdag 5 augustus 2004 14:54
To: pgsql-cygwin(at)postgresql(dot)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(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

pgsql-cygwin by date

Next:From: Leeuw van der, TimDate: 2004-08-06 10:18:00
Subject: Re: PostgreSQL in Windows2000 PRO
Previous:From: Leeuw van der, TimDate: 2004-08-06 10:12:43
Subject: Re: Help with initdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group