Re: Renaming a DB

Hi,

I have in my logs the following lines :

jui  7 10:40:07 poseidon logger: FATAL:  Non-superuser connection
limit exceeded
jui  7 10:40:44 poseidon logger: LOG:  pq_recvbuf: unexpected EOF
on client connection
jui  7 10:40:53 poseidon last message repeated 23 times



What does it means ? Particulary the "pg_recvbuf" line ?

when this happen, DB is very very very slow and I have to restart it...

Version is 7.3.2 on a dual 2Ghz Xenon with 1go RAM, SCSI RAID 1
drives, Red Hat 8.0
Buffers are set to -B90846
Num of postgres is -N255
And sort meme is -S131072

There are a lot of updates and select on this DB.
Numbers of transaction/sec is approx. 60.

We do a vacuum -v -a -z every 12 hours
and a full vacuum each week.

Thanks for your help !


Jean-Arthur Silve
EuroVox
4, Place Félix Eboué
75583 Paris Cedex 12
T : +33 1 44670505
F : +33 1 44670519