Hm, that's a rather odd error code, but I suppose it must mean that you have run out of kernel memory for file descriptor slots or inodes.
Yep, after checking with the co-location techs the limit of open file on my Virtual Server is 2479. They've upped the limit to 3718 for me.
This server is running serveral servers which all need to share the limited
amount of kernel memory allocated to my Virtual setup.
I want to power about a dozen Postgres driven web application on this machine so I have running: Postgresql,Apache,FTP,Bind,Sendmail with PHP.
Note that you could also attack this by increasing the kernel filetable size
In this case, Virtual Server, I'm not able to alter Kernel settings.
max_files_per_process
Doh ! Sorry I should have looked first.
Many thanks Best Regards Rudi.
Tom Lane wrote:
Rudi Starcevic <[EMAIL PROTECTED]> writes:
ERROR: _mdfd_getrelnfd: cannot open relation virtualusertable: Cannot allocate memory
Hm, that's a rather odd error code, but I suppose it must mean that you have run out of kernel memory for file descriptor slots or inodes.
I'd like to try limiting the amount of files per process.
Is there an option I can configure to do this ??
max_files_per_process. If you don't have it you need a newer version of Postgres.
Note that you could also attack this by increasing the kernel filetable size; I forget exactly how to do that in Linux, but it is possible.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html