Thread: 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
I could start ipc-daemon as service daemon. Everytime I have to start it manually after rebooting my machine, just wonder whether I could manually add it to the service. My system. win2k prof. I have briefly gone through the manual and could find any useful info, so I give up. Not sure whether someone has tried it. thanks teng --- Markus Wollny <Markus.Wollny@computec.de> wrote: > 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 > > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1