posgresql on Windows XP

Lists: pgsql-cygwin
From: Nyo Maw <nyo_maw(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: posgresql on Windows XP
Date: 2003-02-25 06:06:22
Message-ID: 20030225060622.76744.qmail@web14705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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/


From: Jason Tishler <jason(at)tishler(dot)net>
To: Nyo Maw <nyo_maw(at)yahoo(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: posgresql on Windows XP
Date: 2003-02-26 12:36:41
Message-ID: 20030226123641.GB772@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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