RE: initdb failure - postgres hangs with 100% CPU - Mailing list pgsql-cygwin

From Jon Williams
Subject RE: initdb failure - postgres hangs with 100% CPU
Date
Msg-id 000001c0fff0$7b00ae50$386870ce@herbgotti
Whole thread Raw
In response to initdb failure - postgres hangs with 100% CPU  (Michael Williams <lamwilli@yahoo.com>)
List pgsql-cygwin
You need to have ipc-daemon running 1st

I found these 2 url's to be very informative.
http://people.freebsd.org/~kevlo/postgres/portNT.html
http://ontosys.com/reports/postgresql.html

Jon



-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of Michael Williams
Sent: Thursday, June 28, 2001 3:18 PM
To: pgsql-cygwin@postgresql.org
Cc: cygwin@sources.redhat.com
Subject: [CYGWIN] initdb failure - postgres hangs with 100% CPU

I am attempting to create a postgresql database under
cygwin:

$ uname -a
CYGWIN_NT-4.0 WCA22291271 1.3.2(0.39/3/2) 2001-05-20
23:28 i686 unknown

on a WinNT Workstation. WinNT 4.0 SP5

$ echo $PGDATA
/usr/share/postgresql/data

nbk3r4y@WCA22291271 ~
$ initdb -d > initdb.log 2>&1 &
[2] 213

nbk3r4y@WCA22291271 ~
$ tail -f initdb.log

PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
This database system will be initialized with username
"nbk3r4y".
This user will own all the data files and must also
own the server process.

Creating directory /usr/share/postgresql/data
Creating directory /usr/share/postgresql/data/base
Creating directory /usr/share/postgresql/data/global
Creating directory /usr/share/postgresql/data/pg_xlog
Creating template1 database in
/usr/share/postgresql/data/base/1
Running: /usr/bin/postgres -boot -x1 -C -F
-D/usr/share/postgresql/data -d templ
ate1

At this point the NT system hangs.  The Win Task
manager shows the proesser pegged at 100% utilization
by initdb.  cgywin "top" tells the same story.

  %   Pid  Tid  Pri      Key    Start Address
ImageName
___________________________________________________________________

  99%     340     609 2502656 2195456   0:00:45.745
postgres.exe
   0%      30    4529 1118208 1605632   0:00:07.671
CSRSS.EXE

initdb never comes back.

This user ID has NT local administrator rights.

Please let me know why postgres is dieing at this
point.

Thanks,

Michael Williams


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


pgsql-cygwin by date:

Previous
From: Michael Williams
Date:
Subject: initdb failure - postgres hangs with 100% CPU
Next
From: Fred Yankowski
Date:
Subject: new '--shutdown' option for cygrunsrv