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

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
reproducable.

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.

Greetings,

Markus

-----Ursprüngliche Nachricht-----
Von: Markus Wollny
Gesendet: Freitag, 16. November 2001 14:49
An: pgsql-cygwin@postgresql.org
Betreff: [CYGWIN] Help w/ initdb hanging


Hello!

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
www.cygwin.com (used ftp of tu.dresden.de 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
process-level.
- 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).

Greetings,

    Markus

Any help, as said before, would be very much appreciated. Here goes the
diagnostics-stuff:

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
    C:\cygwin\bin
    C:\cygwin\bin
    C:\cygwin\bin
    d:\Perl\bin\
    c:\WINNT\system32
    c:\WINNT
    c:\WINNT\System32\Wbem
    .

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@postgresql.org