Re: Help w/ initdb hanging - Mailing list pgsql-cygwin
From | renyu teng |
---|---|
Subject | Re: Help w/ initdb hanging |
Date | |
Msg-id | 20011120133351.68745.qmail@web20210.mail.yahoo.com Whole thread Raw |
In response to | Help w/ initdb hanging ("Markus Wollny" <Markus.Wollny@computec.de>) |
List | pgsql-cygwin |
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
pgsql-cygwin by date: