Re: Load problems... - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Load problems...
Date
Msg-id 20011218215658.O67016-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Load problems...  (Daniel Andersen <zedar@free2air.com.au>)
List pgsql-admin
> sort_mem = 1024
> shared_buffers = 2048 (tried higher, but didnt' seem to improve anything)
> max_connections = 300
>
> error message just comes out of the blue, the database is chugging along
> happily and then suddenly[4059]   DEBUG:  connection startup failed (fork
> failure): Resource temporarily unavailable
> [4059]   DEBUG:  connection startup failed (fork failure): Resource
> temporarily unavailable
> [4059]   DEBUG:  could not launch checkpoint process (fork failure): Resource
> temporarily unavailable
> [4059]   DEBUG:  connection startup failed (fork failure): Resource
> temporarily unavailable
> [4059]   DEBUG:  connection startup failed (fork failure): Resource
> temporarily unavailable

Sounds like fork returning EAGAIN.
What does ulimit -a show for the postgres user?



pgsql-admin by date:

Previous
From: Daniel Andersen
Date:
Subject: Re: Load problems...
Next
From: Tom Lane
Date:
Subject: Re: Load problems...