[ADMIN] Process Files

2003-11-05 Thread Rudi Starcevic
Hi, I'm moving a Postgresql database onto a co-located server - a Linux Virtual Server. Today I got some error's in my logs: ERROR: _mdfd_getrelnfd: cannot open relation virtualusertable: Cannot allocate memory If I reboot it goes away but has been reappearing. I'd like to try limiting the a

Re: [ADMIN] Process Files

2003-11-06 Thread Tom Lane
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 limit

Re: [ADMIN] Process Files

2003-11-06 Thread Rudi Starcevic
Thanks Tom, 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 se