Re: [BUGS] Problems with max_connections parameter

On Mon, Dec 13, 2010 at 8:46 PM, Jorge Augusto Meira wrote: > Have something else I can do to reach the limit of the parameter > max_connections? > > This may be a bug? Well, I don't think you've really identified what's happening. Kevin and Tom both suggested possible explanations upthread. --

Re: [BUGS] Problems with max_connections parameter

Hi again Have something else I can do to reach the limit of the parameter max_connections? This may be a bug? Thanks Jorge On Mon, Dec 6, 2010 at 1:31 PM, Tom Lane wrote: > Jorge Augusto Meira writes: >> The error message was: >> "Erro Conexão: A tentativa de conexão falhou." >> or >> "Erro C

Re: [BUGS] Problems with max_connections parameter

Hi, Euler - How could the test program know? The test program after any operation (inser, tupdate or select) receive a message of postgres like OK or ERROR (Connection error: FATAL). - Are you using some delay between one test and another one? I would be a good idea, specially if you're restarti

Re: [BUGS] Problems with max_connections parameter

Jorge Augusto Meira escreveu: > The test program is running in other 5 client machines. > In the logs of my test program, the max_connection parameter limit is > never reached. > How could the test program know? Indeed it doesn't. Are you using some delay between one test and another one? I would

Re: [BUGS] Problems with max_connections parameter

Hi Tom The test program is running in other 5 client machines. In the logs of my test program, the max_connection parameter limit is never reached. Regards Jorge On Mon, Dec 6, 2010 at 1:31 PM, Tom Lane wrote: > Jorge Augusto Meira writes: > > The error message was: > > "Erro Conexão: A tenta

Re: [BUGS] Problems with max_connections parameter

Jorge Augusto Meira writes: > The error message was: > "Erro Conexão: A tentativa de conexão falhou." > or > "Erro Conexão: FATAL: connection limit exceeded for non-superusers" Hmm ... I can't find the first of those anywhere in the 8.4 message lists; but the second one definitely says that you *

Re: [BUGS] Problems with max_connections parameter

Hi Thanks for the answers. Really, I didn't showed you basic informations. I used the PostgreSQL 8.4. The server configuration was: Processor: Intel Xeon Processor W3570 Quad Core Processor Mem: 20GB Network Interface: Gigabit HD: 12 x 1 TB (RAID1+0) OS: Debian

Re: [BUGS] Problems with max_connections parameter

Euler Taveira de Oliveira wrote: > Talking about your problem, are you sure you're not reaching > max_connections? It also strikes me that from the minimal information given, it might be possible that pid numbers or port numbers are wrapping around before the OS is ready to allow re-use. I h

Re: [BUGS] Problems with max_connections parameter

Jorge Augusto Meira escreveu: > This is a bug? > You don't provide sufficient information. PostgreSQL version? Error message? Talking about your problem, are you sure you're not reaching max_connections? Did you check the logs? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent

[BUGS] Problems with max_connections parameter

Hi all, I am a master student on database systems and I'm working on a stress testing methodology. The goal is to stress testing PostgreSQL under different workloads. Thus, I would like to discuss with you some results. My methodology is based on the increment of two variables: complexity and wor