Thread: posgresql on Windows XP

posgresql on Windows XP

From
Nyo Maw
Date:
Hi All,

I am trying to install the postgres in the Cygwin with
Windows XP Professional . I have followed all steps ,
starting ipc-daemon, initdb. I got the errors when I
run postmaster as follows :

$ postmaster -D /usr/share/postgresql/data
LOG:  database system was interrupted at 2003-02-22
20:15:41 PST
LOG:  checkpoint record is at 0/841498
LOG:  redo record is at 0/841498; undo record is at
0/0; shutdown TRUE
LOG:  next transaction id: 487; next oid: 25168
LOG:  database system was not properly shut down;
automatic recovery in progress
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 3452) exited
with exit code 1
LOG:  ReadRecord: record with zero length at 0/8414D8
LOG:  redo is not required
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 1048) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 1588) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 2940) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 1340) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 1392) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 2912) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 1176) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 2800) exited
with exit code 1

db was ready after some time but , CPU usage goes up
to 100%.

Please help how to fix it.

Thanks
Nyo


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

Re: posgresql on Windows XP

From
Jason Tishler
Date:
Nyo,

On Mon, Feb 24, 2003 at 10:06:22PM -0800, Nyo Maw wrote:
> LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable

The above is bad.  You need to figure out what is causing the EAGAIN
error condition.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6