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