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

Re: Help w/ initdb hanging - found a solution!

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Help w/ initdb hanging - found a solution!
Date: 2001-11-20 09:43:44
Message-ID: (view raw or flat)
Lists: pgsql-cygwin
Hmm - I sent this mail last friday and now it turns up in my inbox - on
tuesday: That's one hell of a lagmonster... *g*

I've managed to solve the problem by now by myself - the installation
procedure is somewhat different on Win2K Server than on Win2K
Professional; on Win2K Professional I didn't have any problems getting
PostgreSQL to run according to the instructions in the
postgresql-7.1.3.README, although this in itself already lacks the
"mkpasswd -l >/etc/passwd"-step to update the cygwin-password-file. The
very same procedure fails however on Win2K-Server and I still do not
know why this happens; I tested it on three different
Win2K-Server-installations, so it seems to me that this behaviour is

In order to get initdb to complete under Win2K-Server, I needed to
modify the procedure a bit. Before running the initdb -D
/usr/share/postgresql/data line, I stopped the Cygwin IPC Daemon service
('net stop ipc-daemon'), then started the daemon as independent process
in cygwin ('$ ipc-daemon &'), then did the initdb ('initdb -D
/usr/share/postgresql/data'), which now completed flawlessly, killed the
ipc-daemon process directly afterwards ('$ ps ax|grep ipc', 'kill PID')
and started up the IPC daemon as service again ('net start ipc-daemon').

This is how it actually worked for me under Win2K-server. Any attempt to
initdb with the Cygwin IPC-Daemon running as service resulted in a
hanging initdb-process, which never ever completed. On Win2k
Professional, initdb doesn't mind the IPC-Daemon running as service or
otherwise, as long as it is running at all, it's only Win2K Server which
is a bit fussy about this issue.

I hope this info may help some in the installation process; I'm
currently writing detailed german instructions on how to get PostgreSQL
running under Win2k, so if anyone's interested you may send me a mail.



-----Urspr√ľngliche Nachricht-----
Von: Markus Wollny 
Gesendet: Freitag, 16. November 2001 14:49
An: pgsql-cygwin(at)postgresql(dot)org
Betreff: [CYGWIN] Help w/ initdb hanging


I think I followed the instructions in postgresql-7.1.3.README.txt to
the letter, but I just cannot get PostgreSQL to run on my Win2k-servers.
I read through the relevant articles in the mailinglist-archive and
searched the FAQs, but I couldn't find anything on the issue. Here's
what I did:

- I downloaded and installed the latest release of cygwin from (used ftp of as local mirror), including
the postgres-package.
- Then I downloaded the cygipc-V1.1-package, unpacked it and started the
ipc-daemon as a service (running now without complaints).
- I created a user postgres, granted right to start as service, to
change quotas, to run as part of the os and change token on
- Then I did a mkpasswd -l >/etc/passwd.
- I created a directory /usr/share/postgresql/data and chown'ed it to
the postgres user.
- I started up the postmaster as NT service using cygrunsrv --install
--path /usr/bin/postmaster --args -"-D /usr/share/postgresql/data -i"
--dep ipc-daemon --termsig INT --user postgres --shutdown
Still no worries, was asked for a password twice after issuing the last
command and provided the NT-userpassword for the user postgres.
- Logged out as Administrator and logged back in as postgres-user.
- Then I called up initdb -d -D /usr/share/postgresql/data - and the
cygwin shell just hangs. Taskmanager shows postgres.exe running and
consuming some processor time, but the initdb just doesn't finish. Last
message displayed when in debug-mode is "Running: /usr/bin/postgres
-boot -x1 -C _F -D/usr/share/postgresql/data -d template1"

Service manager shows ipc-daemon running, whereas postmaster is just
listed as "Automatically", but refuses to start when I try to start it
(postmaster couldn't be started. It didn't give any error messages.)

Funny thing is, I did succeed in getting PostgreSQL to install and run
on my Windows 2000 Professional box using the very same procedure - i
didn't change one bit! It just plainly refuses to succeed on Windows
2000 Server. For a production-environment I need it to run on
Win2k-Server though and I need to get it to run fast!

I should be a happy man if anycould could help me with this quickly,
please, please, please? :)

