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

Re: Help w/ initdb hanging

From: renyu teng <renyu_teng(at)yahoo(dot)com>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Help w/ initdb hanging
Date: 2001-11-20 13:33:51
Message-ID: 20011120133351.68745.qmail@web20210.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(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

In response to

pgsql-cygwin by date

Next:From: Sergio RamosDate: 2001-11-21 01:16:08
Subject: A php and cygwin-psql doubt
Previous:From: Markus WollnyDate: 2001-11-20 09:43:44
Subject: Re: Help w/ initdb hanging - found a solution!

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