Re: Help w/ initdb hanging

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(dot)Wollny(at)computec(dot)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