The cygcheck -s comes up with a report which just doesn't give me any
clues as to the differences between my Win2kP-box and the Win2k-servers,
the reports are both the same(except drives and Win2k-Version).



Any help, as said before, would be very much appreciated. Here goes the

Cygnus Win95/NT Configuration Diagnostics
Current System Time: Fri Nov 16 12:33:45 2001

Windows 2000 Server Ver 5.0 build 2195 Service Pack 2

Path:	C:\cygwin\usr\local\bin

SysDir: C:\WINNT\System32
WinDir: C:\WINNT

HOME = `C:\cygwin\home\Administrator'
MAKE_MODE = `unix'
PWD = `/home/Administrator'
USER = `Administrator'

Use `-r' to scan registry

a:  fd           N/A    N/A                    
c:  hd  NTFS    6000Mb  46% CP CS UN PA FC     System
d:  hd  NTFS   63099Mb   5% CP CS UN PA FC     Daten
e:  cd           N/A    N/A                    
g:  net NTFS   95652Mb  45% CP CS UN PA FC     Storage
z:  net NTFS   95652Mb  45% CP CS UN PA FC     Storage

.                   /cygdrive                   user    binmode,noumount
C:/cygwin           /                           system  binmode
C:/cygwin/bin       /usr/bin                    system  binmode
C:/cygwin/lib       /usr/lib                    system  binmode
D:\postgresql\data  /usr/share/postgresql/data  system  binmode

Found: C:\cygwin\bin\bash.exe
Found: C:\cygwin\bin\cat.exe
Found: C:\cygwin\bin\cpp.exe
Found: C:\cygwin\bin\find.exe
Found: C:\cygwin\bin\gcc.exe
Found: C:\cygwin\bin\gdb.exe
Found: C:\cygwin\bin\ld.exe
Found: C:\cygwin\bin\ls.exe
Found: C:\cygwin\bin\make.exe
Found: C:\cygwin\bin\sh.exe

   56k 2000/12/03 C:\cygwin\bin\cygbz21.0.dll
   45k 2001/04/25 C:\cygwin\bin\cygform5.dll
   34k 2001/09/30 C:\cygwin\bin\cygform6.dll
   18k 2000/10/23 C:\cygwin\bin\cyggdbm.dll
   17k 2001/06/28 C:\cygwin\bin\cyghistory4.dll
   21k 2001/06/28 C:\cygwin\bin\cyghistory5.dll
   21k 2001/06/20 C:\cygwin\bin\cygintl.dll
   81k 2001/10/20 C:\cygwin\bin\cygitcl30.dll
   35k 2001/10/20 C:\cygwin\bin\cygitk30.dll
   45k 2001/07/04 C:\cygwin\bin\cygjbig1.dll
  119k 2000/10/23 C:\cygwin\bin\cygjpeg6b.dll
   26k 2001/04/25 C:\cygwin\bin\cygmenu5.dll
   19k 2001/09/30 C:\cygwin\bin\cygmenu6.dll
  156k 2001/04/25 C:\cygwin\bin\cygncurses++5.dll
  175k 2001/09/30 C:\cygwin\bin\cygncurses++6.dll
  226k 2001/04/25 C:\cygwin\bin\cygncurses5.dll
  201k 2001/09/30 C:\cygwin\bin\cygncurses6.dll
   15k 2001/04/25 C:\cygwin\bin\cygpanel5.dll
   12k 2001/09/30 C:\cygwin\bin\cygpanel6.dll
  163k 2001/05/06 C:\cygwin\bin\cygpng2.dll
  108k 2001/06/28 C:\cygwin\bin\cygreadline4.dll
  135k 2001/06/28 C:\cygwin\bin\cygreadline5.dll
  390k 2001/10/20 C:\cygwin\bin\cygtcl80.dll
    5k 2001/10/20 C:\cygwin\bin\cygtclpip80.dll
   10k 2001/10/20 C:\cygwin\bin\cygtclreg80.dll
  245k 2001/06/12 C:\cygwin\bin\cygtiff3.dll
  623k 2001/10/20 C:\cygwin\bin\cygtk80.dll
   41k 2001/07/04 C:\cygwin\bin\cygXpm-noX4.dll
   45k 2001/07/04 C:\cygwin\bin\cygXpm-X4.dll
   49k 2001/02/03 C:\cygwin\bin\cygz.dll
  714k 2001/11/14 C:\cygwin\bin\cygwin1.dll
    Cygwin DLL version info:
        DLL version: 1.3.5
        DLL epoch: 19
        DLL bad signal mask: 19005
        DLL old termios: 5
        DLL malloc env: 28
        API major: 0
        API minor: 47
        Shared data: 3
        DLL identifier: cygwin1
        Mount registry: 2
        Cygnus registry name: Cygnus Solutions
        Cygwin registry name: Cygwin
        Program options name: Program Options
        Cygwin mount registry name: mounts v2
        Cygdrive flags: cygdrive flags
        Cygdrive prefix: cygdrive prefix
        Cygdrive default prefix: 
        Build date: Tue Nov 13 23:16:25 EST 2001
        CVS tag: cygwin-1-3-5-2
        Shared id: cygwin1S3

Cygwin Package Information
Package             Version             
ash                 20011018-1          
autoconf            2.52-1              
automake            1.5-1               
bash                2.05a-1             
binutils            20011002-1          
bison               1.28-1              
byacc               0.0                 
bzip2               1.0.1-6             
clear               1.0                 
cpio                2.4.2               
cron                3.0.1-5             
crypt               1.0                 
ctags               5.0.1-1             
cvs                 1.11.0-1            
cygrunsrv           0.94-2              
cygwin              1.3.5-3             
dejagnu             20010117-1          
diff                0.0                 
expect              0.0                 
file                3.33-1              
fileutils           4.1-1               
findutils           0.0                 
flex                2.5.4-1             
gawk                3.0.4-1             
gcc                 2.95.3-5            
gdb                 20010428-3          
gdbm                1.8.0-3             
gettext             0.10.38-2           
ghostscript         6.51-1              
gperf               0.0                 
grep                2.4.2-1             
groff               1.16.1-1            
gzip                1.3-1               
inetutils           1.3.2-15            
irc                 20010101-1          
jbigkit             1.2-4               
jpeg                6b-3                
less                358-3               
libncurses5         5.2-1               
libncurses6         5.2-2               
libpng              1.0.11-1            
login               1.4-2               
lynx                2.8.4-1             
m4                  0.0                 
make                3.79.1-4            
man                 1.5g-2              
mingw               20010917-1          
mingw-runtime       1.1-1               
mt                  2.0.1-1             
mutt                1.2.5i-5            
ncftp               3.0.2-2             
ncurses             5.2-7               
newlib-man          20001118-1          
opengl              1.1.0-5             
openssh             3.0p1-1             
openssl             0.9.6b-1            
patch               2.5-2               
perl                5.6.1-1             
postgresql          7.1.3-1             
python              2.1.1-2             
readline            4.2-3               
rsync               2.4.6-2             
rxvt                2.7.2-6             
sed                 3.02-1              
sh-utils            2.0-2               
squid               2.4-STABLE20010508  
ssmtp               2.38.7-3            
tar                 1.13.19-1           
tcsh                6.10.00-3           
termcap             20010825-1          
terminfo            5.2-1               
tetex-beta          20001218-1          
texinfo             4.0-4               
textutils           2.0.16-1            
tiff                3.5.6beta-2         
time                1.7-1               
unzip               5.41-1              
vim                 6.0.93-1            
w32api              20010520-1          
wget                1.7-1               
which               1.5-1               
xpm-nox             4.1.0-1             
zip                 2.3-1               
zlib                1.1.3-6             

Use -h to see help about each section

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

pgsql-cygwin by date

Next:From: renyu tengDate: 2001-11-20 13:33:51
Subject: Re: Help w/ initdb hanging
Previous:From: Dave PageDate: 2001-11-20 08:49:40
Subject: Re: Help with Cygwin/Postgres

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