[ADMIN] postmaster -> !!!

1999-12-14 Thread Diego Mauricio Garcia
Hi. The process generated for postmaster become zombies, when the process are more than 30!!! then: kill -1 therefore: the process restore Note:The postmaster is initialized with: postmaster -i -B 256 -o -S & The system is: PENTIUM ii 233Mhz,

[ADMIN] Postgres overloaded..

1999-12-14 Thread Lucio Andres Perez
Hi everyone, Maybe this could be a newbie trouble for somebody, but I´ve tried all I can and I haven´t found the source of my problem... I have a PII-400Mhz 192Mb RedHat 5.2 ( I know, it´s a little old ) running only postgresql 6.4, the apache/php servers are running in other host. the problem

Re: [ADMIN] Postgres overloaded..

1999-12-14 Thread Tim Holloway
Something's funny here. Unless you built a backend with an override on the default max backend count, you should be able to create no more than 32 backend processes. Which is possible also if you installed an RPM version and it's built for more than 32. Otherwise you should see the message "Sorry,

Re: [ADMIN] Postgres overloaded..

1999-12-14 Thread Lucio Andres Perez
Hi Tim I did it as you said me and I got the following results when the database coming down: [postgres@postgres pgsql]$ ps aux | grep postmaster postgres 6616 0.0 0.0 0 0 p4 Z20:05 0:00 (postmaster ) postgres 6650 0.0 0.0 0 0 p4 Z20:11 0:00 (postmaster ) post

Re: [ADMIN] Postgres overloaded..

1999-12-14 Thread Tim Holloway
Lucio Andres Perez wrote: > > Hi Tim > > I did it as you said me and I got the following results when the database > coming down: > > [postgres@postgres pgsql]$ ps aux | grep postmaster > postgres 6616 0.0 0.0 0 0 p4 Z20:05 0:00 (postmaster > ) > postgres 6650 0.0 0.0